Search Results cf_9formula




Overview
Explore in AI Chat

Overview

The package body APPS.WMS_WMSASNI_XMLP_PKG is an Oracle Reports 6i/10g report logic package (the _XMLP_PKG suffix denotes a report whose output is XML Publisher-enabled) belonging to the Warehouse Management System (WMS) module. The object name WMSASNI corresponds to the WMS Advanced Shipment Notice (ASN) Inquiry report, a warehouse execution report used to review inbound ASN data such as LPNs, revisions, lots, and serial numbers. The package contains the standard Oracle Reports PL/SQL constructs — BEFOREREPORT, AFTERREPORT, AFTERPFORM, and BETWEENPAGE — combined with nine formula-column functions (CF_1FORMULA through CF_9FORMULA) that compute derived display values at report runtime.

The header comment ($Header: WMSASNIBIB.pls 120.1 2008/03/18) identifies the object as a Report Builder Integration Bean (BIB) generated PL/SQL library registered in the NOSHIP (non-shipped) file set, indicating it is delivered as report source rather than as a database-schema object subject to patching. This behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, where the report source is largely unchanged; only the surrounding XML Publisher infrastructure differs between releases.

Key Procedures and Functions

  • BEFOREREPORT — Initializes the report execution context. It captures FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID (the standard concurrent request identifier parameter) so downstream queries and formula columns can reference the current submission.
  • AFTERREPORT — Standard report-termination hook; contains the disabled SRW.USER_EXIT('FND SRWEXIT') call (commented out) which historically released report session resources.
  • AFTERPFORM — Executes after parameter form validation. The disabled SRW.MESSAGE debug statements show it was used to echo P_FROM_DATE and P_END_DATE during development.
  • BETWEENPAGE — Page-level trigger, historically used for debug messages; no active logic remains.
  • CF_1FORMULA — Returns the organization name by querying ORG_ORGANIZATION_DEFINITIONS for ORG_ID, returning 'Organization Name Not Found' on error. This supplies the report header organization.
  • CF_2FORMULA — Accepts ITEM_ID and returns the concatenated item description from MTL_SYSTEM_ITEMS_KFV.
  • CF_3FORMULA — Builds the "View By" label by concatenating values ('LPN', 'REVISION', 'Lot Number', 'SERIAL') based on the P_CHECK_LPN, P_CHECK_REVISION, P_CHECK_LOT_NUMBER, and P_CHECK_SER_NUMBER parameters.
  • CF_4FORMULA through CF_9FORMULA — Additional formula columns computing report display values (typically status, quantity, or conditional formatting fields). The ETRM metadata does not expose their individual bodies, so their precise logic cannot be stated.

Tables Accessed

  • ORG_ORGANIZATION_DEFINITIONS — Read to resolve the organization name for ORG_ID in CF_1FORMULA.
  • MTL_SYSTEM_ITEMS_KFV — Read (via APPS synonym) in CF_2FORMULA to obtain the key-flexfield item description/concatenated segments for a given ITEM_ID.

Additional WMS ASN tables (for example, WMS_LICENSE_PLATE_NUMBERS, MTL_MATERIAL_TRANSACTIONS, or RCV_SHIPMENT_HEADERS) are referenced by the report's main and group queries, not by the PL/SQL library's documented procedures.

Usage Notes

The package is invoked implicitly by Oracle Reports at runtime. The four event functions fire in their standard sequence (Before Report, After Parameter Form, Between Pages, After Report), and each CF_nFORMULA executes when its associated formula column is evaluated in the report layout. Administrators submit the parent concurrent program (WMS ASN Inquiry) via the Warehouse Management or Inventory responsibility; no direct call is intended.

Regarding the search term cf_7formula: this identifier refers to the seventh formula-column function in the package, one of the report's derived-value generators. Because ETRM documents the function's name and classification but not its full body, its exact computation should be confirmed by reading the deployed source in $APPL_TOP/wms/12.0.0/sql/WMSASNIBIB.pls (or the 12.2 $APPL_TOP/wms/12.0.0 equivalent). The function is never called externally and is not tracked as a database dependency; because the report is registered under NOSHIP, customizations to CF_7FORMULA require manual source modification and recompilation of the report, and should be preserved across patching since Oracle does not maintain these files as patched schema objects.