My Oracle Support Banner

R12: AP: APP-SQLAP-97731 Error Occurs When Opening the Same Invoice by Multiple Users (Doc ID 2399824.1)

Last updated on JULY 27, 2023

Applies to:

Oracle Payables - Version 12.0.0 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

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
Goal
Solution
References


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