AR_00202 Create Accounting: Invoice Fails Create Accounting Due to Missing Non-Model TAX Rows (Doc ID 1565612.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
ARACCPB - Submit Accounting
XLAACCPB - Create Accounting

Symptoms

Two invalid invoices with invoicing rules are failing create accounting. Create accounting error:

The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.

The Transaction Diagnostics for the invoices show there are records that are missing Non-Model TAX rows in RA_CUST_TRX_LINE_GL_DIST_ALL.

These tax rows exist in the other AR tables: RA_CUSTOMER_TRX_LINES_ALL and AR_PAYMENT_SCHEDULES_ALL.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms