Autocreating a Requisition To Purchase Order is Failing - Purchase Order Creation Could Not be Initiated. Please Check With Your System Administrator. (Doc ID 2213758.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3


Actual:
Upon submitting the purchase order - a tax error is encountered.
During autocreate an error is encountered.

Expected:
The tax error should not occur.

Error:
An error occurred during tax calculation.
Please correct the problem or contact your system administrator.
Unexepected error occurred during tax calculation. Exception: 023 - An unexepected error has occurred.

If using the sourcing module to complete the award - this error occurs:
Purchase Order creation could not be initiated.
Please check with your system administrator.

Replication Steps:
1. Purchase Order 112000077211 is pulled up in the buyer work center.
2. Purchase order is submitted for approval - but the error is encountered.


From the FND Logging -

XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 Begin
XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 zx_tax_partner_pkg.g_tax_regime_code=> US USE TAX
XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 Getting service end point from vertex_service_ent_pt
XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 "ERROR BACKTRACE is: ORA-06512: at ""APPS.P_VERTEX_ETAX_P2P_PKG"", line 272
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 "ERROR STACK is: ORA-01403: no data found
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.SET_OIC_CONFIG_TBL 1 Exception => ORA-01403: no data found
XXVTX.P_VERTEX_ETAX_P2P_PKG.P_VERTEX_TAX_CAL 1 Unable to set SET_OIC_CONFIG_TBL => ORA-01403: no data found
XXVTX.P_VERTEX_ETAX_P2P_PKG.P_VERTEX_TAX_CAL 1 "ERROR BACKTRACE is: ORA-06512: at ""APPS.P_VERTEX_ETAX_P2P_PKG"", line 1075
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.P_VERTEX_TAX_CAL 1 "ERROR STACK is: ORA-06510: PL/SQL: unhandled user-defined exception
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.P_VERTEX_TAX_CAL 1 Exception e_set_oic_config_tbl, outside vertex

 

Also:

ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN 1 ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)tax_rate_id =
ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info 6 -6502: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END 6 ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency.BEGIN 1 ZX_TDS_TAX_ROUNDING_PKG: convert_to_currency(+)p_to_curr_conv_rate = 1
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency.END 1 ZX_TDS_TAX_ROUNDING_PKG: convert_to_currency(-)conversion rate = 1p_return_status = S
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.round_tax.BEGIN 2 ZX_TDS_TAX_ROUNDING_PKG: round_tax(+)round rule = DOWNp_min_acct_unit = p_precision = 2

 

 

 

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