What are some practical mapping strategies that can be used to map EBS tables with Fusion PVOs? Please advise if anyone has worked on this activity before.
H @Usha Athimakula
Are there specific tables you are looking for. Just asked the question on chat GPT and it came up with this
EBS Table
Fusion Table
Fusion PVO (BICC/Extract)
MTL_SYSTEM_ITEMS_B
EGP_SYSTEM_ITEMS_B
ItemExtractPVO
MTL_ITEM_CATEGORIES
EGP_ITEM_CATEGORIES_B
ItemCategoryExtractPVO
MTL_PARAMETERS
INV_ORG_PARAMETERS
InventoryOrganizationExtractPVO
MTL_MATERIAL_TRANSACTIONS
INV_MATERIAL_TXNS
InventoryTransactionExtractPVO
MTL_TRANSACTION_LOT_NUMBERS
INV_TRANSACTION_LOT_NUMBERS
InventoryLotTransactionExtractPVO
MTL_ONHAND_QUANTITIES
INV_ONHAND_QUANTITIES_DETAIL
OnHandQuantityExtractPVO
PO_HEADERS_ALL
PurchasingDocumentHeaderExtractPVO
PO_LINES_ALL
PurchasingDocumentLineExtractPVO
PO_DISTRIBUTIONS_ALL
PurchasingDistributionExtractPVO
RCV_TRANSACTIONS
ReceivingTransactionExtractPVO
AP_INVOICES_ALL
PayablesInvoiceExtractPVO
AP_INVOICE_DISTRIBUTIONS_ALL
PayablesInvoiceDistributionExtractPVO
AP_CHECKS_ALL
PaymentExtractPVO
GL_LEDGERS
LedgerExtractPVO
GL_CODE_COMBINATIONS
CodeCombinationExtractPVO
GL_JE_HEADERS
JournalHeaderExtractPVO
GL_JE_LINES
JournalLineExtractPVO
HZ_PARTIES
PartyExtractPVO
HZ_CUST_ACCOUNTS
CustomerAccountExtractPVO
RA_CUSTOMER_TRX_ALL
ReceivablesTransactionExtractPVO
OE_ORDER_HEADERS_ALL
DOO_HEADERS_ALL
SalesOrderHeaderExtractPVO
OE_ORDER_LINES_ALL
DOO_LINES_ALL
SalesOrderLineExtractPVO
WIP_ENTITIES
WIE_WORK_ORDERS_B
WorkOrderExtractPVO
GME_BATCH_HEADER
ProcessManufacturingBatchExtractPVO
@Usha Athimakula , Mapping Oracle EBS tables to Fusion Public View Objects (PVOs) is one of the trickiest parts of coexistence and FDI/BICC-based integrations because there is no 1:1 universal mapping layer. In practice, successful implementations rely on various people's research and experience rather than trying to find “perfect equivalence.” Oracle also does not publish anything because EBS being on-prem offering would have so much customization that there is no certain way for Oracle to come up with one universal doc.
Fusion PVOs are pre-joined, abstraction-layer views, not table equivalents. Many EBS tables collapse into a single PVO or vice versa. I would suggest looking at the object level e.g. AP_INVOICES_ALL in EBS is same as fusion business object: Payables Invoice which is PayablesInvoiceExtractPVO.
Hope it helps!
@Usha Athimakula , I agree if it will be really helpful for everyone so I guess we can keep checking with Oracle product team and hopefully will get something out of the box. In the meantime, you can get started with something like this and correct/modify it accordingly
EBS Table Structures
Fusion Core Business Object
Primary Fusion PVO (BICC Extract)
Payables Invoice
FscmTopModelAM.FinApInvTransactionsAM.InvoiceExtractPVO
AP_INVOICE_LINES_ALL
AP_TERMS_TL
Purchase Order
FscmTopModelAM.PoTopModelAM.PurchaseOrderExtractAM.HeaderExtractPVO
PO_LINE_LOCATIONS_ALL
Receivables Invoice
FscmTopModelAM.FinArTrxTopModelAM.TransactionHeaderExtractPVO
RA_CUSTOMER_TRX_LINES_ALL
Hi Usha,
There is no standard documentation available for this.
Thanks.
@Daniel Ryan Thank you for taking the time and answering! We are upgrading to Fusion from EBS and would require this for all modules - OM, AP, AR, GL, SCM etc.
@Usha Athimakula
Maybe this is something your data migration team could help with?
Thank you @RVohra for the reply. We understand the customization part. Having this mapping for the standard tables and columns would help us to an extent
We are working with OCS for data migrations/conversions. They use FBDI to migrate EBS data and do not have a direct EBS to Fusion table mapping. Reconciliations and validations are being a challenge.
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
