R12: AP: APP-SQLAP-97731 Error Occurs When Open the Same Invoice by Multiple Users

(Doc ID 2399824.1)

Last updated on MAY 16, 2018

Applies to:

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

Goal

When attempting to click the Distribution button in the Invoice Workbench form, the following error occurs:

Error Message:
APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error; An unexpected error has occurred. Please contact your system administrator.
or
APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error; ZX_UNEXPECTED_ERROR


The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility.
2. Navigate to Invoices : Invoices > Entry > Invoice
3. Query the invoice and click the Distributions button.
4. In the distributions form, Distribution Class shows "Preview".
5. Other user query for the same invoice.
6. Other user click the Distribution button, the APP-SQLAP-97731 error is shown.
 

Solution

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