This content has been marked as final. Show 7 replies
I believe W_PARTY_D is the table to get supplier information..Not sure need to check.
Check in Lineage or Data model ref.
Edited by: Srini VEERAVALLI on Feb 12, 2013 10:37 AM
I do see W_SUPPLIER_D referenced in that table multiple times in the "Oracle Business Analytics Wrehouse Data Model Reference Version 22.214.171.124" pdf. Looks to me like supplier data should be in this table?
I didnt find any Datamodel ref. for this table but the same table was referred for other tables.
More over I didnt find any task with Target table W_SUPPLIER_D.
Its better to check with Oracle.
If helps pls mark :)
I see mappings for it that aren't being being assembled.
Then that might be using as part of another workflow and the same was not mentioned in the dac.1 person found this helpful
Using Infa Designer see the dependencies that would help you to know the workflow name.
If helps mark
Yes, W_PARTY_D will have the supplier Data. You can easily check this in the DMR:
Business Name: Party Dimension
Party Dimension includes all parties include B2B Customer and B2C Customer,
Contact, Supplier data
W_SUPPLIER_D does not even exist in the 7963 DMR..which indicates its not being used. Oracle may have a DMR addendum that shows these officical changes but this is a acceptable assumption.
Pls mark correct or helpful