Search Results get_unique_list

Overview

APPS.INV_COPY_ORGANIZATION_REPORT is a server-side PL/SQL package body (source file INVCORPB.pls) in Oracle EBS Inventory. Its purpose, as stated in the package header comments, is to generate the data required for the Copy Organization Report. The Copy Organization feature allows an existing inventory organization to be used as a model for creating a new organization; the report documents what will be copied across entity types such as subinventories, items, bills of material, routings, resources, departments, and shipping networks. The package assembles this data, validates the source and destination organizations, and inserts the results into the MTL_COPY_ORG_REPORT staging table for presentation.

The body carries a substantial revision history spanning 2003 through 2005, reflecting corrections for location validation (Bug 3441641), 10G compilation (Bug 3623168), item revision query cost reduction (Bug 3637921), CLOB-to-VARCHAR2 conversion (Bug 3683490), and replacement of entity types with lookup codes (Bug 3575494). In ETRM 12.2.2 the package is classified under owner APPS with API classification OTHER, indicating it is an internal implementation package rather than a public, supported API.

Key Procedures and Functions

The package exposes 33 documented procedures and functions. The central driver is GENERATE_REPORT_DATA, which orchestrates collection of the report rows across all entities. GET_UNIQUE_LIST is a utility used to build de-duplicated value lists — the term the user searched for — typically applied when assembling distinct entity identifiers before validation or insertion.

Validation logic is contained in VALIDATE_ORGS, VALIDATE_LOCS, and VALIDATE_ENTITIES, which confirm that the model organization, its locations, and the selected entities are eligible for copying. A large family of error-reporting functions returns exception text for each entity: GET_ERR_SUBINV_NAMES, GET_ERR_BOM_RESOURCES, GET_ERR_BOM_DEPARTMENTS, GET_ERR_SHIP_NET, GET_ERR_BOM_BOM, GET_ERR_ORG_INFORMATION, GET_ERR_MTL_ITEMS, GET_ERR_MTL_ITEMS_SUBINV, GET_ERR_MTL_ITEM_CAT, GET_ERR_MTL_ITEM_REV, GET_ERR_STDOPERATIONS, GET_ERR_ROUTINGS, GET_ERR_MTL_ITEM_LOCATIONS, GET_ERR_BOM_DEPT_RES, and GET_ERR_CST_RES_OVHDS. These functions retrieve FND messages describing why a given entity could not be copied. GET_ERR_WIP_ACC_CLASSES was added for R12 to support the WIP Accounting Classes entity, and CLOB_TO_VARCHAR was added to convert CLOB fields for compatibility with 8i, since TO_CHAR on a CLOB is unsupported there.

Tables Accessed

The package reads from a broad set of BOM and inventory tables via APPS synonyms. BOM-related reads include BOM_ALTERNATE_DESIGNATORS, BOM_COMPONENT_OPERATIONS, BOM_OPERATION_SEQUENCES, BOM_OPERATION_RESOURCES, BOM_OPERATIONAL_ROUTINGS, BOM_REFERENCE_DESIGNATORS, BOM_DEPARTMENTS, BOM_DEPARTMENT_CLASSES, BOM_DEPARTMENT_RESOURCES, BOM_RESOURCES, BOM_STANDARD_OPERATIONS, BOM_STD_OP_RESOURCES, BOM_STD_SUB_OP_RESOURCES, BOM_PARAMETERS, and BOM_STRUCTURES_B. These support enumeration and validation of bills, routings, operations, departments, and resources for the model organization. Results are written to MTL_COPY_ORG_REPORT, which stores the assembled report rows by entity type and error text.

Usage Notes

INV_COPY_ORGANIZATION_REPORT is not referenced by any other package, confirming its role as a terminal implementation module invoked directly by the Copy Organization Report concurrent program or its associated form. It is not intended for direct customer invocation. Customizations should treat it as unsupported and instead consume the populated MTL_COPY_ORG_REPORT rows. Because the package depends on FND messages and lookup codes, behavior is sensitive to message and lookup configuration in the target environment, and error text returned by the GET_ERR_* functions reflects the language of the session.