Purchase Orders & Intransit Shipments Not Picked Up In Rapid Plan (Doc ID 2087672.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Rapid Planning - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

12.2.3 only
engine.zip 120.134.12020000.109
MSCNPL64.ppc 120.11.12020000.6

PROBLEM
-------------
Running Rapid planning
64 bit snapshot is not snapshotting the PO supplies
See in engine log the following error
invalid line nnn in MSLD_PURCH_SUPPLY: # of fields is 36 but supposed to be 38
-- message appears over 600 times - seems to happen for each PO
-- see file rpengine7075.log

Turn off 64 bit snapshot and we get purchase supplies back in the plan output
and no error message in the log - just see MSLD_PURCH_SUPPLY :: Time in MS : 16 :: Memory usage in MB: 0
see file - rpengine7085.log

TEST FIX PROVIDED
-----------------------------
Since they were on MSCNPL64.ppc 120.11.12020000.6
I gave them latest snapshot EXE for that level from patch 21289784 and had them copy the EXE to the system to see if that would fix the issue.
It did not help - they updated:
We deployed the file and tested on Dev instance. Unfortunately it did not solve the problem. The purchase orders were still not considered in the plan.
Uploading the engine log file. The plan id is 7021 and it will be the latest run in the log starting around 11.15 AM - see file rpengine7085_1204_Action_Plan.log

STEPS
--------
run plan with and without 64 bit snapshot and observe results.


BUSINESS IMPACT
----------------------
We must use 64 bit snapshot in PROD or we get error due to high volume of sales orders

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