My Oracle Support Banner

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 01, 2022

Applies to:

Oracle Purchasing - Version 12.2.8 and later
Information in this document applies to any platform.


Using Purchasing, Version 12.2.8

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.

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.

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.



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

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