We are doing gap analysis on out of the box ETL to determine our direction to handle custom EBS modifications and I noticed that W_SUPPLIER_D table is marked "inactive" in DAC.
Is it supposed to be inactive in 184.108.40.206? Change from 220.127.116.11?
I do see W_SUPPLIER_D referenced in that table multiple times in the "Oracle Business Analytics Wrehouse Data Model Reference Version 18.104.22.168" 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 :)
Then that might be using as part of another workflow and the same was not mentioned in the dac.
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