Financial Close Insight
The following table lists objects (tables) of the Financial Close Insight for Oracle.
| Table/view name in IRC | Friendly name |
|---|---|
| AP_AWT_GROUPS | Withholding Tax Group |
|
AP_BANK_ACCOUNTS_ALL Extracted table name for Oracle 12 version = IBY_EXT_BANK_ACCOUNTS |
Bank Accounts |
|
AP_BANK_BRANCHES Extracted table name for Oracle 12 version = CE_BANK_BRANCHES_V |
Bank Branches |
| AP_DISTRIBUTION_SETS_ALL | Individual Distribution Sets |
| AP_TAX_CODES_ALL | Tax Codes |
| AR_VAT_TAX_ALL_B | Tax Codes |
| CE_BANK_STMT_MAP_LINE | Bank Statement Mapping |
| CE_TRANSACTION_CODES | Bank Transaction Codes |
| FA_AMORT_SCHEDULES | Amortization Schedules |
| FA_ASSET_KEYWORDS | Asset Key Flexfield Segment Combinations |
| FA_BOOK_CONTROLS | Book Control Details |
| FA_CALENDAR_PERIODS | Calendar Periods |
| FA_CALENDAR_TYPES | Calendar Types |
| FA_CATEGORIES_B | Default Financial Information |
| FA_CATEGORY_BOOK_DEFAULTS | Default Depreciation Rules |
| FA_CATEGORY_BOOKS | Category Books |
| FA_CONVENTION_TYPES | Convention Types |
| FA_CONVENTIONS | Convention Details |
| FA_DISTRIBUTION_DEFAULTS | Distribution Set Details |
| FA_DISTRIBUTION_SETS | Header Distribution Set Details |
| FA_FISCAL_YEAR | Fiscal Year |
| FA_FORMULAS | Depreciation Rates For Formula Based Methods |
| FA_LEASE_PAYMENT_ITEMS | Lease Payment Items |
| FA_LEASE_PAYMENTS | Lease Payments |
| FA_LEASE_SCHEDULES | Lease Payment Schedule Details |
| FA_LEASES | Lease Details |
| FA_LOCATIONS | Location Flexfield Segment Value Combinations |
| FA_LOOKUP_TYPES_B | Translations For QuickCodes |
| FA_LOOKUPS_B | Seeded amp User Defined Values For QuickCodes |
| FA_PRICE_INDEX_VALUES | Price Index Values |
| FA_PRICE_INDEXES | Price Indexes |
| FA_RATES | FA Rates |
| FA_SYSTEM_CONTROLS | System Controls |
| FA_WARRANTIES | Warranty |
| FINANCIALS_SYSTEM_PARAMS_ALL | Financials System Parameters |
| FND_CURRENCIES | Currencies |
| FND_DESCR_FLEX_COLUMN_USAGES | Descriptive FlexField Segment Summary |
| FND_DESCR_FLEX_CONTEXTS | Descriptive FlexField Context Field Values |
| FND_DOC_SEQUENCE_ASSIGNMENTS | Document Sequence Assignments |
| FND_DOCUMENT_SEQUENCES | Document Sequences |
| FND_FLEX_HIERARCHIES | Key FlexField Rollup Groups |
| FND_FLEX_VALIDATION_EVENTS | Special Validation Routines |
| FND_FLEX_VALIDATION_RULE_LINES | Key Flexfield Cross |
| FND_FLEX_VALIDATION_RULES | Key Flexfield Cross |
| FND_FLEX_VALIDATION_TABLES | Validation Table Information |
| FND_FLEX_VALUE_RULE_USAGES | Flexfield Security Rules Assigned To Responsibilities |
| FND_FLEX_VALUE_RULES | Flexfield Security Rules |
| FND_FLEX_VALUE_SETS | Value Sets |
| FND_FLEX_VALUES | Value Set Values |
| FND_FLEX_WORKFLOW_PROCESSES | Workflow Processes |
| FND_ID_FLEX_SEGMENTS | Key Flexfield Segments |
| FND_ID_FLEX_STRUCTURES | Key Flexfield Structures |
| FND_ID_FLEXS | Key Flexfield Details |
| FND_SHORTHAND_FLEX_ALIASES | Key Flexfield Shorthand Aliases |
| GL_AUTHORIZATION_LIMITS | Journal Approval Authorization Limits |
| GL_AUTOMATIC_POSTING_OPTIONS | Automatic Posting Criteria |
| GL_AUTOMATIC_POSTING_SETS | Automatic Posting Sets Criteria |
| GL_AUTOREVERSE_OPTIONS | Automatic Journal Reversals Criteria |
| GL_CODE_COMBINATIONS | Account Combinations |
| GL_CONCURRENT_SCHEDULES | GL Concurrent Schedule |
| GL_DAILY_CONVERSION_TYPES | Conversion Rate Types |
| GL_DAILY_RATES | Daily Conversion Rates |
| GL_ENCUMBRANCE_TYPES | Encumbrance Type Definitions |
| GL_HISTORICAL_RATES | Historical Currency Translation Rates |
| GL_IEA_AUTOGEN_MAP | Automatic Account Generation Mapping Rules |
| GL_IEA_SUBSIDIARIES | Subsidiary definitions |
| GL_IEA_TRANSACTION_TYPES | Intercompany Transaction Types |
| GL_INTERCOMPANY_ACOUNTS | Intercompany Accounts |
| GL_JE_CATEGORIES_TL | Journal Entry Categories |
| GL_JE_SOURCES_TL | Journal Entry Source |
| GL_MOVEMERGE_ACCOUNTS | Mass Maintenance Request Account Mappings |
| GL_MOVEMERGE_REQUESTS | Mass Maintenance Request |
| GL_NET_INCOME_ACCOUNTS | Net Income Accounts |
| GL_PERIOD_SETS | Calendar Definitions |
| GL_PERIOD_STATUSES | Calendar Period Statuses |
| GL_PERIOD_TYPES | Calendar Period Types |
| GL_PERIODS | Calendar Period Definitions |
|
GL_SETS_OF_BOOKS Extracted table name for Oracle 12 version = GL_LEDGERS |
Set Of Books Definitions |
| GL_SUMMARY_TEMPLATES | Summary Account Templates |
| GL_SUSPENSE_ACCOUNTS | Additional Suspense Accounts |
|
GL_TAX_OPTION_ACCOUNTS Extracted table name for Oracle 12 version = ZX_ACCT_TX_CLS_DEFS_ALL |
Tax Option Details |
| GL_TAX_OPTIONS | Tax Options |
| GL_TRANSACTION_CALENDAR | Transaction calendar definitions |
| GL_TRANSACTION_DATES | Transaction Dates |
|
GL_TRANSLATION_RATES Extracted table name for Oracle 12 version = GL_DAILY_RATES |
Foreign Currency Translation Rates |