My Oracle Support Banner

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.


On : 12.2.5 version, User Interface

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
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.

Report should show data as per the HP data.

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.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.