My Oracle Support Banner

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 FEBRUARY 11, 2019

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

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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