My Oracle Support Banner

How to Recreate Missing Purchase Order PO Data in ZX_LINES_DET_FACTORS (Doc ID 2532388.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Purchasing - Version 12.1.2 and later
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


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