Search Results g_ps_bad_org_id




Overview
Explore in AI Chat

Overview

EGO_ITEM_USER_ATTRS_CP_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the EGO (Advanced Product Catalog / Item Management) product family and provides the concurrent processing layer of the Item User Attributes import framework. Its principal business purpose is to validate, process, and persist item user-defined attribute data that has been staged in the EGO_ITEM_USER_ATTRS_INTERFACE table, either through a bulk copy/import operation or through a direct interface load.

The package is declared AUTHID DEFINER, meaning all SQL inside it executes with the privileges of the APPS owner rather than the calling user. This is standard for EBS public APIs that must reach restricted tables such as the descriptor flexfield metadata and item master tables without granting direct object privileges to end users.

The header comment block documents the PROCESS_STATUS constants used against the EGO_ITEM_USER_ATTRS_INTERFACE.PROCESS_STATUS column. These constants drive a state machine in which rows progress from G_PS_TO_BE_PROCESSED through G_PS_IN_PROCESS to G_PS_SUCCESS, or terminate in one of the error states. Errors propagate at the level of a logical Attribute Group: when any row in a group fails, all rows in that group are set to G_PS_GENERIC_ERROR, with the specific cause captured as G_PS_BAD_ORG_ID, G_PS_BAD_ORG_CODE, G_PS_BAD_ITEM_ID, G_PS_BAD_ITEM_NUMBER, G_PS_BAD_REVISION_ID, or G_PS_BAD_REVISION_CODE. The grouping semantics explain why a single bad organization or item reference invalidates an entire attribute set rather than only the offending row.

Key Procedures and Functions

  • GET_ITEM_SECURITY_PREDICATE — Returns the item security predicate, the SQL fragment used to restrict item records according to the user's item security profile. This is the entry point commonly sought by developers who need to embed EGO item security into custom queries or views consistent with standard EBS item security enforcement.
  • PROCESS_ITEM_USER_ATTRS_DATA — The core driver that consumes rows from EGO_ITM_USR_ATTR_INTRFC, performs the validation sequence described by the PROCESS_STATUS constants, and applies the validated user attribute values to the item records.
  • GET_RELATED_CLASS_CODES — Retrieves the class codes associated with a given item, supporting the attribute group and class-based resolution logic used during processing.
  • IMPL_ITEM_ATTR_CHANGE_LINE — Implements the change-line handling for item attribute updates, writing the audit and change records associated with an attribute modification.
  • COPY_DATA_TO_INTF — Copies source data into the interface tables, preparing rows for subsequent processing by PROCESS_ITEM_USER_ATTRS_DATA, optionally governed by the import/copy option and option-set configurations.

Tables Accessed

The package reads and writes a broad set of EGO metadata and item tables through APPS synonyms. Interface staging tables include EGO_ITM_USR_ATTR_INTRFC, EGO_ITEM_ASSOCIATIONS_INTF, and EGO_ITEM_ASSOCIATIONS. Item master data is reached via EGO_MTL_SY_ITEMS_EXT_B. Descriptor flexfield and value-set metadata are read from EGO_FND_DSC_FLX_CTX_EXT, EGO_FND_DF_COL_USGS_EXT, EGO_VALUE_SET_EXT, EGO_VS_VALUES_DISP_ORDER, and FND_DESCR_FLEX_COLUMN_USAGES. Attribute group and data-level configuration reside in EGO_ATTR_GROUP_DL and EGO_DATA_LEVEL_B. Additional control data comes from EGO_OBJ_TYPE_LIFECYCLES, EGO_STYLE_VARIANT_ATTR_VS, EGO_IMPORT_COPY_OPTIONS, and EGO_IMPORT_OPTION_SETS.

Usage Notes

This package is normally invoked indirectly by the Item User Attributes import and copy concurrent programs rather than called directly from forms. The EGO Item Management UI and the Import/Copy Item User Attributes flows submit these programs, which in turn call COPY_DATA_TO_INTF and PROCESS_ITEM_USER_ATTRS_DATA. Developers implementing custom item attribute loads should stage rows in the interface tables and then invoke the processing procedure, checking PROCESS_STATUS values to report failures. GET_ITEM_SECURITY_PREDICATE is useful in custom reports and validation logic that must honor item security. The package is referenced by five other packages, confirming its role as a shared public API layer within the EGO item attribute subsystem.