My Oracle Support Banner

ZX.PLSQL.ZX_SRVC_TYP_PKG.update_extn_attrs "ORA-01403: no data found (Doc ID 2344200.1)

Last updated on MAY 03, 2021

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.7 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Invoice Issues & MassAdd

When attempting to validate the invoice
the following error occurs (as shown in the fnd log)

Error:
ZX.PLSQL.ZX_SRVC_TYP_PKG.lock_line_det_facts.BEGIN ZX_SRVC_TYP_PKG: lock_line_det_facts()+
ZX.PLSQL.ZX_SRVC_TYP_PKG.lock_line_det_facts.END ZX_SRVC_TYP_PKG: lock_line_det_facts()-, RETURN_STATUS = S
ZX.PLSQL.ZX_SRVC_TYP_PKG.update_extn_attrs.BEGIN ZX_SRVC_TYP_PKG: update_extn_attrs()+
ZX.PLSQL.ZX_SRVC_TYP_PKG.update_extn_attrs Calling upgrade_trx_on_fly for Ref Doc Trx ID = 23165
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: 201
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.BEGIN ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(+)
....

ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.BEGIN ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po Inserting data into zx_lines_det_factors
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po Number of Rows Inserted = 0
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po Inserting data into zx_lines: tax code
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po Number of Rows Inserted(Tax Code) = 0
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po Inserting data into zx_lines
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po Number of Rows Inserted(Tax Group = 0
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po Inserting data into zx_rec_nrec_dist
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po Number of Rows Inserted = 0
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly x_return_status:
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 "ORA-01403: no data found ORA-01403: no data found"
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

Replication Steps:
The issue can be reproduced at will with the following steps:
When attempting to validate the invoice



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
Cause
Solution
References


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