ZX.PLSQL.ZX_SRVC_TYP_PKG.update_extn_attrs "ORA-01403: no data found
(Doc ID 2344200.1)
Last updated on NOVEMBER 18, 2024
Applies to:
Oracle Payables - Version 12.0.0 to 12.2.7 [Release 12.0 to 12.2]Oracle Payables - Version 12.2.10 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.
Symptoms
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 |