AR AutoInvoice Rejecting AGIS Transactions with Error: Please correct the receivable account assignment (Doc ID 1988511.1)

Last updated on JUNE 13, 2023

Applies to:

Symptoms

1. When running Receivables (AR) AutoInvoice request to generate invoices for AGIS Transactions, this ends with the errors below and invoices cannot be generated.

Please correct the revenue account assignment ...
Please correct the receivable account assignment ...

2. The AGIS Transaction is successfully approved and has all accounting information correctly generated.

3. The AGIS system option 'Transfer Transactions to Payables and Receivables' it set to Online mode.

  If the Transfer to Receivables program is run manually, it will error out.

4. Checking the records inserted in RA_INTERFACE_DISTRIBUTIONS_ALL table, you find that there are missing lines.

  For example, for a transaction with two accounting lines (one for the Distribution account and one for the Intercompany account generated in AGIS), only one line would be populated in RA_INTERFACE_DISTRIBUTIONS_ALL table.

STEPS
The issue can be reproduced at will with the following steps:
1. In Outbound Transaction create a new Batch and ensure it gets approved, having Intercompany Balancing lines generated as expected.
2. Transfer to Receivables AR Interface is automatically launched and completed.
3. Run AutoInvoice
4. View the Output File and find the errors

Alternatively, change the 'Transfer Transactions to Payables and Receivables' system option to Batch mode in order to manually submit the Transfer to Receivables AR Interface.
This request will error out, while there is no error when it is automatically triggerred by the Online option.

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.