Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What forum/category can address Oracle ERP questions?

ToolTimeTaborJun 6 2022 — edited Jun 6 2022

What I need is the schema containing AOP related projections and actuals?
My user community refers to "static" and "dynamic" AOP data, where static data is generally the forecasted estimate and dynamic are the actual values.
We are doing some logistics work that involves estimating costs. Specifically, there are some default "railcar" cost estimates built-into our Annual Operating Plan...somewhere.
So, someone loads up the "estimated cost per railcar" into the AOP static data for estimating purposes. Then, as actual invoices come in, someone updates the "actual cost per railcar" for a given transaction into the AOP dynamic data.
Here is a sample of how they use it. Straight forward, set the planned value and contrast it to the actual value for the month. The key is, somewhere, it is planned.
image.png

Ideas?

Comments
Post Details
Added on Jun 6 2022
2 comments
118 views