Search Results supplier

The JE_IT_SETUP_HDR_ALL table in Oracle EBS (Release 12.1.1 or 12.2.2) is a critical repository for Italian localization setup data, primarily used for managing statutory and regulatory requirements specific to Italy. This table stores header-level information for Italian Electronic Invoicing (FatturaPA), tax reporting (Spesometro), and other fiscal compliance configurations mandated by the Italian government. As part of Oracle's localization framework, it ensures adherence to Agenzia delle Entrate (Italian Revenue Agency) regulations while integrating seamlessly with Oracle General Ledger, Accounts Payable, and Accounts Receivable modules.

Table Structure and Key Columns

The JE_IT_SETUP_HDR_ALL table contains these essential columns:

SETUP_ID: Primary key identifier for each configuration record
LEGAL_ENTITY_ID: References the legal entity to which the setup applies
TAXPAYER_TYPE: Classifies the entity (e.g., Individual, Corporation)
FISCAL_CODE: Codice Fiscale (Italian tax identification number)
VAT_REGISTRATION_NUM: Partita IVA (VAT registration number)
REA_CODE: Economic and Administrative Index code
FATTURA_PA_FLAG: Indicates Electronic Invoicing activation (Y/N)
SDI_CHANNEL_CODE: Sistema di Interscambio (SDI) transmission channel
LAST_UPDATE_DATE: Timestamp for record maintenance

Functional Integration

This table integrates with multiple EBS components:

Electronic Invoicing (FatturaPA): When FATTURA_PA_FLAG='Y', the system generates XML invoices compliant with Italian Format 1.2 or 1.2.1 specifications.
Tax Reporting: Provides taxpayer details for Spesometro (VAT transactions listing) and Intrastat declarations.
Payment Processing: Links to Italian payment terms like RiBa (Ricevuta Bancaria) through subsidiary tables.

Technical Implementation

In Oracle EBS 12.2.2, the table leverages Application Development Framework (ADF) for UI rendering through the JEITSPH form. Key technical aspects include:

Multi-Org access control via _ALL suffix
PL/SQL validation in JE_IT_SETUP_PKG for Codice Fiscale/Partita IVA formatting
Web service integration points for SDI communication

Compliance Features

The table supports these Italian regulatory requirements:

Requirement	Implementation
DL 127/2015 (FatturaPA)	Stores XML schema version and SDI credentials
Province Code Validation	Integrates with `JE_IT_PROVINCE_CODES`
Split Payment Regime	Flags for reverse charge mechanisms

Customization Considerations

Extensions to this table require careful analysis due to:

Dependencies on Oracle's localization certification for Italy
Integration with third-party SDI intermediaries
Quarterly updates to accommodate Italian tax law changes

The JE_IT_SETUP_HDR_ALL table exemplifies Oracle's approach to country-specific localization, combining regulatory compliance with technical extensibility while maintaining core application integrity.

Lookup Type: JE_ITWHYE_ORDER_BY 12.2.2
product: JE - European Localizations , meaning: JE_ITWHYE_ORDER_BY , description: Order by Supplier Name,Supplier Vat Reg. Number,Supplier Tax Payer Id ,
Lookup Type: JEIT_VEND_SORT_COLS 12.1.1
product: JE - European Localizations , meaning: Italian Annual Supplier Listing Sort Columns , description: Italian Annual Supplier Listing Sort Columns ,
Lookup Type: JEIT_VEND_SORT_COLS 12.2.2
product: JE - European Localizations , meaning: Italian Annual Supplier Listing Sort Columns , description: Italian Annual Supplier Listing Sort Columns ,
Concurrent Program: JEPLPSSR 12.1.1
execution_filename: JEPLPSSR , product: JE - European Localizations , user_name: JEPLPSSR , description: Polish Supplier Statement , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEPLPSSR 12.2.2
execution_filename: JEPLPSSR , product: JE - European Localizations , user_name: JEPLPSSR , description: Polish Supplier Statement , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: JEDE_TAX_NAME 12.2.2
product: JE - European Localizations , meaning: JEDE TAX NAME , description: Contra Order ,
Lookup Type: JEDE_TAX_NAME 12.1.1
product: JE - European Localizations , meaning: JEDE TAX NAME , description: Contra Order ,
Concurrent Program: JEITLST 12.1.1
execution_filename: JE_IT_LISTING_PKG.EXTRACT_DATA , product: JE - European Localizations , user_name: JEITLST , description: Generate Italian Annual Customer and Supplier Listing , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: JEITEXLS 12.1.1
execution_filename: JEITEXLS , product: JE - European Localizations , user_name: JEITEXLS , description: Italian Exemption Limit Consumption by Supplier , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEITEXLS 12.2.2
execution_filename: JEITEXLS , product: JE - European Localizations , user_name: JEITEXLS , description: Italian Exemption Limit Consumption by Supplier , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEITLST 12.2.2
execution_filename: JE_IT_LISTING_PKG.EXTRACT_DATA , product: JE - European Localizations , user_name: JEITLST , description: Generate Italian Annual Customer and Supplier Listing , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Lookup Type: JEFI_LPIP_SUMMARY_LEVEL 12.1.1
product: JE - European Localizations , meaning: JEFI LPIP SUMMARY LEVEL , description: JEFILPIP report summary-level parameters ,
Lookup Type: JEFI_LPIP_SUMMARY_LEVEL 12.2.2
product: JE - European Localizations , meaning: JEFI LPIP SUMMARY LEVEL , description: JEFILPIP report summary-level parameters ,
Concurrent Program: JEGRSBF 12.1.1
execution_filename: JEGRCSBF , product: JE - European Localizations , user_name: JEGRCSBF , description: Greek Receivables/Payables Customer/Supplier Turnover Report - Electronic File Format , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEGRSBF 12.2.2
execution_filename: JEGRCSBF , product: JE - European Localizations , user_name: JEGRCSBF , description: Greek Receivables/Payables Customer/Supplier Turnover Report - Electronic File Format , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEGRSBL 12.2.2
execution_filename: JEGRCSBL , product: JE - European Localizations , user_name: JEGRCSBL , description: Greek Receivables/Payables Customer/Supplier Turnover Report List , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEGRSBL 12.1.1
execution_filename: JEGRCSBL , product: JE - European Localizations , user_name: JEGRCSBL , description: Greek Receivables/Payables Customer/Supplier Turnover Report List , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEGRSBE 12.1.1
execution_filename: JERX_C_TO.GET_TRNOVR_DATA , product: JE - European Localizations , user_name: JEGRCSBE , description: Greek Receivables/Payables Customer/Supplier Turnover Data Extract , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: JEGRSBE 12.2.2
execution_filename: JERX_C_TO.GET_TRNOVR_DATA , product: JE - European Localizations , user_name: JEGRCSBE , description: Greek Receivables/Payables Customer/Supplier Turnover Data Extract , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: JEITRAVL_XMLP 12.2.2
product: JE - European Localizations , user_name: Italian Annual Supplier Listing , description: Italian Annual Supplier Listing , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JEHRVITR_XMLP 12.1.1
product: JE - European Localizations , user_name: Croatian Supplier Invoice Tax Report , description: Croatia Supplier Invoice Tax Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEITRAVL_XMLP 12.1.1
product: JE - European Localizations , user_name: Italian Annual Supplier Listing , description: Italian Annual Supplier Listing , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEHRVITR_XMLP 12.2.2
product: JE - European Localizations , user_name: Croatian Supplier Invoice Tax Report , description: Croatia Supplier Invoice Tax Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEPLPSSR_XML 12.1.1
product: JE - European Localizations , user_name: Polish Supplier Statement (XML) - Not Supported: Reserved For Future Use , description: Polish Supplier Statement , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JEPLPSSR_XML 12.2.2
product: JE - European Localizations , user_name: Polish Supplier Statement (XML) - Not Supported: Reserved For Future Use , description: Polish Supplier Statement , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JEITLSTE_XMLP 12.1.1
product: JE - European Localizations , user_name: Italian Annual Customer and Supplier Electronic Format , description: Italian Annual Customer and Supplier Electronic Format , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEITLSTE_XMLP 12.2.2
product: JE - European Localizations , user_name: Italian Annual Customer and Supplier Electronic Format , description: Italian Annual Customer and Supplier Electronic Format , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: JEZZ_SUPPLIER_TRX_TYPE 12.2.2
product: JE - European Localizations , meaning: Transaction Type in Polish Supplier Statement , description: Transaction Type in Polish Supplier Statement ,
Concurrent Program: JEITRAVL 12.1.1
execution_filename: JEITRAVL , product: JE - European Localizations , user_name: JEITRAVL , description: Annual Vendor Listing , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: JEFI_AP_BANK_EXPENSE_CODE 12.2.2
product: JE - European Localizations , meaning: JEFI AP BANK EXPENSE CODE ,
Concurrent Program: JEITRAVL 12.2.2
execution_filename: JEITRAVL , product: JE - European Localizations , user_name: JEITRAVL , description: Annual Vendor Listing , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: JEFI_AP_BANK_EXPENSE_CODE 12.1.1
product: JE - European Localizations , meaning: JEFI AP BANK EXPENSE CODE ,
Lookup Type: JEIT_LISTING_COLUMNS 12.2.2
product: JE - European Localizations , meaning: Italian Annual Customer and Supplier Listing Columns , description: Italian Annual Customer and Supplier Listing Columns ,
Lookup Type: JEIT_LISTING_COLUMNS 12.1.1
product: JE - European Localizations , meaning: Italian Annual Customer and Supplier Listing Columns , description: Italian Annual Customer and Supplier Listing Columns ,
Concurrent Program: JECHRVRA 12.2.2
execution_filename: JECHRVRA , product: JE - European Localizations , user_name: JECHRVRA , description: Swiss DTA Remittance Advice to Vendor , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JECHRVRA 12.1.1
execution_filename: JECHRVRA , product: JE - European Localizations , user_name: JECHRVRA , description: Swiss DTA Remittance Advice to Vendor , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Table: JE_IT_SETUP_HDR_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_SETUP_HDR_ALL, object_name:JE_IT_SETUP_HDR_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_SETUP_HDR_ALL table contains Italian Annual Supplier and Customer listing setup header data , implementation_dba_data: JE.JE_IT_SETUP_HDR_ALL ,
Table: JE_IT_SETUP_LINES_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_SETUP_LINES_ALL, object_name:JE_IT_SETUP_LINES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_SETUP_LINES_ALL table contains Italian Annual Supplier and Customer listing setup lines data , implementation_dba_data: JE.JE_IT_SETUP_LINES_ALL ,
Table: JE_IT_SETUP_LINES_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_SETUP_LINES_ALL, object_name:JE_IT_SETUP_LINES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_SETUP_LINES_ALL table contains Italian Annual Supplier and Customer listing setup lines data , implementation_dba_data: JE.JE_IT_SETUP_LINES_ALL ,
Table: JE_IT_LIST_PARTIES_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_PARTIES_ALL, object_name:JE_IT_LIST_PARTIES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data , implementation_dba_data: JE.JE_IT_LIST_PARTIES_ALL ,
Table: JE_IT_LIST_HDR_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_HDR_ALL, object_name:JE_IT_LIST_HDR_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_HDR_ALL table contains Italian Annual Supplier and Customer listing extract header data , implementation_dba_data: JE.JE_IT_LIST_HDR_ALL ,
Table: JE_IT_LIST_LINES_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_LINES_ALL, object_name:JE_IT_LIST_LINES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_LINES_ALL table contains Italian Annual Supplier and Customer listing extract detail data , implementation_dba_data: JE.JE_IT_LIST_LINES_ALL ,
Table: JE_IT_LIST_PARTIES_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_PARTIES_ALL, object_name:JE_IT_LIST_PARTIES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data , implementation_dba_data: JE.JE_IT_LIST_PARTIES_ALL ,
Table: JE_IT_LIST_LINES_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_LINES_ALL, object_name:JE_IT_LIST_LINES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_LINES_ALL table contains Italian Annual Supplier and Customer listing extract detail data , implementation_dba_data: JE.JE_IT_LIST_LINES_ALL ,
Table: JE_IT_LIST_HDR_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_HDR_ALL, object_name:JE_IT_LIST_HDR_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_HDR_ALL table contains Italian Annual Supplier and Customer listing extract header data , implementation_dba_data: JE.JE_IT_LIST_HDR_ALL ,
Table: JE_IT_SETUP_HDR_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_SETUP_HDR_ALL, object_name:JE_IT_SETUP_HDR_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_SETUP_HDR_ALL table contains Italian Annual Supplier and Customer listing setup header data , implementation_dba_data: JE.JE_IT_SETUP_HDR_ALL ,
Concurrent Program: JEITLSTR_XMLP 12.1.1
product: JE - European Localizations , user_name: Italian Annual Customer and Supplier Listing , description: JEITLSTR_XMLP , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEITLSTR_XMLP 12.2.2
product: JE - European Localizations , user_name: Italian Annual Customer and Supplier Listing , description: JEITLSTR_XMLP , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JEGRCBF 12.1.1
execution_filename: JEGRCSBF , product: JE - European Localizations , user_name: JEGRCSBF , description: Greek Receivables/Payables Customer/Supplier Turnover Report - Electronic File Format , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JEGRCBF 12.2.2
execution_filename: JEGRCSBF , product: JE - European Localizations , user_name: JEGRCSBF , description: Greek Receivables/Payables Customer/Supplier Turnover Report - Electronic File Format , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,