POXDOAPP: When Submitting a Purchase Order for Approval: APP-PO-14142: WF_Error-000: ORA-0000 Normal (Doc ID 1908050.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
POXDOAPP.fmb
PO_REQAPPROVAL_INIT
POXWPA1B.pls
POXAPAPC.pll

Symptoms

When submitting a Purchase Order for approval the following error occurs:

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


SYMPTOMS:
-------------
RDBMS version is 11.2.0.3, but the issue from RDBMS <Note 1065020.1> is not applicable.
If Note 1065020.1 would be applicable then Forms 10.1.2.4 compilation against a 11.2 RDBMS should fail with:
PL/SQL ERROR 801 ... internal error [60603]

However, this error does not occur.
Instead, when the library file is manually compiled the following error occurs:

Compilation errors on PO_WF_APPROVE_C:
PL/SQL ERROR 306 at line 867, column 2
wrong number or types of arguments in call to 'START_WF_PROCESS'
PL/SQL ERROR 0 at line 867, column 2
Statement ignored

Failed to generate library.
FRM-30312: Failed to compile the library.

Unix command to manually compile the library file:
frmcmp_batch module=POXAPAPC.pll userid=APPS/<password> output_file=POXAPAPC.plx module_type=library batch=yes compile_all=special

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