Search Results org_name1formula

Overview

APPS.RLM_RLMNETCH_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite APPS schema that belongs to the Oracle Release Management (RLM) application. It is the generated program unit behind the XML Publisher (BI Publisher) concurrent report commonly associated with customer item net change processing. In the 12.1.1 and 12.2.2 releases, XML Publisher concurrent programs are registered with an executable that invokes an XML Publisher data definition/template pair; the corresponding _XMLP_PKG package is auto-generated to contain the data model logic, report triggers, and formatting formulas that produce the XML output consumed by the report template.

The package is therefore a reporting infrastructure object rather than a general-purpose business API. It encapsulates the SQL query and the derived XML tags required to present net change information for Release Management schedules, customer items, and cumulative quantities. It is classified as OTHER in the ETRM API classification, and carries a status of VALID. The documentation records 51 procedures and functions, all dedicated to report generation rather than public interface use.

Key Procedures and Functions

The documented members divide into three functional groups:

• Report lifecycle triggers: BEFOREREPORT and AFTERPFORM are the standard XML Publisher report-level triggers used to initialize parameters, session context, and post-format processing before and after the data model executes.
• Data model/group filters: G_ITEM_1GROUPFILTER, G_CUSTOMER_ITEM_ID1GROUPFILTER, G_ITEM_HEADGROUPFILTER, and G_HEADERGROUPFILTER represent group-level filter functions that control which rows are emitted into each XML group in the report hierarchy (item level, customer item level, and header level).
• Formula columns (XML tag derivation): C_CHANGE_CUMFORMULA, C_NET_CHANGEFORMULA, CF_PERCENTAGEFORMULA, CF_1FORMULA, CF_OLD_CUMFORMULA, C_ACTUAL_NEW_QTYFORMULA, C_ACTUAL_OLD_QTYFORMULA, INTRMD_SHIP_TO_EXTFORMULA, CUSTOMER_ITEM_NUMBERFORMULA, CUSTOMER_ITEM_DESCFORMULA, ITEM_NUMBER1FORMULA, SHIP_TO_NAME1FORMULA, ORG_NAME1FORMULA, and SHIP_FROM_NAMEFORMULA. These calculate the cumulative change quantity, net change quantity, percentage change, actual old/new quantities, and resolve descriptive attributes such as customer item number, description, ship-to name, ship-from name, and organization name for the XML output.

No parameter lists are documented in the ETRM metadata; per Oracle convention these formula functions operate on the current report row and return a scalar value.

Tables Accessed

The package reads from the following documented tables (through APPS synonyms):

• Release Management: RLM_SCHEDULE_HEADERS_ALL, RLM_SCHEDULE_LINES_ALL, RLM_CUST_ITEM_CUM_KEYS, RLM_CUST_SHIPTO_TERMS — the schedule, cumulative key, and shipment-term sources that drive net change calculations.
• Order Management: OE_ORDER_LINES — order line detail correlated to schedule lines.
• Inventory: MTL_CUSTOMER_ITEMS — customer item cross-reference.
• Trading Community / Receivables: HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES_ALL, HZ_PARTIES — customer, account, site, and party name resolution.

These are read-only in a reporting context; the package does not perform DML.

Usage Notes

RLM_RLMNETCH_XMLP_PKG is invoked indirectly by the XML Publisher concurrent program that references it — it is not called from forms or custom PL/SQL in normal operation. Administrators encounter it when diagnosing report failures, viewing the data model, or regenerating the XML Publisher definition. Because it is a generated object, direct modification is not supported; changes must be made through the XML Publisher data model and template, after which the package is regenerated. The ETRM metadata confirms it references only SYS.STANDARD internally and is referenced by itself (recursive dependency), with zero other dependent packages, underscoring its role as a leaf-level report unit.