Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 247 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need Table mapping between oracle EBS and Fusion
We have found that below tables are accountable for W_PRODUCT_LOT_XACT_FS in Oracle 11g . Can you provide corresponding Oracle fusion table names?
MTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_LOT_NUMBERSMTL_SYSTEM_ITEMS_BMTL_PARAMETERSGL_LEDGERSHR_ORGANIZATION_INFORMATIONGME_BATCH_HEADERWIP_ENTITIESRCV_TRANSACTIONSPO_HEADERS_ALLPO_LINES_ALLGMF_FISCAL_POLICIESGMF_TRANSACTION_VALUATIONOE_ORDER_LINES_ALLOE_ORDER_HEADERS_ALLOE_TRANSACTION_TYPES_TLMTL_SALES_ORDERSFND_LANGUAGES
Answers
-
Hi @Dibakar Nayak,
Welcome to the Oracle Analytics Community!
Please note the table (W_PRODUCT_LOT_XACT_FS) you mentioned is a data warehouse table which normally belongs to OLAP schema.
You will not be able to get the exact replica of the same table in Fusion Transactional database (OLTP schema).
Hope this help.
Thank you.
0
