Results for “oe_invoice_util”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_INVOICE_UTIL is a public utility package owned by the APPS schema in Oracle E-Business Suite, classified as a UTIL-type API within the Order Management (OE) module. Its stated responsibility is to support the interface between Oracle Order Management order lines and Oracle Receivables AutoInvoice, specifically in the context of intercompany invoicing. The package header is derived from the source file OEXUINVS.pls and carries a version identifier of 1.0, with an original header date of 2005, placing it among the long-standing internal utilities that support intercompany order-to-cash flows. As a UTIL classification API, it is not intended as a standalone business interface for external integration, but rather as an internal building block invoked by other EBS components to maintain the consistency of intercompany invoiced state on price adjustments.
Key Procedures and Functions
The documented package metadata exposes exactly one procedure:
- UPDATE_INTERCO_INVOICED_FLAG — This procedure updates the intercompany invoiced flag associated with a price adjustment record. Its single input parameter is identified as
p_price_adjustment_id, which supplies the unique identifier of the price adjustment being processed. A corresponding output parameter,x_return_status, communicates the outcome of the operation to the calling program, following the standard EBS API convention for return status reporting. The procedure is described in the source comments as an "Order line Workflow AutoInvoice Interface function," indicating that it is designed to be called during workflow-driven processing of order lines that flow into AutoInvoice. By maintaining the intercompany invoiced flag, the procedure ensures that intercompany transactions are not double-invoiced or reprocessed.
No additional procedures or functions are documented for this package in the ETRM metadata; the package is deliberately narrow in scope, addressing a single flag-maintenance operation.
Tables Accessed
Per the documented metadata, the package operates against one table accessed via an APPS synonym:
- OE_PRICE_ADJUSTMENTS — This is the Order Management table that stores price adjustment records applied to order lines, including discounts, surcharges, and other pricing modifiers. The UPDATE_INTERCO_INVOICED_FLAG procedure writes to this table, setting or clearing the intercompany invoiced indicator on the specific price adjustment identified by the passed identifier. The update ensures that downstream AutoInvoice processing recognizes which adjustments have already been included in an intercompany invoice, preventing duplicate invoicing and preserving the integrity of intercompany transfer pricing.
Usage Notes
OE_INVOICE_UTIL is an internal component invoked primarily in the context of Order Management workflow and the AutoInvoice interface for intercompany transactions. It is referenced by one other package according to the documented metadata, meaning it is not intended for direct invocation by end users or external systems. Typical invocation paths include Order Management workflow activities that process order lines destined for intercompany invoicing, and other internal APIs that orchestrate AutoInvoice submission. Because it is classified as a UTIL API rather than a public business interface, customers and partners should treat it as an unsupported internal object; customization or direct calls from custom code should be avoided unless no supported alternative exists. There are no concurrent program or form entry points documented for this package. When troubleshooting intercompany invoicing discrepancies, technical consultants may query OE_PRICE_ADJUSTMENTS to verify the intercompany invoiced flag state maintained by this procedure, but modifications should be made through supported Order Management flows rather than by direct table or package manipulation.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2