Results for “appl_inst_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
INV_ITEM_UTIL is a utility package body in the APPS schema of Oracle E-Business Suite, classified under the ETRM as a UTIL (utility) API. Its primary business function is installation and status verification for the Oracle Inventory and related applications within the EBS technology stack. Rather than performing transactional inventory operations such as item creation, category assignment, or on-hand maintenance, the package serves as an administrative and diagnostic layer. It confirms that specific application modules — Inventory, Purchasing, Bills of Material, Engineering, and others — have been installed and are accessible in the current environment. The package is valid in both Oracle EBS 12.1.1 and 12.2.2. Because it is a package body without a documented public specification in the ETRM extract, its routines are largely internal support procedures invoked by other EBS components rather than direct end-user APIs.
Key Procedures and Functions
The ETRM metadata documents 41 procedures and functions. The dominant pattern is a family of application installation and status checks, each targeting a specific product family:
- Core installation helpers: APPL_INSTALL performs the generic installation validation plumbing shared by the product-specific variants, while APPL_INST_STATUS returns the installation status of a given application.
- Inventory and procurement: APPL_INST_INV validates the Inventory application, and APPL_INST_PO validates Purchasing.
- Manufacturing and engineering: APPL_INST_BOM (Bills of Material), APPL_INST_ENG (Engineering), and APPL_INST_WIP (Work in Process) verify the manufacturing suite.
- Order management and pricing: APPL_INST_OE, APPL_INST_ONT (Order Management), and APPL_INST_QP (Advanced Pricing) confirm order capture and pricing modules.
- Financials: APPL_INST_AR (Receivables), APPL_INST_FA (Assets), and APPL_INST_JL (Journal Ledger) validate financial application presence.
- Supply chain execution: APPL_INST_MRP (Material Requirements Planning), APPL_INST_CS, APPL_INST_CSP, APPL_INST_CSS, and APPL_INST_WMS (Warehouse Management) cover planning and logistics.
- Specialty modules: APPL_INST_AMS (Marketing), APPL_INST_OKS (Service Contracts), and APPL_INST_CS round out the documented list.
All procedures follow a uniform naming convention — APPL_INST_<product_short_code> — indicating that each is a thin wrapper returning or recording installation state. No parameter lists are documented in the ETRM extract, and none should be assumed.
Tables Accessed
The package references three data dictionary views through APPS synonyms: AD_DDL, ALL_OBJECTS, and USER_OBJECTS. AD_DDL is the Applications DDL utility view, used to determine whether specific database objects have been created during installation. ALL_OBJECTS and USER_OBJECTS provide catalog metadata enabling the package to confirm that expected packaged objects exist and are VALID in the schema. Additional dependencies include AD_TSPACE_UTIL (tablespace utility), FND_FILE (concurrent program file I/O), FND_INSTALLATION (installation registry), and PJM_UNIT_EFF. These reads are non-destructive; the package is a consumer of metadata rather than a writer of business data.
Usage Notes
INV_ITEM_UTIL is referenced by 21 other database objects, confirming its role as a shared infrastructure dependency rather than an end-user API. It is typically invoked during application installation, patching, and upgrade cycles to verify that dependent products are present before downstream logic executes. It may also be called from concurrent programs or custom code that needs to branch on application installation state. Because the package body is marked VALID and is not referenced by forms directly, developers should treat it as internal EBS plumbing; customizations should call documented public APIs rather than these APPL_INST_* routines, whose signatures are not exposed in the ETRM documentation.
-
View of IGS_AD_PS_APPL_INST. Incorporates alternate codes and calendar instance start and end dates for both the Admission and Deferred Admission calendars. Also incorporates Admission Course Application details.
APPS.IGS_AD_PS_APPL_INST_APLINST_V·↳ HZ_PARTIES·↳ IGS_AD_APPL·↳ IGS_AD_BASIS_FOR_AD·Explore IGS module →
-
Holds Information about Admission Application Program Details
APPS.IGSBV_AD_ADM_PS_APPL_INST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
Describes history of changes to admission program application instance
-
Request for program entry for an admission period
APPS.IGS_AD_PS_APLINSTHST_APLHIST_V·↳ IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APPL_HIST·↳ IGS_GE_DATE·Explore IGS module →
-
View of IGS_AD_APPL and IGS_AD_PS_APPL_INST. Used for Admission Application Summary block on ADMF3000.
APPS.IGS_AD_PS_APPL_INST_APLSUMR_V·↳ IGS_AD_APPL·↳ IGS_AD_PS_APPL_INST·↳ IGS_CA_INST·Explore IGS module →
-
View: IGS_AD_PS_APLINSTHST 12.1.1
APPS.IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APLINSTHST_ALL·Explore IGS module →
-
Describes the request for program Entry for an Admission period
APPS.IGSFV_AD_ADM_PS_APPL_INST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_CNDNL_OFRSTAT·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST 12.1.1
APPS.IGS_AD_PS_APPL_INST·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
Holds the admission application instance history details that need to get imported for an application, during legacy import
-
APPS.IGS_AD_PS_APLINSTHST_HISTORY_V·↳ IGS_AD_PS_APLINSTHST_APLHIST_V·↳ IGS_AD_PS_APPL·↳ IGS_AD_PS_APPL_INST_APLINST_V·Explore IGS module →
-
Holds the request for program entry for an admission period
-
View: IGS_AD_PS_APPL_INST_SV 12.1.1
View of IGS_AD_PS_APPL_INST_ALL to secure the select operation on this table
APPS.IGS_AD_PS_APPL_INST_SV·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
View: IGS_AD_PS_APLINSTHST 12.2.2
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Holds Information about Admission Application Program Details
Not implemented in this database·Explore IGS module →
-
View of IGS_AD_APPL and IGS_AD_PS_APPL_INST. Used for Admission Application Summary block on ADMF3000.
Not implemented in this database·Explore IGS module →
-
Request for program entry for an admission period
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST_SV 12.2.2
View of IGS_AD_PS_APPL_INST_ALL to secure the select operation on this table
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST 12.2.2
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.INV_ITEM_UTIL 12.1.1
-
PACKAGE: APPS.INV_ITEM_UTIL 12.2.2
-
Describes the request for program Entry for an Admission period
Not implemented in this database·Explore IGS module →
-
View of IGS_AD_PS_APPL_INST. Incorporates alternate codes and calendar instance start and end dates for both the Admission and Deferred Admission calendars. Also incorporates Admission Course Application details.
Not implemented in this database·Explore IGS module →