R12: APXINWKB Unable To Validate Intercompany AP Invoice with Tax from AGIS Error APP-SQLAP-97731

(Doc ID 461685.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle E-Business Tax - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
APXINWKB - Invoice Workbench
AGIS - Advanced Global Intercompany System
APXIIMPT - Open Interface Import

Symptoms


Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

-- Problem Statement:
Querying and clicking into the distributions window for AP intercompany invoices that were created in Advanced Global Intercompany System(AGIS) errors with:

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.

Clicking OK to acknowledge the error displays the distributions with a Null amount which is a required field.

Invoices cannot be validated as the same error occurs.

-- Steps To Reproduce:
Create intercompany transaction in AGIS
Transfer to AP via Open Interface Import
Query invoice number in invoice workbench
Click Distributions button
Receive error
Click OK to acknowledge
Distribution line is shown but with a null amount

-- Business Impact:
Due to this issue, users cannot see distribution line correctly and invoices cannot be validated and processed.

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