Multiple Regimes Applicable for Non-US Countries Causes Order Import to Fail with Partner Integration Issues - Incorrect Status Returned by ZX_TPI_SERVICES_PKG.call_partner_service (Doc ID 1938277.1)

Last updated on OCTOBER 28, 2014

Applies to:

Oracle E-Business Tax - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Oracle Receivables - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Release 12.1.3

You are attempting to test the Tax Calculation for the affected European countries and the Tax call is failing during Order Import.

During the Order Import, ZX_TRX_PRE_PROC_OPTION_GT has a different tax_regime_code than the tax_regime_code in ZX_PRVDR_HDR_EXTNS_GT and ZX_PRVDR_LINE_EXTNS_GT tables.
This is causing an exception to be thrown from Sabrix.

There are three (3) countries in the Transaction, but the tax_regime_code be consistent in all three global temporary tables.
The logic is dependent on these global temporary tables and whenever a tax call is made, the tax_regime_code should be the same in all three tables.


ERROR In the Debug Log
-----------------------
sid:5859697: Unable to fetch tax factors.
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
Trx_Id: 21890, Error Type: ERROR, Error Message: Unable to fetch tax factors.
Incorrect Status returned by ZX_TPI_SERVICES_PKG.call_partner_service.
RETURN_STATUS = E
Incorrect Status returned by Ptnr_calculate_tax_pvt. RETURN_STATUS = E
Expected Error exception occurred for Trx_id 21890
ZX_SRVC_TYP_PKG: DELETE_FROM_LINES_DET_GT(+)
Deleting data for Trx_id : 21890

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