Attempt to Complete a Credit Transaction Fails with Error - Unable To Create Credit Transaction - ZX.PLSQL.ZX_SRVC_TYP_PKG ORA-01403: No Data Found (Doc ID 1628384.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

Attempting to create a Credit Transaction and find the Complete button is greyed out.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Transactions > Credit Transactions
Credit balance and Save
Once saved, the complete button is greyed out. You cannot complete the credit.

If you credit on a line basis, it works. But, if you credit tax, the error occurs.

Error in FND log file:

ZX.PLSQL.ZX_SRVC_TYP_PKG.DERIVE_POA_PARAMETERS 6 ORA-01403: no data found
ZX.PLSQL.ZX_SRVC_TYP_PKG.DERIVE_INTERNAL_PARAMETERS 6 ORA-01403: no data found
ZX.PLSQL.ZX_SRVC_TYP_PKG.INSUPD_LINE_DET_FACTORS 1 RETURN_STATUS = U
ZX.PLSQL.ZX_API_PUB.INSERT_LINE_DET_FACTORS 1 ZX_API_PUB: INSERT_LINE_DET_FACTORS:ZX_SRVC_TYP_PKG.insupd_line_det_factors returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 2 0 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()-
ar.plsql.populate_ebt_plsql_tables 1 line_det_factors returned error
ar.plsql.populate_ebt_plsql_tables 1 API failed with : An unexpected error has occurred. Please contact your system administrator.
ar.plsql.populate_ebt_plsql_tables 4 EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id
ar.plsql.populate_ebt_plsql_tables 1 p_customer_trx_id         = 2335858
ar.plsql.populate_ebt_plsql_tables 1 p_customer_trx_line_id    =
ar.plsql.populate_ebt_plsql_tables 1 p_prev_customer_trx_id    = 2326983
ar.plsql.populate_ebt_plsql_tables 1 p_line_type               = LINE
ar.plsql.populate_ebt_plsql_tables 1 p_uncredited_amount       = 2795
ar.plsql.populate_ebt_plsql_tables 1 p_credit_amount           = -2795
ar.plsql.populate_ebt_plsql_tables 1 p_currency_code           = USD
ar.plsql.populate_ebt_plsql_tables 4 EXCEPTION: derive_credit_information
ar.plsql.populate_ebt_plsql_tables 4 EXCEPTION: arp_process_credit.insert_header
ar.plsql.populate_ebt_plsql_tables 4 EXCEPTION : arp_process_credit_cover.insert_header_cover

Changes

Applied patches

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