Wednesday, 1 July 2026

Core tables of Fusion & EBS

 Containing the mapping of core tables between Oracle EBS and Oracle Fusion. 
These are basic tables 

ModuleOracle EBS TableOracle Fusion TableDescription / Notes
FND & SecurityFND_USERPER_USERSSystem Users
FND & SecurityFND_RESPONSIBILITYASE_ROLE_B
Roles (Replaced Responsibilities in Fusion)
FND & SecurityFND_USER_RESP_GROUPS_DIRECTPER_USER_ROLESUser to Role assignments
FND & SecurityFND_APPLICATIONFND_APPLICATIONApplication Definitions
FND & SecurityFND_CONCURRENT_PROGRAMSESS_REQUEST_PROPERTYJobs / Programs
FND & SecurityFND_CONCURRENT_REQUESTSESS_REQUEST_HISTORYScheduled Requests
FND & SecurityFND_DESCRIPTIVE_FLEXSFND_DF_CONTEXTS_BDescriptive Flexfields (DFF)
FND & SecurityFND_ID_FLEXSFND_KF_CONTEXTS_BKey Flexfields (KFF)
FND & SecurityFND_FLEX_VALUE_SETSFND_VS_VALUE_SETSValue Sets
FND & SecurityFND_FLEX_VALUESFND_VS_VALUES_BValues inside Value Sets
FND & SecurityFND_LOOKUP_TYPESFND_LOOKUP_TYPES_BLookup Types
FND & SecurityFND_LOOKUP_VALUESFND_LOOKUP_VALUES_VLLookup Values
FND & SecurityFND_PROFILE_OPTIONSFND_PROFILE_OPTIONSProfile Options
FND & SecurityFND_PROFILE_OPTION_VALUESFND_PROFILE_OPTION_VALUESProfile Option Values
FND & SecurityHR_OPERATING_UNITSFUN_ALL_BUSINESS_UNITS_VOperating Units vs Business Units
General Ledger (GL)GL_JE_BATCHESGL_JE_BATCHESJournal Entry Batches
General Ledger (GL)GL_JE_HEADERSGL_JE_HEADERSJournal Entry Headers
General Ledger (GL)GL_JE_LINESGL_JE_LINESJournal Entry Lines
General Ledger (GL)GL_BALANCESGL_BALANCESAccount Balances
General Ledger (GL)GL_CODE_COMBINATIONSGL_CODE_COMBINATIONSChart of Accounts Combinations
General Ledger (GL)GL_LEDGERSGL_LEDGERSLedger Definitions
General Ledger (GL)GL_PERIOD_STATUSESGL_PERIOD_STATUSESPeriod Statuses
General Ledger (GL)GL_DAILY_RATESGL_DAILY_RATESCurrency Daily Rates
General Ledger (GL)GL_IMPORT_REFERENCESGL_IMPORT_REFERENCESJournal Import References
General Ledger (GL)GL_INTERFACEGL_INTERFACEJournal Import Interface
Subledger Accounting (SLA)XLA_TRANSACTION_ENTITIESXLA_TRANSACTION_ENTITIESSLA Transaction Entities
Subledger Accounting (SLA)XLA_EVENTSXLA_EVENTSSLA Events
Subledger Accounting (SLA)XLA_AE_HEADERSXLA_AE_HEADERSSLA Journal Headers
Subledger Accounting (SLA)XLA_AE_LINESXLA_AE_LINESSLA Journal Lines
Subledger Accounting (SLA)XLA_DISTRIBUTION_LINKSXLA_DISTRIBUTION_LINKSSLA Distribution Links
Payables (AP)PO_VENDORSPOZ_SUPPLIERS
Supplier Master (Shifted to TCA in Fusion)
Payables (AP)PO_VENDOR_SITES_ALLPOZ_SUPPLIER_SITES_ALL_MSupplier Sites
Payables (AP)PO_VENDOR_CONTACTSPOZ_SUPPLIER_CONTACTSSupplier Contacts
Payables (AP)AP_INVOICES_ALLAP_INVOICES_ALLInvoice Headers
Payables (AP)AP_INVOICE_LINES_ALLAP_INVOICE_LINES_ALLInvoice Lines
Payables (AP)AP_INVOICE_DISTRIBUTIONS_ALLAP_INVOICE_DISTRIBUTIONS_ALLInvoice Distributions
Payables (AP)AP_PAYMENT_SCHEDULES_ALLAP_PAYMENT_SCHEDULES_ALLPayment Schedules
Payables (AP)AP_CHECKS_ALLAP_CHECKS_ALLPayments/Checks Headers
Payables (AP)AP_INVOICE_PAYMENTS_ALLAP_INVOICE_PAYMENTS_ALLInvoice to Payment Mapping
Payables (AP)AP_TERMSAP_TERMSPayment Terms
Payables (AP)AP_HOLDS_ALLAP_HOLDS_ALLInvoice Holds
Payables (AP)AP_EXPENSE_REPORT_HEADERS_ALLEXM_EXPENSES
Expense Reports (Fusion EXM module)
Payables (AP)AP_EXPENSE_REPORT_LINES_ALLEXM_EXPENSE_DISTSExpense Report Lines
Payables (AP)AP_CREDIT_CARD_TRXNS_ALLEXM_CREDIT_CARD_TRXNSCredit Card Transactions
Payables (AP)AP_BANK_ACCOUNTS_ALLCE_BANK_ACCOUNTSInternal Bank Accounts
Receivables (AR) & TCAHZ_PARTIESHZ_PARTIESParty Master
Receivables (AR) & TCAHZ_PERSON_PROFILESHZ_PERSON_PROFILESPerson Profiles
Receivables (AR) & TCAHZ_ORGANIZATION_PROFILESHZ_ORGANIZATION_PROFILESOrganization Profiles
Receivables (AR) & TCAHZ_LOCATIONSHZ_LOCATIONSParty Addresses
Receivables (AR) & TCAHZ_PARTY_SITESHZ_PARTY_SITESParty Sites
Receivables (AR) & TCAHZ_CONTACT_POINTSHZ_CONTACT_POINTSContact Points (Phone/Email)
Receivables (AR) & TCAHZ_RELATIONSHIPSHZ_RELATIONSHIPSParty Relationships
Receivables (AR) & TCAHZ_CUST_ACCOUNTSHZ_CUST_ACCOUNTSCustomer Accounts
Receivables (AR) & TCAHZ_CUST_ACCT_SITES_ALLHZ_CUST_ACCT_SITES_ALLCustomer Account Sites
Receivables (AR) & TCAHZ_CUST_SITE_USES_ALLHZ_CUST_SITE_USES_ALLCustomer Site Uses (Bill To/Ship To)
Receivables (AR) & TCARA_CUSTOMER_TRX_ALLRA_CUSTOMER_TRX_ALLTransaction/Invoice Headers
Receivables (AR) & TCARA_CUSTOMER_TRX_LINES_ALLRA_CUSTOMER_TRX_LINES_ALLTransaction Lines
Receivables (AR) & TCARA_CUST_TRX_LINE_GL_DIST_ALLRA_CUST_TRX_LINE_GL_DIST_ALLTransaction GL Distributions
Receivables (AR) & TCAAR_PAYMENT_SCHEDULES_ALLAR_PAYMENT_SCHEDULES_ALLTransaction Payment Schedules
Receivables (AR) & TCAAR_CASH_RECEIPTS_ALLAR_CASH_RECEIPTS_ALLCash Receipts Headers
Receivables (AR) & TCAAR_RECEIVABLE_APPLICATIONS_ALLAR_RECEIVABLE_APPLICATIONS_ALLReceipt Applications
Receivables (AR) & TCAAR_CASH_RECEIPT_HISTORY_ALLAR_CASH_RECEIPT_HISTORY_ALLReceipt History
Receivables (AR) & TCAAR_ADJUSTMENTS_ALLAR_ADJUSTMENTS_ALLTransaction Adjustments
Receivables (AR) & TCARA_BATCHES_ALLRA_BATCHES_ALLTransaction Batches
Receivables (AR) & TCAAR_DISTRIBUTIONS_ALLAR_DISTRIBUTIONS_ALLAR Distributions
Purchasing (PO)PO_HEADERS_ALLPO_HEADERS_ALLPurchase Order Headers
Purchasing (PO)PO_LINES_ALLPO_LINES_ALLPurchase Order Lines
Purchasing (PO)PO_LINE_LOCATIONS_ALLPO_LINE_LOCATIONS_ALLPurchase Order Shipments
Purchasing (PO)PO_DISTRIBUTIONS_ALLPO_DISTRIBUTIONS_ALLPurchase Order Distributions
Purchasing (PO)PO_RELEASES_ALLN/A (Replaced by BPA in Fusion)Blanket PO Releases (EBS Only)
Purchasing (PO)PO_REQUISITION_HEADERS_ALLPOR_REQUISITION_HEADERS_ALLRequisition Headers
Purchasing (PO)PO_REQUISITION_LINES_ALLPOR_REQUISITION_LINES_ALLRequisition Lines
Purchasing (PO)PO_REQ_DISTRIBUTIONS_ALLPOR_REQ_DISTRIBUTIONS_ALLRequisition Distributions
Purchasing (PO)RCV_SHIPMENT_HEADERSRCV_SHIPMENT_HEADERSReceiving Shipment Headers
Purchasing (PO)RCV_SHIPMENT_LINESRCV_SHIPMENT_LINESReceiving Shipment Lines
Purchasing (PO)RCV_TRANSACTIONSRCV_TRANSACTIONSReceiving Transactions
Purchasing (PO)PO_ACTION_HISTORYPO_ACTION_HISTORYApproval Action History
Purchasing (PO)PO_AGENTSPO_AGENTSBuyers
Purchasing (PO)PO_APPROVED_SUPPLIER_LISTPO_APPROVED_SUPPLIER_LISTApproved Supplier List
Purchasing (PO)PO_ASL_DOCUMENTSPO_ASL_DOCUMENTSASL Documents
Inventory (INV) / PIMMTL_SYSTEM_ITEMS_BEGP_SYSTEM_ITEMS_BItem Master (Fusion PIM)
Inventory (INV) / PIMMTL_ITEM_CATEGORIESEGP_ITEM_CATEGORIESItem Categories
Inventory (INV) / PIMMTL_CATEGORIES_BEGP_CATEGORIES_BCategory Definitions
Inventory (INV) / PIMMTL_CATEGORY_SETS_BEGP_CATEGORY_SETS_BCategory Sets
Inventory (INV) / PIMMTL_PARAMETERSINV_ORG_PARAMETERSInventory Organization Parameters
Inventory (INV) / PIMMTL_MATERIAL_TRANSACTIONSINV_MATERIAL_TXNSMaterial Transactions
Inventory (INV) / PIMMTL_TRANSACTION_REASONSINV_TRANSACTION_REASONSTransaction Reasons
Inventory (INV) / PIMMTL_ONHAND_QUANTITIES_DETAILINV_ONHAND_QUANTITIES_DETAILOn-hand Inventory Quantities
Inventory (INV) / PIMMTL_SECONDARY_INVENTORIESINV_SECONDARY_INVENTORIESSubinventories
Inventory (INV) / PIMMTL_ITEM_LOCATIONSINV_ITEM_LOCATIONSSubinventory Locators
Inventory (INV) / PIMMTL_LOT_NUMBERSINV_LOT_NUMBERSLot Numbers
Inventory (INV) / PIMMTL_SERIAL_NUMBERSINV_SERIAL_NUMBERSSerial Numbers
Inventory (INV) / PIMMTL_TXN_REQUEST_HEADERSINV_TXN_REQUEST_HEADERSMove Order Headers
Inventory (INV) / PIMMTL_TXN_REQUEST_LINESINV_TXN_REQUEST_LINESMove Order Lines
Inventory (INV) / PIMMTL_PHYSICAL_INVENTORIESINV_PHYSICAL_INVENTORIESPhysical Inventories
Inventory (INV) / PIMMTL_PHYSICAL_ADJUSTMENTSINV_PHYSICAL_ADJUSTMENTSPhysical Inventory Adjustments
Inventory (INV) / PIMMTL_CYCLE_COUNT_HEADERSINV_CYCLE_COUNT_HEADERSCycle Count Headers
Inventory (INV) / PIMMTL_CYCLE_COUNT_ENTRIESINV_CYCLE_COUNT_ENTRIESCycle Count Entries
Inventory (INV) / PIMORG_ORGANIZATION_DEFINITIONSINV_ORG_PARAMETERSOrg Definitions
Inventory (INV) / PIMCST_ITEM_COSTSCST_COSTSItem Costs
Order Management (OM) & ShipOE_ORDER_HEADERS_ALLDOO_HEADERS_ALLOrder Headers (Fusion DOO)
Order Management (OM) & ShipOE_ORDER_LINES_ALLDOO_LINES_ALLOrder Lines
Order Management (OM) & ShipOE_TRANSACTION_TYPES_ALLDOO_ORDER_TYPES_BOrder Types
Order Management (OM) & ShipOE_ORDER_HOLDS_ALLDOO_HOLDSOrder Holds
Order Management (OM) & ShipOE_PRICE_ADJUSTMENTSDOO_CHARGE_LINESPrice Adjustments / Charges
Order Management (OM) & ShipWSH_DELIVERY_DETAILSWSH_DELIVERY_DETAILSShipping Delivery Details
Order Management (OM) & ShipWSH_NEW_DELIVERIESWSH_NEW_DELIVERIESShipping Deliveries
Order Management (OM) & ShipWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_ASSIGNMENTSDelivery Assignments
Order Management (OM) & ShipWSH_TRIPSWSH_TRIPSShipping Trips
Order Management (OM) & ShipWSH_TRIP_STOPSWSH_TRIP_STOPSTrip Stops
Order Management (OM) & ShipQP_LIST_HEADERS_BQP_PRICE_LISTS_BPrice List Headers
Order Management (OM) & ShipQP_LIST_LINESQP_PRICE_LIST_ITEMSPrice List Lines
Order Management (OM) & ShipQP_PRICING_ATTRIBUTESQP_PRICING_ATTRIBUTESPricing Attributes
Order Management (OM) & ShipWSH_DOCUMENT_INSTANCESWSH_DOCUMENT_INSTANCESShipping Documents
Order Management (OM) & ShipOE_SYSTEM_PARAMETERS_ALLDOO_SYSTEM_PARAMETERSOM System Parameters
Order Management (OM) & ShipOE_DROP_SHIP_SOURCESDOO_DROP_SHIP_SOURCESDrop Ship Sources
Order Management (OM) & ShipOE_BLANKET_HEADERS_ALLDOO_BLANKET_HEADERSSales Agreements
Order Management (OM) & ShipOE_BLANKET_LINES_ALLDOO_BLANKET_LINESSales Agreement Lines
Order Management (OM) & ShipWSH_EXCEPTIONSWSH_EXCEPTIONSShipping Exceptions
Order Management (OM) & ShipWSH_PICK_SLIP_RULESWSH_PICK_SLIP_RULESPick Slip Rules
HCMPER_ALL_PEOPLE_FPER_ALL_PEOPLE_FPerson Details
HCMPER_PERSON_NAMES_FPER_PERSON_NAMES_FPerson Names
HCMPER_ALL_ASSIGNMENTS_FPER_ALL_ASSIGNMENTS_MAssignment Details
HCMPER_PERIODS_OF_SERVICEPER_PERIODS_OF_SERVICEPeriods of Service
HCMPER_JOBSPER_JOBS_FJob Definitions
HCMPER_POSITIONSHR_ALL_POSITIONS_FPosition Definitions
HCMPER_GRADESPER_GRADES_FGrade Definitions
HCMPER_ADDRESSESPER_PERSON_ADDRESSES_VPerson Addresses
HCMPER_PHONESPER_PHONESPhone Numbers
HCMPER_EMAIL_ADDRESSESPER_EMAIL_ADDRESSESEmail Addresses
HCMPER_NATIONAL_IDENTIFIERSPER_NATIONAL_IDENTIFIERSNational Identifiers
HCMPER_PAY_PROPOSALSCMP_SALARYSalary Proposals / Compensation
HCMPER_PERSON_TYPE_USAGES_FPER_PERSON_TYPE_USAGES_MPerson Type Usages
HCMHR_ALL_ORGANIZATION_UNITSHR_ORGANIZATION_VOrganization Details
HCMHR_LOCATIONS_ALLPER_LOCATION_DETAILS_FLocations
HCMPAY_PERSONAL_PAYMENT_METHODS_FPAY_PERSONAL_PAYMENT_METHODS_FPersonal Payment Methods
HCMPER_ABSENCE_ATTENDANCESANC_PER_ABS_ENTRIESAbsence Entries
HCMPER_ABSENCE_ATTENDANCE_TYPESANC_ABSENCE_TYPES_VLAbsence Types
HCMBEN_ELIG_PER_FBEN_ELIG_PER_FBenefits Eligibility
HCMBEN_PRTT_ENRT_RSLT_FBEN_PRTT_ENRT_RSLT_FBenefits Enrollment Results
PayrollPAY_ALL_PAYROLLS_FPAY_ALL_PAYROLLS_FPayroll Definitions
PayrollPAY_ELEMENT_TYPES_FPAY_ELEMENT_TYPES_VLElement Types
PayrollPAY_ELEMENT_LINKS_FPAY_ELEMENT_LINKS_FElement Links
PayrollPAY_ELEMENT_ENTRIES_FPAY_ELEMENT_ENTRIES_FElement Entries
PayrollPAY_RUN_RESULTSPAY_RUN_RESULTSPayroll Run Results
PayrollPAY_RUN_RESULT_VALUESPAY_RUN_RESULT_VALUESRun Result Values
PayrollPAY_PAYROLL_ACTIONSPAY_PAYROLL_ACTIONSPayroll Actions
PayrollPAY_ASSIGNMENT_ACTIONSPAY_ASSIGNMENT_ACTIONSAssignment Actions
PayrollPAY_COST_ALLOCATION_KEYFLEXPAY_COST_ALLOC_KEYFLEXCost Allocation Flexfield
PayrollPAY_ORG_PAYMENT_METHODS_FPAY_ORG_PAYMENT_METHODS_FOrganization Payment Methods
Fixed Assets (FA)FA_ADDITIONS_BFA_ADDITIONS_BAsset Additions
Fixed Assets (FA)FA_BOOKSFA_BOOKSAsset Financial Books
Fixed Assets (FA)FA_ASSET_HISTORYFA_ASSET_HISTORYAsset History
Fixed Assets (FA)FA_CATEGORIES_BFA_CATEGORIES_BAsset Categories
Fixed Assets (FA)FA_LOCATIONSFA_LOCATIONSAsset Locations
Fixed Assets (FA)FA_DEPRN_SUMMARYFA_DEPRN_SUMMARYDepreciation Summary
Fixed Assets (FA)FA_DEPRN_DETAILFA_DEPRN_DETAILDepreciation Details
Fixed Assets (FA)FA_RETIREMENTSFA_RETIREMENTSAsset Retirements
Fixed Assets (FA)FA_TRANSACTION_HEADERSFA_TRANSACTION_HEADERSAsset Transaction Headers
Fixed Assets (FA)FA_DISTRIBUTION_HISTORYFA_DISTRIBUTION_HISTORYAsset Distribution History
Fixed Assets (FA)FA_MASS_ADDITIONSFA_MASS_ADDITIONSMass Additions
Fixed Assets (FA)FA_ADJUSTMENTSFA_ADJUSTMENTSAsset Adjustments
Fixed Assets (FA)FA_DEPRN_PERIODSFA_DEPRN_PERIODSDepreciation Periods
Fixed Assets (FA)FA_BOOK_CONTROLSFA_BOOK_CONTROLSAsset Book Controls
Fixed Assets (FA)FA_METHODSFA_METHODSDepreciation Methods
Cash Management (CE)CE_BANK_ACCOUNTSCE_BANK_ACCOUNTSBank Accounts
Cash Management (CE)CE_BANK_ACCT_USES_ALLCE_BANK_ACCT_USES_ALLBank Account Uses
Cash Management (CE)CE_STATEMENT_HEADERSCE_STATEMENT_HEADERSBank Statement Headers
Cash Management (CE)CE_STATEMENT_LINESCE_STATEMENT_LINESBank Statement Lines
Cash Management (CE)CE_BANKS_VCE_BANKS_VBanks Master
Cash Management (CE)CE_BANK_BRANCHES_VCE_BANK_BRANCHES_VBank Branches Master
Cash Management (CE)CE_STATEMENT_RECONCILIATIONSCE_STATEMENT_RECONCILS_ALLStatement Reconciliations
Cash Management (CE)CE_PAYMENT_DOCUMENTSCE_PAYMENT_DOCUMENTSPayment Documents
Cash Management (CE)CE_GL_ACCOUNTS_CCIDCE_GL_ACCOUNTS_CCIDCE GL Accounts
Cash Management (CE)CE_CASHFLOWSCE_CASHFLOWSCashflows
Projects (PA)PA_PROJECTS_ALLPJF_PROJECTS_ALL_BProjects Master
Projects (PA)PA_TASKSPJF_TASKS_VTasks
Projects (PA)PA_EXPENDITURES_ALLPJC_EXPENDITURES_ALLExpenditure Headers
Projects (PA)PA_EXPENDITURE_ITEMS_ALLPJC_EXP_ITEMS_ALLExpenditure Items
Projects (PA)PA_AGREEMENTS_ALLPJB_AGREEMENTS_ALLProject Agreements
Projects (PA)PA_DRAFT_INVOICES_ALLPJB_INVOICE_HEADERSDraft Invoices Headers
Projects (PA)PA_DRAFT_INVOICE_ITEMSPJB_INVOICE_LINESDraft Invoice Lines
Projects (PA)PA_DRAFT_REVENUES_ALLPJB_REVENUE_HEADERSRevenue Headers
Projects (PA)PA_BUDGET_VERSIONSPJO_PLAN_VERSIONSProject Budgets/Plans
Projects (PA)PA_PROJECT_CUSTOMERSPJF_PROJECT_CUSTOMERSProject Customers
Manufacturing (WIP / BOM)WIP_ENTITIESWIE_WORK_ORDERS_BWork Orders
Manufacturing (WIP / BOM)WIP_OPERATIONSWIE_WORK_ORDER_OPERATIONS_BWork Order Operations
Manufacturing (WIP / BOM)WIP_REQUIREMENT_OPERATIONSWIE_WO_MATERIALS_BWork Order Material Requirements
Manufacturing (WIP / BOM)BOM_BILL_OF_MATERIALSWIS_WORK_DEFINITIONSBill of Materials / Work Definitions
Manufacturing (WIP / BOM)BOM_INVENTORY_COMPONENTSWIS_WD_OPER_COMPONENTSBOM Components
E-Business Tax (ZX)ZX_LINESZX_LINESTax Lines
E-Business Tax (ZX)ZX_LINES_DET_FACTORSZX_LINES_DET_FACTORSTax Line Determining Factors
E-Business Tax (ZX)ZX_RATES_BZX_RATES_BTax Rates
E-Business Tax (ZX)ZX_TAXES_BZX_TAXES_BTax Definitions
E-Business Tax (ZX)ZX_REGIMES_BZX_REGIMES_BTax Regimes
Workflow & AlertsWF_ITEMSWFTASK (BPEL/BPM)Workflow Instance/Task
Workflow & AlertsWF_ITEM_ACTIVITY_STATUSESWFTASKHISTORYWorkflow Status History
Workflow & AlertsWF_NOTIFICATIONSWFTASK / SOA InfraWorkflow Notifications
Workflow & AlertsALR_ALERTSHRC_ALERTS_BAlerts
Workflow & AlertsALR_ACTIONSBPM / SOA InfraAlert Actions

No comments:

Post a Comment

How To: Remove all rows from view object (VO) in OAF & ADF

This is the basic requirement when we are working with oracle OAF. In which we need to removed the all rows from the table. The best use ca...