Discrepancy Quantity Between GME_RESOURCE_TXNS And GME_BATCH_STEP_RESOURCES (Doc ID 2291942.1)

Last updated on JULY 30, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

The resource usage data is mismatched between the two table GME_RESOURCE_TXNS and GME_BATCH_STEP_RESOURCES

Expected Behavior

The resource usage data is matched between the two table GME_RESOURCE_TXNS and GME_BATCH_STEP_RESOURCES

Reproducible Steps

- 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms