Discrepancy Quantity Between GME_RESOURCE_TXNS And GME_BATCH_STEP_RESOURCES
Last updated on JANUARY 02, 2018
Applies to:Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
The resource usage data is mismatched between the two table GME_RESOURCE_TXNS and GME_BATCH_STEP_RESOURCES
The resource usage data is matched between the two table GME_RESOURCE_TXNS and GME_BATCH_STEP_RESOURCES
- create batch # xxx
- release batch and batch step
- create first resource txn with qty 3, save
- create second resource txn with qty 2, save
- change second resource txn qty from 2 to 1, and move mouse focus to first
resource txn (3 qty), then back to second resource txn (1 qty), click delete
red icon 'x', save.
- query backend table
select sum(resource_usage) from GME_RESOURCE_TXNS
where doc_id = xxx
and completed_ind=1;--resource_usage = 4;
select actual_rsrc_usage from GME_BATCH_STEP_RESOURCES
where batch_id = xxx; -- actual_rsrc_usage=3.
The resource usage data is mismatched between the two table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms