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.
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
