Records cannot be found in wip_period_balance.

The cause of the error is not found in wip_period_balance: the error message in wip_period_balances is not found in the duplicate schedule or ticket. tutorial: Please refer to Oracle technical support representative. This is because Oracle defined in business logic that the task of the current month must be completed in the current month,

Execute the following statement and resubmit the resource transaction processing:

Insert into wip_period_balances
(Acct_period_id, wip_entity_id,
Repetitive_schedule_id, last_update_date,
Last_updated_by, creation_date,
Created_by, last_update_login,
Organization_id, class_type,
Tl_resource_in, tl_overhead_in,
Tl_outside_processing_in, pl_material_in,
Pl_material_overhead_in, pl_resource_in,
Pl_overhead_in, pl_outside_processing_in,
Tl_material_out, tl_material_overhead_out, tl_resource_out,
Tl_overhead_out, tl_outside_processing_out,
Pl_material_out, pl_material_overhead_out,
Pl_resource_out, pl_overhead_out,
Pl_outside_processing_out,
Pl_material_var, pl_material_overhead_var,
Pl_resource_var, pl_outside_processing_var,
Pl_overhead_var, tl_material_var, tl_material_overhead_var,
Tl_resource_var, tl_outside_processing_var,
Tl_overhead_var)
Select
Oap. acct_period_id, WDJ. wip_entity_id,
Null, sysdate,
0, sysdate,
0, 0,
WDJ. organization_id, WAC. class_type,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
From wip_accounting_classes WAC,
Org_acct_periods oap,
Wip_discrete_jobs WDJ
Where WDJ. status_type in (3, 4, 5, 6, 7, 14, 15)
And WAC. class_code = WDJ. class_code
And WDJ. organization_id = WAC. organization_id
And oap. organization_id = WDJ. organization_id
And oap. open_flag = 'y'
And oap. period_close_date is null
And oap. schedule_close_date> = nvl (WDJ. date_released,
WDJ. creation_date)
And WAC. class_type! = 2
And not exists
(
Select 'x' from wip_period_balances WPB
Where WPB. repetitive_schedule_id is null
And WPB. wip_entity_id = WDJ. wip_entity_id
And WPB. organization_id = WDJ. organization_id
And WPB. acct_period_id = oap. acct_period_id );

**********

 

Record not found in wip_period_balance [ID 730458.1]
	Modification time04-Mar-2009TypeProblemStatusModerated

In this document
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's rapid visibility (RAV) process, and therefore has not been subject to an independent technical review.

Applies:

Oracle work in process-version: 11.5.10 to 12.0
This problem can occur on any platform.
Wiptirsc, WIP mass load

Symptoms

When using open interfaces and inserting a record into the wip_cost_txn_interface table, the cost Manager runs the record errors. In the view resource pending Transactions form (wiptirsc) the error statement is:

"Record not found in wip_period_balance cause: there is no record in wip_period_balances for the repetitive schedule or job ".

 

 

Cause

1) if you are using open interfaces

Missing entries in wip_period_balances table can provocate the errors.

The incorrect use of the open interfaces (wrong parameters) can avoid a mass load to insert rows in the wip_period_balances table. open interfaces says explicitly the correct values that must be inserted for some fields when using the wip_cost_txn_interface table.

2) for unknown reason there're some missed rows

With the following script you can detect if exists missed rows:

Select
WDJ. wip_entity_id,
We. wip_entity_name,
Decode (We. entity_type,
1, 'discrete job ',
2, 'repetitive schedule ',
3, 'closed discrete job ',
4, 'flow/work order-less ',
5, 'Lot based job ',
6. 'eam job ',
We. entity_type) entity_type,
WDJ. organization_id,
Oap. acct_period_id,
WDJ. date_released,
WAC. class_type
From wip_accounting_classes WAC,
Org_acct_periods oap,
Wip_discrete_jobs WDJ,
Wip_entities we
Where WDJ. status_type in (3, 4, 5, 6, 7, 14, 15)
And WAC. class_code = WDJ. class_code
And WDJ. organization_id = WAC. organization_id
And oap. organization_id = WDJ. organization_id
And WDJ. wip_entity_id = We. wip_entity_id
And WDJ. organization_id = We. organization_id
And oap. open_flag = 'y'
And oap. period_close_date is null
And oap. schedule_close_date> = nvl (WDJ. date_released, WDJ. creation_date)
And WAC. class_type! = 2
And not exists
(
Select 'x' from wip_period_balances WPB
Where WPB. repetitive_schedule_id is null
And WPB. wip_entity_id = WDJ. wip_entity_id
And WPB. organization_id = WDJ. organization_id
And WPB. acct_period_id = oap. acct_period_id );

Solution

1) For cause #1
When inserting data into the wip_cost_txn_interface table, set the process_phase field with value 1, which means "Move validation". This is mandatory.

2) For cause #2

Please log a SR with Oracle Support to get the datafix to add the missed rows.

 

Related Product · Oracle E-Business Suite> manufacturing> Discrete Manufacturing> oracle work in process Keywords Open interfaces; WIP mass load; wip_cost_txn_interface; wip_period_balances; move transactions