Search Results validate_assigned_units

Overview

WIP_RES_USAGE_VALIDATE is an Oracle EBS Work in Process (WIP) validation package body owned by the APPS schema. It belongs to the family of interface validation routines used by the open interface import process that moves resource usage records from the WIP_JOB_DTLS_INTERFACE staging table into the live WIP tables. Its business role is to inspect staged resource usage and resource instance usage transactions, apply a series of business rules, and either promote valid rows to the destination tables or flag invalid rows with an appropriate error. The package is classified under ETRM as OTHER, indicating that Oracle does not publish it as a supported public API; customizations that call it directly should be treated as unsupported.

Key Procedures and Functions

The documented ETRM metadata for Release 12.2.2 lists a single publicly documented entry point, VALIDATE_USAGE, which serves as the driver procedure for validating staged resource usage rows. In addition to this documented procedure, the source header exposes a set of internal validation routines that the driver invokes. These include validate_seq_num (the routine surfaced by the "validate_seq_num" search term), which verifies that the resource sequence number is not null; validate_res_seq_num, which checks whether the supplied sequence number already exists in the WIP operation resources data; validate_dates, which confirms that required date fields are populated; and validate_assigned_units, which ensures that assigned units are greater than zero. Further internal checks include val_time_overlap_res_usage and val_time_overlap_ri_usage, which detect overlapping time ranges for resource and resource instance usage respectively, and validate_time_slot, which confirms that usage times fall within a valid slot. The procedure derive_usages operates on a cursor over WIP_JOB_DTLS_INTERFACE rows in the validation phase with a running or warning status, and derives resource sequence numbers, including the logic to copy a parent sequence number when the resource sequence number is null (as corrected by Oracle bug fix 5500805).

Tables Accessed

The package operates against three documented tables accessed through APPS synonyms. WIP_JOB_DTLS_INTERFACE is the primary staging table; the package reads rows from it filtered by group ID, WIP entity ID, organization ID, process phase, process status, load type, and substitution type, and it writes validation status and error information back to it. WIP_OPERATION_RESOURCES and WIP_OP_RESOURCE_INSTANCES are the live WIP resource usage destination tables against which the package validates sequence numbers, detects existing records, and checks for time overlaps before rows are ultimately loaded.

Usage Notes

WIP_RES_USAGE_VALIDATE is not designed for direct invocation by end users. It is typically executed as part of the WIP open interface import workflow, driven by the Resource Usage and Resource Instance Usage import processes, which populate the staging table and then invoke validation and loading. Custom code referencing this package, for example a wrapper that calls VALIDATE_USAGE, will compile and run, but Oracle does not guarantee the interface across patches or upgrades because the package is neither a public nor a private ETRM API. The ETRM repository notes that the package is referenced by one other package, confirming its role as an internal dependency. The header revision (120.2, dated 2006) indicates that the object has been stable across the 12.1.1 and 12.2.2 code lines, though customers should always re-verify behaviour after applying WIP patches.