My Oracle Support Banner

Discrepancy Quantity Between GME_RESOURCE_TXNS And GME_BATCH_STEP_RESOURCES (Doc ID 2291942.1)

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.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.