My Oracle Support Banner

After Upgrade 11.5.10. To 12.1/12.2 Cannot Save Purchase Order (or Autocreate) Due To Error APP-PO-14142: on_insert-002: ORA-0000: normal, successfully completion. (Doc ID 2702164.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


Using Purchasing, Version 12.1/12.2

Upon upgrading - its not possible to save the purchase order

Error is encountered, and its not expected.

APP-PO-14142: On_insert-002: ORA-0000.

The issue can be reproduced at will with the following steps:
1. Create the purchase order
2. Save
3. Error occurs

FND Logging:

po.plsql.PO_CORE_S.IS_ENCUMBRANCE_ON.900 l_enc_on = TRUE
po.plsql.PO_CORE_S.IS_ENCUMBRANCE_ON.END End of subprogram.
po.plsql.PO_RETROACTIVE_PRICING_PVT.Is_Retro_Project_Allowed.000. Project Check
po.plsql.PO_RETROACTIVE_PRICING_PVT.Is_Retro_Project_Allowed.000. Price Change on std PO :N
po.plsql.PO_RETROACTIVE_PRICING_PVT.Is_Retro_Project_Allowed.000. Project 11i10 Enabled
per.resource.HRKPI.hr_kpi_extlib.event begin
per.resource.HRKPI.hr_kpi_extlib.event #event_name#POST-INSERT*formname*POXPOEPO
per.resource.HRKPI.hr_kpi_extlib.event end
po.plsql.po_message_s.on_insert.002.EXCEPTION ;SQLERRM = ORA-0000: normal, successful completion


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

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