Search Results create_instructions

Overview

AP_RETRO_PRICING_PKG is an Oracle Payables (AP) PL/SQL package owned by the APPS schema. Its primary business function is to support retroactive price adjustment processing for invoices, whereby invoices previously entered and accounted may need to be modified to reflect corrected or renegotiated unit prices, taxes, or amounts received after the original invoice was created. The package provides the procedural logic necessary to build adjustment instructions and to import retro-price adjustment data back into the Payables invoice tables. This functionality is relevant to supplier agreements where pricing is finalized after goods or services have already been invoiced, requiring systematic revaluation of open or posted invoices.

Key Procedures and Functions

The documented ETRM metadata identifies two procedures within this package:

• CREATE_INSTRUCTIONS — This procedure is responsible for generating the adjustment instructions that describe how an existing invoice should be retroactively repriced. It evaluates the affected invoice lines and distributions and prepares the instruction set that subsequent processing will apply.
• IMPORT_RETROPRICE_ADJUSTMENTS — This procedure performs the import step, applying the prepared retroactive price adjustments so that the affected invoice records reflect the revised pricing. It operates against the interface and base invoice tables to effect the changes.

Both procedures are classified as OTHER under API classification, indicating they are intended for internal Payables processing rather than as published public APIs. Detailed parameter signatures are not enumerated in the ETRM documentation and should be verified against the package specification in the target instance.

Tables Accessed

The package references a broad set of Payables tables, accessed through APPS synonyms:

• AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL — core invoice, line, and distribution tables read and updated to apply repricing.
• AP_INVOICE_LINES_INTERFACE, AP_INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE_S, AP_INVOICES_INTERFACE_S — interface tables used to stage and import adjustment data.
• AP_PPA_INVOICES_GT, AP_PPA_INVOICE_DISTS_GT, AP_PPA_INVOICE_LINES_GT — global temporary tables used as working storage during retro-pricing computation.
• AP_BATCHES_S, AP_SYSTEM_PARAMETERS, AP_SYSTEM_PARAMETERS_ALL — batch sequencing and Payables system options that govern processing behavior.
• FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS — document sequencing configuration for any generated documents.

Usage Notes

AP_RETRO_PRICING_PKG is referenced by AP_IMPORT_INVOICES_PKG, AP_RETRO_PRICING_UTIL_PKG, and itself. This dependency indicates that retro-pricing logic is invoked in coordination with the standard invoice import and retro-pricing utility routines. The package is typically executed from concurrent program processing or from custom code that orchestrates retroactive price corrections, rather than directly from an online form. Because its procedures are classified as non-public APIs, they should be called in the sequence established by the dependent packages, and any customization should account for the interface and global temporary table staging steps. Sites running Oracle EBS 12.1.1 or 12.2.2 should confirm package validity and dependency status before relying on it within custom extensions.