Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to build an inventory analysis coupled with time constrained measure? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to build an inventory analysis coupled with time constrained measure?

9
Views
0
Comments
edited Mar 18, 2020 7:37PM in General Transactional Reporting (OTBI)

Summary

An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measured has been added.

Content

Hello Oracle Community,

I am trying to create an analysis showing both inventory-on-hand and outstanding-work-order (Open Quantity) quantities, but the analysis kept running for 15mins without producing any results.  I had to stop the refresh process.  Would you know the suitable codes to produce the results needed?

So far I had successfully built and ran the inventory-on-hand portion of the analysis.  Then I try to add and modify the "Open Quantity" ("Manufacturing - Actual Production Real Time"."Actual Production"."Open Quantity") fact with the following code to try to display work-order-quantities that are outstanding for each SKU.  However the analysis keeps loading without producing a result, and I had to stop the refresh process after it has been running for 15mins:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!