Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need Table mapping between oracle EBS and Fusion

Received Response
8
Views
2
Comments
Dibakar Nayak
Dibakar Nayak Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/27662/need-table-mapping-between-oracle-ebs-and-fusion

    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.

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    It is not going to be exact replica with, but you can look at folloing tables:

    INV_MATERIAL_TXNS and INV_TRANSACTION_LOT_NUMBERS

    INV_MATERIAL_TXNS stores a record of every material transaction or cost update performed in Inventory. . . . Records are inserted into this table either through the transaction processor or by the standard cost update program. The columns TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID and TRANSACTION_SOURCE_NAME describe what the transaction is and against what entity it was performed. . . . If the item is under lot control then the lot records are stored in INV_TRANSACTION_LOT_NUMBERS, joined by the column TRANSACTION_ID. If the item is under serial control then the serial records are stored in INV_UNIT_TRANSACTIONS, joined by the column TRANSACTION_ID. The Item revision and locator control are stored in the columns REVISION and LOCATOR_ID respectively. . . . Transfer transactions are represented as two single records in the table. They are related through the column TRANSFER_TRANSACTION_ID, which contains the TRANSACTION_ID of the other transaction in the transfer. . . . . . . . . The index INV_MATERIAL_TXNS_UPGD is used only during install and upgrade, and will be dropped during the course thereof, but is included here for completeness.

    INV_TRANSACTION_LOT_NUMBERS stores lot number information for transactions in the INV_MATERIAL_TXNS table. . . . TRANSACTION_ID joins to INV_MATERIAL_TXNS.TRANSACTION_ID. SERIAL_TRANSACTION_ID joins to INV_UNIT_TRANSACTIONS.TRANSACTION_ID when also under serial control. . . .

    Hope it helps!