Results for “insert_instance”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.EAM_SKILL_INSTANCE is a stored PL/SQL package in Oracle E-Business Suite that supports Enterprise Asset Management (EAM) and discrete manufacturing execution. Its specific business purpose is to manage the assignment of instances to work order operation resources. In the EAM and Work in Process (WIP) context, an "instance" represents a discrete, tracked unit of a resource — for example, a specific piece of equipment, a serialized tool, or an individually identified asset — that is attached to a resource requirement on a work order. The package provides the programmatic interface for inserting such an assignment, verifying that it is not a duplicate, reconciling assigned unit counts, firming the affected work order, and removing the assignment when it is no longer valid. As declared with AUTHID CURRENT_USER, the package executes with the privileges of the calling user rather than the definer, so callers must themselves hold appropriate privileges on the underlying WIP tables and synonyms.

Key Procedures and Functions

• INSERT_INSTANCE — Assigns an instance to a work order resource. It accepts identifiers for the work order (WIP entity), operation sequence, resource sequence, organization, the user performing the action, the instance itself, and start/completion dates. It returns an output value indicating the updated assigned unit count. This is the primary entry point for creating an instance-to-resource assignment.
• IS_DUPLICATE_INSTANCE — A boolean-returning function that checks whether a given instance has already been assigned to the specified work order operation resource. It guards against double assignment of the same instance.
• CHECK_ASSIGNED_UNITS — Verifies the number of units currently assigned and increments the count where necessary, returning an output flag indicating whether the assigned quantity changed. This keeps resource assignment quantities consistent with the instances attached.
• FIRM_WORK_ORDER — Firms the work order after an instance has been assigned, ensuring the schedule is fixed so the committed resource cannot be displaced.
• REMOVE_INSTANCE — Removes a previously assigned instance from a resource, using the work order, operation sequence, resource sequence, and instance identifiers as keys.

Tables Accessed

The package reads and writes through APPS synonyms for three core WIP tables:

• WIP_DISCRETE_JOBS — the work order header that is firmed and referenced by the assignment.
• WIP_OPERATION_RESOURCES — the resource requirements on work order operations that receive the instance assignment and whose assigned units are reconciled.
• WIP_OP_RESOURCE_INSTANCES — the intersection table that physically stores the instance-to-resource assignment records inserted and deleted by this package.

Usage Notes

EAM_SKILL_INSTANCE is an internal API layer rather than an end-user-facing component. It is most commonly invoked indirectly through Oracle's EAM and WIP forms and concurrent programs that handle resource instance assignment during work order execution. Because it is not referenced by any other documented package, it is effectively a leaf consumer of the WIP schema, meaning custom extensions or integrations that manipulate resource instances on work orders must call it directly. Custom code should observe the duplicate-check and assigned-unit reconciliation logic by calling IS_DUPLICATE_INSTANCE and CHECK_ASSIGNED_UNITS before and after INSERT_INSTANCE, and should commit only after FIRM_WORK_ORDER succeeds in order to preserve scheduling integrity. As with all APPS APIs, direct DML against the underlying tables should be avoided in favor of these procedures to maintain data consistency.