Tables and Views in Oracle Fusion Financials
In Oracle Fusion Financials, tables are used to store data related to financial transactions, accounting entries, and other financial information. Views, on the other hand, are virtual tables that provide a structured way to access and retrieve data from these tables.
Here are some common tables and views in Oracle Fusion Financials:
Common Tables:
GL_JE_HEADERS: This table stores information about journal entries, including the journal entry header details.
GL_JE_LINES: It contains journal entry line information, including account codes, amounts, and descriptions.
FA_BOOKS: This table stores information related to fixed assets, such as asset details, depreciation, and book information.
AR_INVOICES_ALL: In the Accounts Receivable module, this table stores data about invoices and their associated transactions.
Common Views:
XLA_AE_HEADERS: This view provides access to accounting event header information, which is used in financial accounting.
XLA_AE_LINES: It is a view that provides accounting event line information, including accounting codes and amounts.
AP_INVOICE_V: In the Accounts Payable module, this view allows you to access invoice-related data.
CE_BANK_ACCOUNTS_V: This view provides information about bank accounts used in cash management.
.