Results for “ece_ar_transaction”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.ECE_AR_TRANSACTION is a PL/SQL package within the Oracle E-Business Suite E-Commerce Gateway (ECE) module, classified in the ETRM metadata as an OTHER API. Its principal business function is to support the extraction and inbound processing of Oracle Receivables transaction data as part of the E-Commerce Gateway's external trading partner integration framework. In EBS releases 12.1.1 and 12.2.2, the ECE module enables organizations to exchange business documents — including inbound and outbound receivable transactions such as invoices, debit memos, and credit memos — with external systems and trading partners using standardized formats like EDI 810 and 812.
The package operates against a configuration-driven architecture in which document layouts, data mappings, and hierarchical levels are defined through ECE setup tables. Its status is recorded as VALID and it depends directly on the SYS.STANDARD package for standard PL/SQL functionality. Its output is consumed by the ECE_INO_HEADER_V view and by ECE_AR_TRANSACTION itself via internal line itemization.
Key Procedures and Functions
The package exposes eight documented procedures and functions. EXTRACT_INO_OUTBOUND orchestrates the extraction of inbound order (INO) style outbound data, driving the population of extract records from Receivables source data. UPDATE_AR applies updates back to Oracle Receivables records after processing, supporting synchronization between gateway activity and AR transactions. GET_REMIT_ADDRESS retrieves remit-to address information for the transaction, typically for display on invoice documents. GET_PAYMENT derives payment details associated with the transaction, supporting reconciliation of receipts against receivables. GET_TERM_DISCOUNT determines any early payment or terms-based discount applicable to the transaction. GET_CURRENCY_CODE returns the transaction currency for formatting and validation. PUT_DATA_TO_OUTPUT_TABLE writes assembled records into the ECE_OUTPUT staging table, and POPULATE_AR_TRX constructs the Receivables transaction header and line records from source and mapped data.
Tables Accessed
The package reads and writes against several AR tables through APPS synonyms. AR_PAYMENT_SCHEDULES supplies payment terms, due dates, and installment data; AR_SYSTEM_PARAMETERS provides organizational defaults. The ECE_AR_TRX_HEADERS, ECE_AR_TRX_HEADERS_S, ECE_AR_TRX_HEADER_1_S, ECE_AR_TRX_LINES, ECE_AR_TRX_LINES_S, and ECE_AR_TRX_LINE_TAX_S tables form the transaction staging and interposing structures holding header, line, and tax data prior to extraction or loading. ECE_EXTERNAL_LEVELS, ECE_LEVEL_MATRICES, and ECE_MAPPINGS provide the configuration-driven level hierarchy and field mapping definitions. ECE_INTERFACE_TABLES and ECE_TP_DETAILS hold trading partner and interface metadata. ECE_OUTPUT and ECE_OUTPUT_RUNS_S receive the final extracted payload and run identifiers.
Usage Notes
ECE_AR_TRANSACTION is typically invoked indirectly through the E-Commerce Gateway concurrent programs that prepare outbound receivable documents and process inbound acknowledgments, rather than being called directly by end users. It is referenced by one other package and surfaced through the ECE_INO_HEADER_V view, confirming its role as a supporting extraction engine. Customizations should call the documented procedures only in accordance with ECE setup configuration, as the package relies on external level, mapping, and trading partner definitions. Direct invocation outside the standard concurrent program flow is not recommended without preserving the expected ECE_OUTPUT_RUNS_S run context.
-
SYNONYM: APPS.RA_REMIT_TOS 12.2.2
-
SYNONYM: APPS.RA_REMIT_TOS 12.1.1
-
SYNONYM: APPS.ECE_OUTPUT 12.1.1
-
SYNONYM: APPS.WSH_DELIVERIES 12.2.2
-
SYNONYM: APPS.ECE_OUTPUT 12.2.2
-
SYNONYM: APPS.WSH_DELIVERIES 12.1.1
-
SYNONYM: APPS.ECE_MAPPINGS 12.1.1
-
SYNONYM: APPS.ECE_MAPPINGS 12.2.2
-
SYNONYM: APPS.ECE_TP_DETAILS 12.2.2
-
SYNONYM: APPS.ECE_TP_DETAILS 12.1.1
-
SYNONYM: APPS.RA_TERMS_LINES 12.1.1
-
SYNONYM: APPS.RA_TERMS_LINES 12.2.2
-
SYNONYM: APPS.RA_TERMS 12.1.1
-
SYNONYM: APPS.WSH_TRIPS 12.1.1
-
SYNONYM: APPS.WSH_TRIPS 12.2.2
-
SYNONYM: APPS.RA_TERMS 12.2.2