'WIP_DEKITPROC_PRIV.PROCESS_DEKIT_ASSYSERIAL' Must Be Declared Error While Generating WIPDJMDF.fmx.

(Doc ID 2397450.1)

Last updated on MAY 20, 2018

Applies to:

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

Symptoms

While applying patch for 12.1 Work In Process, like <patch:22780215:R12.WIP.B>, WIPDJMDF.fmx is not generated.

ERROR

Adpatch Worker log shows following error;

Compiling package body WIPSERAS_ROW_TRIGGERS...
Compilation error on package body WIPSERAS_ROW_TRIGGERS:
PL/SQL ERROR 201 at line 91, column 1
identifier 'WIP_DEKITPROC_PRIV.PROCESS_DEKIT_ASSYSERIAL' must be declared
PL/SQL ERROR 0 at line 91, column 1
Statement ignored
PL/SQL ERROR 201 at line 149, column 1
identifier 'WIP_DEKITPROC_PRIV.PROCESS_DISASSOCIATE_SERIAL' must be declared
PL/SQL ERROR 0 at line 149, column 1


STEPS
The issue can be reproduced at will with the following steps:

  1. Apply <patch:22780215:R12.WIP.B>.
  2. Review a log file for adpatch and its worker.

 

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