About DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE

an_dario

Summary

About DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE

Content

Hi everyone!

Where can I find information about the DOO_CROSS_REFERENCE object and its GETFULFILLMENTVALUE function?

Any help will be extremely valious!

Thanks!

Alex111

Hi from the future! Searching for the same...

Gianni Ceresa

@Alex111 ,

What product (full name and version) is this about?

I suspect it's posted in the wrong category (and this is an abandoned thread by the author 6 years ago).

Based on your reply, the post can be moved or we could point you to the right forum.

Alex111

Hi @Gianni Ceresa , thanks for reply.

I'm trying to build a query linking a supplier with OM order and spent some hard time trying to find the relevant tables.

This is/was the problem:

There is a link in the table DOO_FULFILL_LINES_ALL to SUPPLIERS_ID and this does not match to neither VENDOR_ID not even SEGMENT1. I've tried the view DOO_FULFILL_LINES_ALL_V and there SUPPLIER_ID had a key to POZ_SUPPLIERS which was then referring to HZ_PARTIES. All good, but it took quite a bit of time trying and searching. I then went to DOO_FULFILL_LINES_ALL_V's query in hope to solve the riddle 'if not for POZ_SUPPLIERS what kind of data is kept in SUPPLIER_ID in table?' and saw this: DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('SUPPLIER_ID', 'SUPPLIERS', DFLA.SUPPLIER_ID) SUPPLIER_ID.

So basically, no issue now, but I would appreciate for any hints of how to deal with these situations in future rather than 'let's try everything', maybe there is some document or suggested approach. As I can see reading the code of GETFULFILLMENTVALUE is not an option, maybe there is something like ETRM or note in Support. I think the author of the note had the same problem.

Gianni Ceresa

So .... is this Fusion?

If you are using Fusion Analytics Warehouse (now called Fusion Data Intelligence Platform), which one of these is your question about? ERP, SCM, HCM, CX (these are categories in this forum where the question can be moved)

If you aren't using Fusion Analytics Warehouse, then you should ask in the Fusion forum because your question is about Fusion data (and not about a technical feature of the analytical platform). The fusion forum is a parallel community to this one but content can't be moved there and so you will have to post again (have a look at the available categories and pick the best one): https://community.oracle.com/customerconnect

Alex111

Ah, ok, thanks, I just found this post via Google when searching for keywords