Datafix Script: Missing records in ZX_LINES_DET_FACTORS relating to Accounts Receivables Transactions (Doc ID 2411701.1)

Last updated on APRIL 18, 2025

Applies to:

Symptoms

When attempting to perform credit transaction against a sales invoice, the following error occurs.

ERROR
-----------------------
An unexpected error has occurred. Please contact your system administrator.


FND DEBUG LOG ERROR
======================

ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.BEGIN  ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly  p_upg_trx_info_rec.application_id: 222
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar.BEGIN  ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar  "-1: ORA-00001: unique constraint (ZX.ZX_LINES_U1) violated ORA-01403: no data found"
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END  ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly   x_return_status: U
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.END  ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.update_extn_attrs  RETURN_STATUS = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.calculate_tax  User-Defined Exception
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX  ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors

STEPS TO REPRODUCE
-------------------------

1. Receivables Responsibility > Transactions > Transaction Summary Form
2. Query the Sales Invoice and Click on Find.
3. Click on Actions Menu > Credit
4. Error Message is shown to the user.

Cause

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