Search Results post_aia_om_load_process




Overview
Explore in AI Chat

Overview

CN_COLLECTION_AIA_OM_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Advanced Integration Architecture (AIA) order capture flow within the Channel Revenue Management (CN) product family. It is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking session rather than as the defining APPS user. The package acts as the collection-layer gateway between external AIA order capture payloads and the Oracle Order Management interface tables. Its header carries the revision identifier CNPCLTROMS.pls 120.1 (2010/10/26), confirming a mature, low-churn interface object that predates the 12.1.1 and 12.2.2 releases but remains shipped in both.

The business purpose of the package is to support order import staging: it resolves reference data required to populate the AIA order capture staging table, then participates in the pre-load and post-load phases of the order management import lifecycle.

Key Procedures and Functions

The package exposes four documented entry points, all classified as public APIs.

  • GET_EXCHANGE_RATE — a function that derives the currency conversion rate applicable to an order line. It accepts a source currency, a conversion date, and an operating unit identifier, and returns the exchange rate to be stored on the order capture record. This is the specific routine referenced by searches for "get_exchange_rate".
  • GET_EMPLOYEE_NUMBER — a function that resolves a sales representative identifier plus operating unit into the corresponding employee number, which is then written to the order capture staging row so that the imported order is credited to the correct salesperson.
  • PRE_AIA_OM_LOAD_PROCESS — a procedure that runs prior to the AIA-to-Order Management load. It follows the standard EBS concurrent program signature, returning errbuf and retcode plus the operating unit, and performs the setup and validation work needed before staged records are pushed into the OM interface tables.
  • POST_AIA_OM_LOAD_PROCESS — a procedure invoked after the load step, returning a single x_return_status value, and used to complete or reconcile the import cycle, for example clearing staging data or recording the outcome of the load.

No other subprograms are declared in the package specification.

Tables Accessed

All table access is performed through APPS synonyms, consistent with the package owner.

  • CN_AIA_ORDER_CAPTURE — the central staging table for AIA order capture. The package reads from it for currency, date, organization, and salesrep context, and writes resolved values such as exchange rate and employee number back to it.
  • GL_DAILY_RATES — the General Ledger daily rates table, consulted by GET_EXCHANGE_RATE to obtain the conversion rate for the supplied currency and date.
  • JTF_RS_SALESREPS — the resource and salesrep repository, queried by GET_EMPLOYEE_NUMBER to map a salesrep identifier to an employee number within the given operating unit.
  • PLITBLM — the EBS PL/SQL table-to-array bulk utility, typically used alongside standard concurrent program logging and error-handling infrastructure.

Usage Notes

CN_COLLECTION_AIA_OM_PUB is intended for programmatic invocation rather than direct end-user interaction. Its documented callers are AIA integration flows and the concurrent programs that orchestrate order capture loading; the concurrent-style signatures of PRE_AIA_OM_LOAD_PROCESS and POST_AIA_OM_LOAD_PROCESS confirm that they are registered as concurrent programs or invoked from a controlling program in the same manner. The two functions are typically called from custom integration or conversion code while building the CN_AIA_ORDER_CAPTURE staging rows, before the pre-load process executes.

The ETRM metadata records zero dependent packages, so the object is a leaf node in the dependency graph and carries no downstream API consumers within the repository. The absence of catalogued dependents does not preclude runtime invocation from AIA composite services, Forms personalizations, or customer-written conversion scripts.

Because the package is declared AUTHID CURRENT_USER, callers require direct privileges on the underlying tables and synonyms; compile or runtime failures following an upgrade are commonly root-caused to privilege grants rather than to the package body itself.