My Oracle Support Banner

R12:AP:APP-SQLAP-4667613: Matching could not be completed due to application error while synchronizing quantity and amount billed on PO. Try again (Doc ID 2645515.1)

Last updated on MARCH 04, 2020

Applies to:

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

Symptoms

When trying to cancel the invoice getting the below error 

 

The quantity has not been converted from N to Kilogram, since the UOM conversion is not available for this combination.
;SQLERRM = ORA-20001: The quantity has not been converted from N to Kilogram, since the UOM conversion is not available for this combination.
ORA-20001: The quantity has not been converted from N to Kilogram, since the UOM conversion is not available for this combination.;SQLERRM = ORA-20001: The quantity has not been converted from N to Kilogram, since the UOM conversion is not available for this combination.
"APP-SQLAP-4667613: Matching could not be completed due to application error while synchronizing quantity and amount billed on PO. Try again.
Error detail: User-Defined Exception
inside AP_INVOICE_LINES_PKG.Discard_Inv_Line <-AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE<-APXINWKB

 

When Validating the invoice getting unexpected error 

 

ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes No Applicable Regimes
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes.END ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes(-)
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax.BEGIN ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(+)
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date.BEGIN ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(+)
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(-) Tax date = 23-DEC-19Tax determine date = 23-DEC-19Tax point date = 23-DEC-19
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.BEGIN ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(+)
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account l_chart_of_accounts_id = 101
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account Getting tax code using code combination ID.0
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account 100: ORA-01403: no data found
ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax Incorrect return_status after calling ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax RETURN_STATUS = U
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax.END ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.calculate_tax_pvt RETURN_STATUS = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.calculate_tax RETURN_STATUS = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.calculate_tax User-Defined Exception
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.BEGIN ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.END ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX ZX_API_PUB: CALCULATE_TAX:Calculate_Tax_Pvt returned errors. Return Status: U
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX EXCEPTION : Unexpected Error
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Start Time :25-02-2020 15:42:42
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics End   Time :25-02-2020 15:42:42
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Total Time :0:0:0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Number of partner calls :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Time taken by partner(secs) :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Number of records in ZX_TRX_HEADERS_GT :1
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Number of records in ZX_TRANSACTION_LINES_GT :4
AP.PLSQL.AP_ETAX_SERVICES_PKG.Calculate Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages An unexpected error has occurred. Please contact your system administrator.
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "Unexpected error occurred during Tax Calculation.
Exception: An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator."

 

When trying to reverse the line having the issue getting below error 

APP-SQLAP-1000:ORA-01403: no data found occured in AP_AID_TABLE_HANDLER_PKG>Update_Row<-AP_INVOICE_DISTRIBUTIONS_PKG.Update_Row<-APIXINWKB

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.