PO / Requisition Approval: APP-PO-14142: WF_Error-000: ORA-0000 normal, successful completion (Doc ID 1440432.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

This article is intended for standard approval workflow, not client's using the Approval Management Engine (AME).

When attempting to approve purchase orders and requisitions for approval the following error occurs:

APP-PO-14142: WF_Error-000: ORA-0000 normal, successful completion

Cause: A SQL error has occurred in WF_Error.
The SQL error is ORA:0000: normal, successful completion.

Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance

The issue can be reproduced at will with the following steps:
1. Using a purchasing responsibility navigate to Purchase Orders > Purchase orders.
2. When attempting to approve purchase orders the above mentioned error occurs.

Research done:
- Checked for invalid PO objects as per <Note: 738266.1>.
- Checked that the field "Approval Transaction Type" (to use AME) is not populated as per <Note: 470204.1>
- Manually compiled POXAPAPC.pll as per <Note: 1371354.1> by using the following command, which returned no error:

frmcmp_batch module=POXAPAPC.pll userid=APPS/<password> output_file=POXAPAPC.plx module_type=library batch=yes compile_all=special

- Following <Note: 1288641.1> using adadmin the following steps were executed:

  1. Generate Applications Files menu
  2. Generate form files

After doing so, the following Oracle Forms objects did not generate successfully:

au resource HR_SPEC.pll
au resource POXAPAPC.pll
au resource POXPOEPO.pll
au resource PERWSEMA.pll
au resource POXDOCON.pll
au resource POXCOMSG.pll
au resource POXPOREL.pll
au resource POXRQDIS.pll
au resource POXRQLNS.pll
ar forms/AR ARXTWMAI.fmx
ap forms/AR APXINWKB.fmx
per forms/AR PERWSEMP.fmx
po forms/AR POXPOERL.fmx
po forms/AR POXDOFDO.fmx
ap forms/US APXINWKB.fmx
ar forms/US ARXTWMAI.fmx
per forms/US PERWSEMP.fmx
po forms/US POXDOFDO.fmx
po forms/US POXPOERL.fmx


When checking the worker logs it shows the following errors:

Compilation errors on PO_UNRESERVE_C:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 121, column 9
Statement ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 361, column 5
Statement ignored


Compilation errors on PO_ENCUMBRANCE_MENU_C:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 250, column 1
Statement ignored


Compilation errors on PO_APPROVE_RESERVE:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 843, column 13
Statement ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 852, column 13
Statement ignored


Compilation errors on PO_APPROVE_C8:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 96, column 3
Statement ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 113, column 5
Statement ignored


Compilation errors on PO_APPROVE_C3_2:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 105, column 5
Statement ignored


Compilation errors on PO_APPROVE_C3:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 417, column 5
Statement ignored


Compilation errors on PO_APPROVE_C2:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 220, column 9
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms