ASCP Horizontal Plan Errors ORA-06502 When Running A 10 year (120 Period Aggregation) or more plan
(Doc ID 1990460.1)
Last updated on NOVEMBER 08, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 to 184.108.40.206.2 [Release 12.1]
Information in this document applies to any platform.
Users are on 12.1.3 and have applied VCP 220.127.116.11 Patch 14247039
When attempting to open the horizontal plan its showing error
Error populating horizontal plan dates: ORA-06502: PL.SQL:
numeric or value error.
Please note user is running 0 day/0 week/120 period plan. Calendars are well beyond the plan horizon. Support reproduced this problem in internal 18.104.22.168 instance by just running an ASCP plan for 120 periods. The plan is successful and we can access the base workbench without problem. The problem is only when trying to open the horizontal plan
Customer requires 120 period bucket to view general 10 year plan with upper management. Currently a 4 or 5 year plan horizon does not seem to have this problem
The issue can be reproduced at will with the following steps:
1. Responsibility : Advanced supply chain planning
2. Navigation : Supply chain planning > Workbench > open horizontal plan
3. error in opening horziontal plan
4. The plan is for 120 periods, no days/no weeks
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