Search Results malay to english

The JE_DK_EDI_TMP table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a temporary staging table primarily used in the context of Electronic Data Interchange (EDI) transactions, particularly for journal entry processing in Denmark (DK). This table plays a critical role in the interim storage and validation of journal entry data before it is posted to the general ledger. Below is a detailed breakdown of its purpose, structure, and functionality within Oracle EBS.

Purpose and Context

The JE_DK_EDI_TMP table is part of the localized functionality for Denmark, designed to handle EDI-based journal entries. EDI enables the automated exchange of financial data between organizations and their trading partners, ensuring compliance with Danish accounting standards. This table acts as a buffer, storing raw or semi-processed journal entry data extracted from EDI files before validation and posting to the Oracle General Ledger (GL).

Key Features

Data Staging: Temporarily holds journal entry data parsed from inbound EDI files, ensuring data integrity before further processing.
Validation: Facilitates preliminary validation checks (e.g., mandatory fields, accounting rules) to prevent erroneous postings.
Error Handling: Captures validation errors or discrepancies, allowing corrective actions before GL submission.
Integration: Interfaces with other Oracle EBS modules, such as Accounts Payable (AP), Accounts Receivable (AR), and GL, ensuring seamless data flow.

Table Structure

While the exact schema may vary slightly between EBS 12.1.1 and 12.2.2, the JE_DK_EDI_TMP table typically includes the following columns:

TRANSACTION_ID: Unique identifier for each EDI transaction.
JOURNAL_NAME: Name or reference of the journal entry.
ACCOUNTING_DATE: The effective date for the journal entry.
CURRENCY_CODE: Currency of the transaction (e.g., DKK).
AMOUNT: Debit/credit value of the line item.
STATUS: Indicates processing status (e.g., 'PENDING', 'VALIDATED', 'ERROR').
ERROR_MESSAGE: Descriptive text for validation failures.
CREATION_DATE: Timestamp when the record was inserted.

Workflow

Data Ingestion: EDI files are parsed, and journal entry data is loaded into JE_DK_EDI_TMP.
Validation: Custom PL/SQL or Oracle Application Framework (OAF) logic validates data against GL rules.
Error Resolution: Invalid records are flagged for correction; valid records proceed to GL staging tables (e.g., GL_INTERFACE).
Posting: Approved entries are posted to the GL via standard Oracle interfaces.

Technical Considerations

Performance: Indexes on key columns (e.g., TRANSACTION_ID) optimize query performance during validation.
Purging: Scheduled jobs should archive or purge processed records to maintain efficiency.
Customization: Localizations may require additional columns or logic to meet Danish regulatory requirements.

Conclusion

The JE_DK_EDI_TMP table is a pivotal component in Oracle EBS for Denmark, enabling efficient and compliant EDI-based journal entry processing. Its design ensures data accuracy, supports auditability, and integrates seamlessly with Oracle GL. Proper configuration and maintenance of this table are essential for organizations leveraging EDI for financial automation in Denmark.

Lookup Type: JEBE_LANGUAGE2 12.2.2
product: JE - European Localizations , meaning: JEBE LANGUAGE2 , description: Languages for running report journals ,
Lookup Type: JEBE_LANGUAGE2 12.1.1
product: JE - European Localizations , meaning: JEBE LANGUAGE2 , description: Languages for running report journals ,
Lookup Type: JEDE_EFT_CHARGE_CODE 12.1.1
product: JE - European Localizations , meaning: JEDE EFT CHARGE CODE , description: EFT Charge Code ,
Lookup Type: JEDE_EFT_CHARGE_CODE 12.2.2
product: JE - European Localizations , meaning: JEDE EFT CHARGE CODE , description: EFT Charge Code ,
Lookup Type: JEDK_EDI_PAYMENT_CHANNEL 12.1.1
product: JE - European Localizations , meaning: JEDK_EDI_PAYMENT_CHANNEL , description: Danish EDI Payment Channel ,
Lookup Type: JEBE_VAT_REPORT_BOXES 12.2.2
product: JE - European Localizations , meaning: JEBE VAT REPORT BOXES , description: VAT Box for Monthly VAT ,
Lookup Type: JEDE_EFT_PAYMENT_METHOD 12.2.2
product: JE - European Localizations , meaning: JEDE EFT PAYMENT METHOD , description: EFT Payment Method ,
Lookup Type: JEDK_EDI_PAYMENT_CHANNEL 12.2.2
product: JE - European Localizations , meaning: JEDK_EDI_PAYMENT_CHANNEL , description: Danish EDI Payment Channel ,
Lookup Type: JESE_PAYMENT_TYPES 12.1.1
product: JE - European Localizations , meaning: JESE PAYMENT TYPES , description: EFT Payment Types used in Sweden ,
Lookup Type: JEDE_EFT_PAYMENT_METHOD 12.1.1
product: JE - European Localizations , meaning: JEDE EFT PAYMENT METHOD , description: EFT Payment Method ,
Lookup Type: JEBE_VAT_REPORT_BOXES 12.1.1
product: JE - European Localizations , meaning: JEBE VAT REPORT BOXES , description: VAT Box for Monthly VAT ,
Lookup Type: JESE_FED_CODES 12.1.1
product: JE - European Localizations , meaning: JESE FED CODES , description: Swedish Federal Reserve Codes ,
Lookup Type: JE_SE_PAYMENT_TYPES 12.1.1
product: JE - European Localizations , meaning: JE SE PAYMENT TYPES , description: EFT Payment Types for Sweden ,
Lookup Type: JE_SE_PAYMENT_TYPES 12.2.2
product: JE - European Localizations , meaning: JE SE PAYMENT TYPES , description: EFT Payment Types for Sweden ,
Lookup Type: JESE_PAYMENT_TYPES 12.2.2
product: JE - European Localizations , meaning: JESE PAYMENT TYPES , description: EFT Payment Types used in Sweden ,
Lookup Type: JESE_FED_CODES 12.2.2
product: JE - European Localizations , meaning: JESE FED CODES , description: Swedish Federal Reserve Codes ,
Lookup Type: JE_FR_TAX_TYPES 12.2.2
product: JE - European Localizations , meaning: JE FR TAX TYPES , description: FRENCH TAX TYPES ,
Lookup Type: JE_FR_TAX_TYPES 12.1.1
product: JE - European Localizations , meaning: JE FR TAX TYPES , description: FRENCH TAX TYPES ,
Lookup Type: JEBE_DECLARANT_TYPE 12.2.2
product: JE - European Localizations , meaning: JEBE_DECLARANT_TYPE , description: Declarant type for belgium ,
Lookup Type: JEIT_DECL_INC_COMPANY 12.2.2
product: JE - European Localizations , meaning: Declaration of Incorporated Company , description: Declaration of Incorporated Company ,
Lookup Type: JEBE_EFT_PAYMENT_METHOD 12.1.1
product: JE - European Localizations , meaning: JEBE EFT PAYMENT METHOD , description: EFT Foreign Payments Payment Method ,
Lookup Type: JEBE_EFT_PAYMENT_METHOD 12.2.2
product: JE - European Localizations , meaning: JEBE EFT PAYMENT METHOD , description: EFT Foreign Payments Payment Method ,
Lookup Type: JENL_CODE_KOSTEN_KORR 12.2.2
product: JE - European Localizations , meaning: JENL CODE KOSTEN KORR , description: Lookup Code for SWIFT ,
Lookup Type: JENL_CODE_KOSTEN_BNL 12.1.1
product: JE - European Localizations , meaning: JENL CODE KOSTEN BNL , description: Lookup Code for SWIFT ,
Lookup Type: JENL_CODE_KOSTEN_KORR 12.1.1
product: JE - European Localizations , meaning: JENL CODE KOSTEN KORR , description: Lookup Code for SWIFT ,
Lookup Type: JENL_CODE_KOSTEN_BNL 12.2.2
product: JE - European Localizations , meaning: JENL CODE KOSTEN BNL , description: Lookup Code for SWIFT ,
Lookup Type: JESE_EFT_CODES 12.1.1
product: JE - European Localizations , meaning: JESE EFT CODES , description: Swedish EFT Lookup Codes ,
Lookup Type: JESE_EFT_CODES 12.2.2
product: JE - European Localizations , meaning: JESE EFT CODES , description: Swedish EFT Lookup Codes ,
Concurrent Program: JECHRLET 12.1.1
execution_filename: JECHRLET , product: JE - European Localizations , user_name: JECHRLET , description: Swiss DTA Accompanying Letter to Bank , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JECHRLET 12.2.2
execution_filename: JECHRLET , product: JE - European Localizations , user_name: JECHRLET , description: Swiss DTA Accompanying Letter to Bank , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: JEDE_EFT_BANK_INSTRUCTION 12.1.1
product: JE - European Localizations , meaning: JEDE EFT BANK INSTRUCTION , description: EFT Bank Instruction ,
Lookup Type: JEDE_EFT_BANK_INSTRUCTION 12.2.2
product: JE - European Localizations , meaning: JEDE EFT BANK INSTRUCTION , description: EFT Bank Instruction ,
Concurrent Program: JECHSLET 12.1.1
execution_filename: JECHSLET , product: JE - European Localizations , user_name: JECHSLET , description: Swiss SAD Accompanying Letter to Bank , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JECHSLET 12.2.2
execution_filename: JECHSLET , product: JE - European Localizations , user_name: JECHSLET , description: Swiss SAD Accompanying Letter to Bank , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Table: JE_DK_EDI_TMP 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_DK_EDI_TMP, object_name:JE_DK_EDI_TMP, status:VALID, product: JE - European Localizations , description: Table to store error messages when updating Danish EFT invoices to use EDI flexfields , implementation_dba_data: AP.JE_DK_EDI_TMP ,
Table: JE_NO_GEI_ASCIIS_T 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_NO_GEI_ASCIIS_T, object_name:JE_NO_GEI_ASCIIS_T, status:VALID, product: JE - European Localizations , description: This table stores data temporarily that are to be sent to FIN. , implementation_dba_data: JE.JE_NO_GEI_ASCIIS_T ,
Table: JE_DK_EDI_TMP 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_DK_EDI_TMP, object_name:JE_DK_EDI_TMP, status:VALID, product: JE - European Localizations , description: Table to store error messages when updating Danish EFT invoices to use EDI flexfields , implementation_dba_data: AP.JE_DK_EDI_TMP ,
Concurrent Program: JEILSVAT_XMLP 12.1.1
product: JE - European Localizations , user_name: Israeli Summary VAT to Tax Authorities , description: Israeli Summary VAT to Tax Authorities , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Table: JE_NO_GEI_ASCIIS_T 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_NO_GEI_ASCIIS_T, object_name:JE_NO_GEI_ASCIIS_T, status:VALID, product: JE - European Localizations , description: This table stores data temporarily that are to be sent to FIN. , implementation_dba_data: JE.JE_NO_GEI_ASCIIS_T ,
Concurrent Program: JEILN835_XMLP 12.1.1
product: JE - European Localizations , user_name: Israeli VAT File Non Related to 835 , description: Israeli VAT File Non Related to 835 , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILR835_XMLP 12.2.2
product: JE - European Localizations , user_name: Israeli VAT File Related to 835 , description: Israeli VAT File Related to 835 , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILWHTT 12.1.1
product: JE - European Localizations , user_name: Israeli Withholding Tax File to Tax Authority , description: Israeli Withholding Tax File to Tax Authority , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILR835_XMLP 12.1.1
product: JE - European Localizations , user_name: Israeli VAT File Related to 835 , description: Israeli VAT File Related to 835 , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILSVAT_XMLP 12.2.2
product: JE - European Localizations , user_name: Israeli Summary VAT to Tax Authorities , description: Israeli Summary VAT to Tax Authorities , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILWHTT 12.2.2
product: JE - European Localizations , user_name: Israeli Withholding Tax File to Tax Authority , description: Israeli Withholding Tax File to Tax Authority , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILN835_XMLP 12.2.2
product: JE - European Localizations , user_name: Israeli VAT File Non Related to 835 , description: Israeli VAT File Non Related to 835 , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: JE_IT_UNPOST_TRANSACT 12.1.1
product: JE - European Localizations , meaning: JE IT UNPOST TRANSACT , description: Italian Unposted Transaction Codes ,
Table: JE_CZ_CONT_ALLOC_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CZ_CONT_ALLOC_ALL, object_name:JE_CZ_CONT_ALLOC_ALL, status:VALID, product: JE - European Localizations , description: This table is used to associate a bank account with a Compatible Media contract. A contract can relate to one or more bank accounts. , implementation_dba_data: AP.JE_CZ_CONT_ALLOC_ALL ,
Lookup Type: JE_IT_UNPOST_TRANSACT 12.2.2
product: JE - European Localizations , meaning: JE IT UNPOST TRANSACT , description: Italian Unposted Transaction Codes ,
Table: JE_CZ_CONT_ALLOC_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CZ_CONT_ALLOC_ALL, object_name:JE_CZ_CONT_ALLOC_ALL, status:VALID, product: JE - European Localizations , description: This table is used to associate a bank account with a Compatible Media contract. A contract can relate to one or more bank accounts. , implementation_dba_data: AP.JE_CZ_CONT_ALLOC_ALL ,