R12: ZX: Intercompany Invoice Validation Error (Doc ID 2153268.1)

Last updated on AUGUST 01, 2017

Applies to:

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

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, when a user attempts to Validate intercompany invoices the following error is generated in the FND Log:


ERROR
-------
ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)
Incorrect return_status after calling ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx
RETURN_STATUS = E
ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)
RETURN_STATUS = E
RETURN_STATUS = E
Expected Error exception raised
1 Transaction(s) in Header Table.
ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX_API_PUB: CALCULATE_TAX:Calculate_Tax_Pvt returned errors. Return Status: E
ZX_API_PUB: DUMP_MSG()+
1 Error Message(s) inserted into ZX_ERRORS_GT.
G_ERRORS_EXIST_IN_GT: Y
ZX_API_PUB: DUMP_MSG()-
EXCEPTION : Expected Error
Start Time :18-05-2016 16:29:23
End Time :18-05-2016 16:29:25
Total Time :0:0:2
Number of partner calls :0
Time taken by partner(secs) :0
Number of records in ZX_TRX_HEADERS_GT :1
Number of records in ZX_TRANSACTION_LINES_GT :3
Handle errors returned by API
Get error message from eTax API
ZX_INTER_COMP_RATE
"Unexpected error occurred during Tax Calculation.
Exception: ZX_INTER_COMP_RATE
Please correct the problem or contact your System Administrator."

2. BUSINESS IMPACT
----------------------
Due to this issue, users cannot pay supplier on-time. Late payments affect the payment terms established by suppliers and consequently disrupts the business continuity of the organization. Moreover, the current payables accounting period cannot be closed. Problematic transactions will have to be swept to the following period, which is not in agreement with the date in which the transactions occurred.


3. STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Invoices : Inquiry > Invoices

3. Query the invoice to and try to validate the invoice



4. ENVIRONMENT IN WHICH ISSUE IS OBSERVED
---------------------------------------------------
Product: Oracle Payable
Release: 12.1.3
Database: No information provided because the issue is not database or platform specific.
Platform: Linux
Instances Affected: Test and Production
System Names: This information is not relevant for the resolution of the issue.
Affecting Certain Users? The issue is consistently observed with all the users.


5. EXPECTED OR ACCEPTABLE RESULT
-----------------------------------------
Able to Validate the invoice without error message


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