Requisition Import Updates All The Lines to an Error Status When Account Generation Fails - CHARGE_ACCOUNT_ID "Charge Account is Invalid" (Doc ID 2827884.1)

Last updated on FEBRUARY 19, 2025

Applies to:

Symptoms

Using Purchasing, Version 12.2.8

Actual:
Requisition Import will set all records to ERROR status if the account generator fails to build the accounts for one of the rows in question.

Expected:
The records which belong to a subsequent group - based on req_number_segment1 or group_code or some other logical factor should process - regardless if the charge account fails for a subsequent group.

Errors:
All records fall into this failure, as noted in the po_interface_errors table and output of the Requsition Import Exceptions report..
CHARGE_ACCOUNT_ID "Charge account is invalid
Cause: The charge account that you entered is invalid.
Action: Enter a valid charge account.
"
VARIANCE_ACCOUNT_ID "Variance account is invalid
Cause: The variance account that you entered or that was derived is invalid.
Action: Enter a valid variance account.
"

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Populate the po_requisitions_interface_all with data that is essentially in two sub-sets.
2. One subset of data will fail due to the account generator.
3. Other records are valid and should process.
4. All records fail.

_______________________________________________________________________

Here are example records - 2 of which will error and 2 of which should process.
The goal is to create two requisitions - but could be more.
Note, that upon running requisition import - all went into error - and no requisitions were created.

req_number_segment1 is now given.
removed group_code and all references to the ccid.

Cause

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