Search Results eng_cpi_dataset_id_s

Overview

APPS.EGO_CHANGE_PEOPLE_IMPORT_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications schema that supports the Oracle Engineering (ENG) product family, specifically the import and maintenance of people assignments associated with engineering change orders. In the ETRM 12.2.2 reference, the package is classified as an "OTHER" API, indicating it is not a public, published interface but an internal dependency used by Oracle Engineering and Oracle Product Information Management functionality. Its principal role is to move data between the change people interface table and the base engineering change tables, resolve the correct dataset context for the current session, and cleanse staging records after processing.

The user search term "eng_cpi_dataset_id_s" corresponds to the ENG_CPI_DATASET_ID_S sequence, which the package consumes to obtain a unique dataset identifier. This dataset ID acts as a logical grouping key that segregates one import run from another, allowing concurrent or successive imports of change people data to be processed without collision and later identified for purge.

Key Procedures and Functions

• GET_CURR_DATASET_ID — Returns the dataset identifier associated with the current import session. This routine supplies the value used to tag rows written to the staging interface, derived from the ENG_CPI_DATASET_ID_S sequence, so that all records belonging to one import run remain logically grouped.
• LOAD_INTERFACE_LINES — Populates and processes the engineering change people interface lines. It writes or reads rows in ENG_CHANGE_PEOPLE_INTF, validates the referenced people, roles, and change orders, and applies the data-security and access rules needed before the records are consumed by the engineering change processing logic.
• PURGE_INTERFACE_LINES — Removes processed interface rows from the staging table for the relevant dataset. This housekeeping routine prevents accumulation of stale staging records and keeps the interface table performing optimally across repeated import cycles.

Tables Accessed

The package references a broad set of tables and views through APPS synonyms. Core change data resides in ENG_CHANGE_PEOPLE_INTF (the staging interface), ENG_CHANGE_ROLES_TEMP, ENG_ENGINEERING_CHANGES, and ENG_LOGIN_ACCESS_CHANGES. The sequence ENG_CPI_DATASET_ID_S supplies dataset identifiers. Supporting reference data — including parties, users, roles, responsibilities, and security grants — is read from HZ_PARTIES, FND_USER, FND_FORM_FUNCTIONS, FND_MENUS, FND_MENUS_TL, FND_MENU_ENTRIES, FND_OBJECTS, and FND_GRANTS. Views EGO_COMPANIES_V, EGO_GROUPS_V, EGO_PEOPLE_V, and ENG_CHANGE_ORDER_TYPES_VL resolve valid companies, groups, people, and change order types, while MTL_INTERFACE_ERRORS and MTL_PARAMETERS capture and contextualise import errors.

Usage Notes

EGO_CHANGE_PEOPLE_IMPORT_PKG is invoked internally by Oracle Engineering change management flows rather than called directly from user interfaces. Its routines are typically driven by a concurrent program or by the engineering change order form logic that imports people assignments, with the sequence-based dataset identifier isolating each run. Because the package is documented as "OTHER" and is not referenced by any other database object, customisations should avoid direct invocation and instead rely on the supported engineering change APIs. When reading error output, join MTL_INTERFACE_ERRORS on the relevant interface row and dataset to diagnose rejected records before rerunning the import.