My Oracle Support Banner

R12: AP: After Automatic Offset Method Changed To Balancing, Accounting For Invoice With Self-Assessed Tax Fails With Error 0; Self-Assessed Tax Liability Credit Line Is Not Generated. (Doc ID 2751766.1)

Last updated on AUGUST 10, 2021

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


Self-Assessed Tax Liability Accounting Line Not Generated For Invoice With Self-Assessed Tax, After Automatic Offset Method Changed To Balancing

Create Accounting fails on Invoice with self-assessed tax.  Unbalanced accounting generated.

Create accounting does not generate the "Self Assessed Tax Liability" - Credit accounting line for an invoice with self-assessed taxes.

The "Subledger Accounting Program Report" shows the following error for the failing invoice:

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

The "Subledger Accounting Program Report" shows the following unbalanced accounting lines generated for the invoice:

Line Accounting Class Debit or Credit
1 Item Expense Debit
2 Liability Credit
3 Self-Assessed Non-Rec Tax Debit

Line 4 - Self Assessed Tax Liability - Credit - Is Not Generated

Here is an excerpt of the Subledger Accounting Program Report:


Steps to reproduce:

  1. Login sing Payable Responsibility.
  2. Open the "Payables Options"
    (N) SetUp > Options > Payables OPtions
  3. In the [Accounting Options] tab Change the "Acutomatic Offset Method" to Balancing.
  4. Save changes.

  5. Open the "Invoice Workbench"
    (N)Invoices > Entry > Invoices
  6. Create a New Invoice with the proper values to generate Self-Assessed Taxes.
  7. Validate the Invoice using the Online Validation.
  8. Open the "Standard Request Submission" (SRS) screen
    (N)Other > Requests > Run
  9. Submit the "Create Accounting" program.
  10. Review the request Out and Log



Changed the Payables Accounting Option "Automatic OffSet Method" to Balancing




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
 A. To check and confirm you are missing the JLTs mentioned above.
 B. To correct the issue, add the missing JLTs
 C. If still a problem, please submit a new Service Request (SR) with Oracle Support.

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