Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 21 Oracle Analytics Lounge
- 251 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
add invoice life cycle details to OTBI analysis?
Is it possible to add the Order Life Cycle details to an OTBI analysis?
We have created OTBI analysis using subject area "Procurement - Purchasing Real Time".
Now we want to add data to this analysis that shows the details of the Order Life Cycle. How much was Ordered, Shipped, Received, Delivered, Invoiced. (Invoiced is the primary one we want.)
How can this be done?
Answers
-
i have the same need. Is there a solution to this?
0 -
OTBI is subject-area driven, not transaction-flow driven. Each subject area is built on a specific business object.
- “Order Life Cycle” spans multiple Fusion modules:
- Purchasing
- Receiving
- Inventory / Shipping
- Payables (Invoicing)
So a single subject area will never show the full lifecycle.
Most likely you need to use following SAs to fulfill your requirement
Ordered
Procurement – Purchasing Real Time
Received
Procurement – Requisitions Real Time
Delivered
Inventory – Inventory Transactions Real Time
Invoiced
Payables Invoices -Transactions Real Time
0 - “Order Life Cycle” spans multiple Fusion modules:
-
High level design for your need…
- Create separate analyses, each using the above subject areas.
- Use common keys:
- PO Number
- PO Line Number
- Supplier
- Place them on one OTBI dashboard. Add a dashboard prompt on PO Number. Hope it helps!
0
