Search Results inv_logical_transactions_pub




Overview
Explore in AI Chat

Overview

INV_LOGICAL_TRANSACTIONS_PUB is the public API package in the Oracle E-Business Suite Applications (APPS) schema responsible for creating and maintaining logical transactions in Oracle Inventory. A logical transaction represents an inventory movement that originates without a corresponding physical material transaction, such as COGS recognition events, deferred logical transactions generated during period close, and OPM distribution logical transactions. The package abstracts the underlying inventory transaction engine so that calling modules — costing, receiving, period close, and process manufacturing — can record logical movements through a supported interface rather than inserting directly into transaction tables.

The package is classified as a PUB API and depends on shared EBS infrastructure: FND_API for the standard return-status and message conventions, INV_GLOBALS and INV_LOGICAL_TRANSACTION_GLOBAL for global inventory settings, and the STANDARD package for common PL/SQL utilities. Its companion private package, INV_LOGICAL_TRANSACTIONS_PVT, contains the implementation logic, and the PUB layer exposes the supported entry points.

Key Procedures and Functions

  • CREATE_LOGICAL_TRX_WRAPPER — A wrapper entry point that bundles validation and invocation of logical transaction creation, providing callers with a single supported path for multi-step logical transaction processing.
  • CREATE_LOGICAL_TRANSACTIONS — The primary procedure for creating logical transactions. It accepts transaction attributes and processes the resulting logical movement through the inventory transaction engine.
  • CREATE_DEFERRED_LOG_TXNS_CP — A concurrent-program oriented entry point that creates deferred logical transactions, typically invoked as part of scheduled or period-driven processing.
  • CHECK_ACCOUNTING_PERIOD_CLOSE — Validates accounting period close status prior to logical transaction creation, ensuring transactions are not created into a closed period.
  • CREATE_COGS_RECOGNITION — Creates logical transactions that support Cost of Goods Sold recognition, aligning revenue and cost recognition for shipped goods.
  • CREATE_OPM_DISC_LOGICAL_TRX — Creates OPM (Oracle Process Manufacturing) distribution logical transactions for process manufacturing inventory flows.

Tables Accessed

The package reads and writes inventory and reference tables through APPS synonyms. Core transaction processing uses MTL_MATERIAL_TRANSACTIONS, MTL_MATERIAL_TRANSACTIONS_S, MTL_MATERIAL_TRANSACTIONS_TEMP, and MTL_COGS_RECOGNITION_TEMP. Item and location context is drawn from MTL_SYSTEM_ITEMS, MTL_ITEM_CATEGORIES, MTL_ITEM_LOCATIONS, MTL_ITEM_SUB_INVENTORIES, and MTL_SECONDARY_INVENTORIES. Organizational context uses HR_ORGANIZATION_INFORMATION, MTL_PARAMETERS, and MRP_PROJECT_PARAMETERS. Sales order linkage is retrieved from MTL_SALES_ORDERS. Reference data such as currency and language codes come from FND_CURRENCIES and FND_LANGUAGES. These reads supply validation and defaulting values, while the material transaction tables are the write targets for the generated logical movements.

Usage Notes

INV_LOGICAL_TRANSACTIONS_PUB is typically invoked from costing and receiving flows (CST_REVENUECOGSMATCH_PVT, RCV_SEEDEVENTS_PVT), process manufacturing period close and accounting packages (GMF_PERIODCLOSE_PVT, GMF_RCV_ACCOUNTING_PKG), and retroactive pricing processing (PO_RETROACTIVE_PRICING_PVT). It is referenced by six other packages. Custom code should call this PUB package rather than its private counterpart, honoring the FND_API return status and message conventions. Because transaction creation is sensitive to accounting period status, callers should be aware that CHECK_ACCOUNTING_PERIOD_CLOSE governs whether creation succeeds, and deferred processing is best scheduled through the concurrent program entry point.