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.
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:
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
The issue can be reproduced at will with the following steps:
1. Apply Patch 12695646
2. Note the error mentioned above
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|