Patch 12695646 Failed On Job Mrpplan.odf (Doc ID 2054248.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Patch 12695646 failed on job mrpplan.odf

When we apply the patch 12695646:R12.SCP_PF.B we have the following error on the job mrpplan.odf:


ERROR
-----------------------
ERROR:

SELECT ROWID FROM MRP.MRP_PLANS WHERE CURR_CONSIDER_WIP is null

The update statement is:
UPDATE MRP.MRP_PLANS SET CURR_CONSIDER_WIP = (select decode(ignore_wip, 1,
 2, 2, 1, -1) from mrp_parameters where organization_id =
 mrp_plans.organization_id ) WHERE ROWID = :selrid
  
AD Worker error:
The following ORACLE error:

ORA-00904: "IGNORE_WIP": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 12695646
2. Note the error mentioned above

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