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.
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
How to map FOB code from DOO_FULFILL_LINES_ALL to its text value in Sales Order UI? — Cloud Customer Connect
Thanks.
@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
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
