Planning Detail Report Is Not Providing Correct Results - Values in Wrong Buckets (Doc ID 2145850.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, User Interface

ACTUAL BEHAVIOR
---------------
Planning Detail Report is not providing correct results

Planning details report is not calculating Projected Available Balance and Projected OnHand is not being calculated properly.

HP shows
4-May-2016
Gross Req = 10462
Purchase Order = 5600
planned order = 1045
Beginning On hand = 4026
PAB = 5600+1045+4026 -10462 =209

Report shows
Schedule Ingredient 10462
Total Demand 10462
PO Receipts 5600
Schedule Production 1045
Total Supply 6645
Starting On-Hand 4026
Projected Available Balance 195 --> This is expected to be 209

Report Supply Demand Qty matches to HP but the PAB and Projected On-hand do not match.

EXPECTED BEHAVIOR
-----------------------
Report should show data as per the HP data.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run plan.
2. Run Planning Detail Report.
3. Match HP to Planning Detail Report.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot See the correct data on report.

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