APP-SQLAP-97731

Invoice Error APP-SQLAP-97731 For an Imported Invoice [ID 855012.1]

Applies to:

Oracle Payables - Version: 12.0.4 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
zxdwtxcalsrvpubb.pls

Symptoms

-- Problem Statement:
User exported expense reports from iExpense to Payables through Expense Report Export.
One invoice for one supplier receives the following error when you attempt to look at distributions:
"APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to
the following error: &TOKEN1"

Then the lines that do show up do not add up to the total of the invoice. Lines are missing.

-- Steps To Reproduce:
Run iExpense to Payables through Expense Report Export.
For one invoice some lines are missing,.
Application returned:
"APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to
the following error: &TOKEN1"

Cause

Incorrect version of zxdwtxcalsrvpubb.pls

Issue discussed in Bug 8348107: OE INVOICE VALIDATION ISSUES - TAX CALCULATION ERRORS APP-SQLAP-97731

Issue fixed in the package zxdwtxcalsrvpubb.pls to 120.130.12000000.16

Solution

1) Please download and review the readme for Patch 7537542

2) Please apply patch in a test environment.

3) Please confirm the following file versions:
zxdwtxcalsrvpubb.pls 120.130.12000000.17

4) Please retest the issue.

5) If satisfied then migrate to other environments.