How to Recreate Missing Purchase Order PO Data in ZX_LINES_DET_FACTORS
(Doc ID 2532388.1)
Last updated on APRIL 21, 2024
Applies to:
Oracle Payables - Version 12.2.3 to 12.2.3 [Release 12.2]Oracle Purchasing - Version 12.1.2 and later
Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.
Goal
With the creation of a purchase order - there should be a record in ZX_LINES_DET_FACTORS.
How can the data be created if for some reason the record is not present in ZX_LINES_DET_FACTORS?
From FND Logging:
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
Solution
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
| Goal |
| Solution |
| References |