About DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE
Hi everyone!
Where can I find information about the DOO_CROSS_REFERENCE object and its GETFULFILLMENTVALUE function?
Any help will be extremely valious!
Thanks!
Hi from the future! Searching for the same...
@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.
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.
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
Ah, ok, thanks, I just found this post via Google when searching for keywords
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
