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 laterInformation in this document applies to any platform.
Symptoms
Using Purchasing, Version 12.1/12.2
Actual:
Upon upgrading - its not possible to save the purchase order
Expected:
Error is encountered, and its not expected.
Error:
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
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 |