The Step Resources Screen Allows Transacted Resources to be Deleted from a Batch, Causes Error in Create Accounting, "The following events are present in the line extract but MISSING in the header extract" (Doc ID 2866763.1)

Last updated on JUNE 06, 2024

Applies to:

Symptoms

The Step Resources screen (Production Supervisor > Batch Steps > Activities > Resources) allows resources to be deleted even after transactions have been created for the resource in the batch. Although the form does not seem to allow a resource to be deleted if a step is WIP or Completed, you can Unrelease the step and then delete the resource.

Later, when running Create Accounting, this causes an error because the join between gmf_xla_extract_headers and gme_ batch_step_resources fails and gives an error:
"The following events are present in the line extract but MISSING in the header extract"

EXPECTED BEHAVIOR
-----------------------
Expect the form (and the delete API's in GME_API_PUB such as DELETE_BATCHSTEP_RESOURCE, DELETE_BATCHSTEP_ACTIVITY, and DELETE_STEP) to disallow a resource to be deleted if it has been transacted in the batch, even if that transaction has been reversed and the step has been Unreleased.


The issue can be reproduced at will with the following steps:
1. Create a batch containing a step with more than one resource, Release the batch, Release the step (Production Supervisor > Batch Details > Steps button).
2. Enter a resource transaction for the step.
3. Optionally, delete the transaction (creating a reversal in the background).
4. Unrelease the step.
5. Delete the resource.

Changes

Cause

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