Home » Applications » Oracle Fusion Apps & E-Business Suite » roll-over forecast in Oracle
roll-over forecast in Oracle [message #502639] Thu, 07 April 2011 14:31 Go to next message
rtheis
Messages: 2
Registered: April 2011
Junior Member
Say we have a 12 week time period. The forecast is for a demand of 100 units per week for the full 12 weeks, which equates to a total demand of 1200 units.
We use oracle as our software program.
Say our customer orders 100 units in week 1, 100 in week 2, 100 in week 3, 50 in week 4, 0 units in week 5, 0 in week 6, 0 in week 7, 0 in week 8, and then places an order for 550 units in week 9 (50 from week 4, the 100 units from week 5,6,7,8 and the 100 units they would normally consume in week 9).

The dilemma is that because only 50 units of the forecast was consumed in week 4, and 0 units were consumed in weeks, 5,6,7, and 8, our oracle system does not roll over the missing forecasted demand and drops to zero for those weeks. Oracle still only plans for the original 100 units of forecast a week. We are now 450 units short for our customer because Oracle did not roll over the "missing" demand.

Is there a step or tool we can use in Oracle to prevent the forecast from dropping to zero and continue rolling over the "unconsumed" forecast so that when the customer does place the "big" order for the units they should have purchased, we are not caught with a pants down?

I would assume we are not the only company with this issue and there is a away to circumvent the problem.

Any help would be appreciated.
Re: roll-over forecast in Oracle [message #502640 is a reply to message #502639] Thu, 07 April 2011 14:41 Go to previous messageGo to next message
ThomasG
Messages: 3089
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
What "oracle software program" are you talking about? Oracle the the RDBMS has no such built-in logic, it only executes the SQL or PL/SQL that you tell it to execute.
Re: roll-over forecast in Oracle [message #502641 is a reply to message #502640] Thu, 07 April 2011 14:49 Go to previous message
rtheis
Messages: 2
Registered: April 2011
Junior Member
11.5.10.2 Oracle e-business suite
Previous Topic: Issue in Oracle application testing suite
Next Topic: How to send custom PO report to supplier while approving
Goto Forum:
  


Current Time: Wed Jul 30 12:46:37 CDT 2014

Total time taken to generate the page: 0.11846 seconds