R12: AP/CE/XLA: Accounting for a Payment Fails with "No Intercompany Payables account has been selected as the Multiple Legal Entity Balancing Account for the From and To legal entities" Even Though Automatic Offsets is Enabled (Doc ID 1962131.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Symptoms

Even though Automatic Offsets are enabled the Create Accounting output shows a payment failed to account with the following error:

To Replicate:

1. From a Payables Responsibility navigate to Setup -> Options -> Payables Options
2. Select the operating unit and click "Find"
3. On the "Accounting Options" tab set "Automatic Offset Method" to "Balancing"
4. Save
5. From a Payables Responsibility navigate to Setup -> Payments -> Bank Accounts
6. Query the disbursement account to be used and click "Update Account"
7. Click on the "Account Controls" tab
8. Uncheck "Pooled Account"
9. Save
10. From a Payables Responsibility navigate to Invoices -> Entry -> Invoices
11. Create an invoice that uses multiple accounts with different balancing segments
12. Validate and approve the invoice
13. Click on Actions -> Pay in Full
14. Create a  payment to pay the invoice
15. From a Payables Responsibility navigate to Other -> Requests -> Run
16. Submit "Create Accounting"
17. View the output and see the error for the payment.

Cause

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