The Component Shortages tab in the Shopfloor Progress region lists shortages according to the values calculated by the Component Shortage Calculation concurrent request. This request program calculates and lists the job operations by operation start date and time, and then the components allocated. You can change this display sequence and use additional criteria or attributes for the allocation of components through the Component Shortage Calculation client extension.
Use the following information to supply the algorithm to reorder in the procedure. The reordered list is used as input for the shortage calculation program.
Operation Reordering Procedure - reorder_ops_for_shortage
| Parameter | IN/OUT | Type | Description |
|---|---|---|---|
| p_wip_job_op_tbl | IN OUT NOCOPY | WIP_WS_SHORTAGE.wip_job_op_tbl_type | Job operations list |
| p_return_status | OUT NOCOPY | VARCHAR2 | Value S determines success, otherwise the unexpected exception is called. |
| p_retcode | OUT NOCOPY | NUMBER | Reserved for future use |
WIP_WS_SHORTAGE .wip_job_op_rec_type record type
| Parameter | Type | Description |
|---|---|---|
| ORGANIZATION_ID | NUMBER | Organization identification |
| WIP_ENTITY_ID | NUMBER | WIP entity identification of the job |
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number |
| DEPARTMENT_ID | NUMBER | Department identification |
| FIRST_UNIT_START_DATE | DATE | First unit scheduled receipt date |
| START_QTY | NUMBER | Number of units scheduled for the operation (subtracted by) Total number of assemblies scrapped in previous operations |
| OPEN_QTY | NUMBER | Number of units scheduled for the operation (subtracted by) Total number of assemblies scrapped in previous operations |
| SCHEDULED_QTY | NUMBER | Number of units scheduled for the operation |
Note: The wip_job_op_rec_type record is indexed by BINARY_INTEGER.
Component and resource shortages are calculated for a fixed horizon of two days by default. You can change this period using the custom client extension wip_ws_custom.get_shortage_calc_days. You can define the number of working days from current date to a date when the shortages have to be calculated.
wip_ws_custom.get_shortage_calc_days
| Default Return Value | 2 |
| Parameter Name | p_org_id |
| Type | NUMBER |
| Mode(IN/OUT) | IN |
| Description | Organization ID for the customer defining the number of days for shortage calculation. |
In the custom client extension, the Return value (X) in the code refers to the number of days you enter to calculate the shortages:
function get_shortage_calc_days(p_org_id number) return number;
is
begin
return(X);
end get_shortage_calc_days