Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 254 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 94 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How can we relate DOO_headers or with fulfill table with requisition/po/with receipt for BIP report
i need to find some connection. scm_supply_headers table is not there in the system,, What other tables i can use for connectivity. also source_document_id is not there in doo_fulfill_lines table to connect with po_header.
Answers
-
Hi Sophiya,
I request you to search this topic on cloudcustomer connect to check if there is something available already?
"doo_fulfill_lines" - Cloud Customer Connect
Thanks.
0 -
@Sophiya , thanks for your question. Appreciate if you can provide additional details since there is no table like scm_supply_headers in fusion. You might be able to find below details useful for you case…
DOO_HEADERS_ALL
DOO orchestration headers
High-level orchestration of fulfillment
DOO_LINES_ALL
DOO orchestration lines
Links to the actual shipment/fulfillment lines
DOO_FULFILL_LINES
Fulfillment details per DOO line
Contains scheduled qty, shipped qty, etc.
PO_HEADERS_ALL
Purchase orders
Standard PO header table
PO_LINES_ALL
PO line details
Can link to requisitions via REQ_LINE_ID
0 -
Also, I would also suggest reviewing or posting the question in Order Management — Cloud Customer Connect
It will be easy for someone from DOO team to review this requirement and answer it accordingly. thanks
0
