Financials Tables and Views

This guide contains the information about tables within Oracle Financials Cloud and their columns, primary keys, and indexes. The guide also includes the information about views within Oracle Financials Cloud along with the columns and queries associated with each view. For your reference:

• Tables are the basic unit of data storage in Oracle Financials Cloud, where data is stored in rows and columns. For example, the AR_ADJUSTMENTS_ALL table stores general information about the adjustment that you make, such as activity name, amount, accounting information, reason, and type of adjustment. This table stores attributes like adjustment identifier, adjustment type, and adjustment amount.

• A view is a logical representation of a table or combination of tables. A view is a stored query that derives its data from the tables on which it is based. For example, the GL_LEDGERS_ALL_V view shows attributes like the ledger name, ledger identifier, and chart of accounts identifier.