Search Results inv_third_party_stock_cp

Overview

INV_THIRD_PARTY_STOCK_CP is an Oracle E-Business Suite package owned by the APPS schema that supports the processing of third-party stock consumption within Oracle Inventory. The suffix "CP" conventionally denotes a concurrent-program-oriented package, and the documented procedure names confirm that this package is responsible for managing the flow of consumption transactions associated with materials held and consumed at third-party or supplier-managed locations. In Oracle EBS 12.1.1 and 12.2.2, third-party inventory scenarios arise when goods are stored and consumed off-site (for example, at a contract manufacturer or supplier premises) rather than on the enterprise's own premises, and the transactional accounting for those movements must still be captured against the correct inventory organizations, items, and accounts.

The package serves as the transaction-handling layer that consumes the results of third-party stock activity and converts them into valid Oracle Inventory consumption transactions. It is registered in the ETRM repository with a VALID status, confirming that the compiled package exists in the APPS schema in the documented environment.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions within this package:

• CONSUMPTION_TXN_MANAGER — The controlling (manager) routine for consumption transaction processing. It coordinates the overall handling of third-party stock consumption, typically by orchestrating the validation, grouping, and submission of consumption transaction records for further processing. As a manager-level entry point, it is the routine most likely to be invoked directly by a concurrent program or scheduler.
• CONS_TXN_WORK — The worker routine associated with consumption transaction processing. It performs the detailed processing work on individual consumption transactions or batches of transactions identified by the manager routine. In the CP design pattern, the manager delegates discrete units of work to one or more worker routines such as this one.

The metadata does not expose parameter lists for either routine; consumers should consult the package specification in the deployed environment for exact signatures before attempting direct invocation.

Tables Accessed

The ETRM documentation for this object does not enumerate the base tables referenced through APPS synonyms, and the documented dependency list notes only SYS.STANDARD. Based on the functional purpose of the package and standard Oracle Inventory data model conventions, the package operates against the core inventory transaction tables — including MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE and related interface tables — together with MTL_MATERIAL_TRANSACTIONS and the item/organization definition tables used to validate consumption context. Because the published metadata is limited in this area, the precise table list should be verified in the deployed instance.

Usage Notes

INV_THIRD_PARTY_STOCK_CP is an internal Oracle Inventory package rather than a documented public API. The ETRM metadata classifies it as "OTHER" and records zero packages referencing it, which indicates that it is not intended for direct call by customer extensions. In practice it is invoked indirectly: consumption transaction records loaded into the inventory interface tables are picked up and processed by the Inventory transaction manager concurrent programs, and this package supplies the third-party-stock-specific processing logic for that flow. When troubleshooting third-party consumption issues in 12.1.1 or 12.2.2, administrators should confirm that the package body is VALID and that no invalid objects exist on its dependency chain, then trace processing through the standard Inventory transaction manager concurrent requests rather than through direct execution of CONSUMPTION_TXN_MANAGER or CONS_TXN_WORK.