Order-to-Cash Insight

The following table lists objects (tables) of the Order to Cash Insight for Oracle.

Table /view name in IRC Friendly name

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_BANK_CHARGES Bank Charges
AP_PAYMENT_PROGRAMS Automatic Payment Programs
AP_REPORTING_ENTITIES_ALL Tax Reporting Entities
AP_REPORTING_ENTITY_LINES_ALL Tax Reporting Entity Details
AR_AGING_BUCKET_LINES_B Aging Bucket Periods
AR_AGING_BUCKETS Aging Bucket
AR_APP_RULE_DETAILS Application Rules
AR_APP_RULE_SETS Application Rule Sets
AR_APPROVAL_USER_LIMITS Approval Limits
AR_AUTOCASH_HIERARCHIES Auto Cash Rule Sets
AR_AUTOCASH_RULES Auto Cash Rules
AR_BATCH_SOURCES_ALL Batch Sources
AR_COLLECTORS Receivables Collectors
AR_CUST_PROF_CLASS_AMOUNTS Customer Profile Class Amount Limits
AR_DISTRIBUTION_SET_LINES_ALL Individual Distribution Set Details
AR_DISTRIBUTION_SETS_ALL Individual Distribution Sets
AR_DUNNING_LETTER_SET_LINES Dunning Letter Details
AR_DUNNING_LETTER_SETS Dunning Letter Sets
AR_DUNNING_LETTERS_B Dunning Letter Information
AR_DUNNING_LETTERS_CUSTOM_TL Custom Dunning Letters
AR_LOCATION_COMBINATIONS Location Combinations
AR_LOCATION_RATES Location Rates
AR_LOCATION_VALUES Location Values
AR_LOCKBOXES_ALL Lockbox Details
AR_MEMO_LINES_ALL_B Standard Memo Lines
AR_RECEIPT_CLASSES Receipt Classes
AR_RECEIPT_METHOD_ACCOUNTS_ALL Account Information Used By Payment Methods
AR_RECEIPT_METHODS Receipt Methods
AR_RECEIVABLES_TRX_ALL Accounting Information For Receivables Activities
AR_SALES_TAX Sales Tax
AR_STATEMENT_CYCLE_DATES_ALL Statement Cycle Dates
AR_STATEMENT_CYCLES Statement Cycles
AR_SYSTEM_PARAMETERS_ALL AR System Parameters
AR_TAX_CONDITION_ACTIONS_ALL Tax Conditions Actions
AR_TAX_CONDITIONS_ALL Tax Condition Sets
AR_TAX_GROUP_CODES_ALL Tax Codes Within Tax Group
AR_TRANS_FIELD_FORMATS Field Format In Lockbox Transmission
AR_TRANS_RECORD_FORMATS Record Format In Lockbox Transmission
AR_TRANSMISSION_FORMATS Lockbox Transmission Formats
AR_VAT_TAX_ALL_B Tax Codes
BOM_PARAMETERS Bill Of Material Parameters
BOM_RESOURCES Bill Of Material Resources
CST_CG_WIP_ACCT_CLASSES WIP Accounting Class
CST_COST_GROUP_ACCOUNTS Cost Group Accounts
CST_COST_GROUPS Stores Cost Groups
CST_COST_TYPES Stores Cost Types
CST_ITEM_OVERHEAD_DEFAULTS Default Value For Overhead Cost
ENG_CHANGE_ORDER_TYPES Engineering Change Order Types
ENG_CHANGE_PRIORITIES Engineering Change Order Priorities
ENG_CHANGE_TYPE_PROCESSES Engineering Change Type Processes
FND_APPLICATION Oracle Application Object Library
FND_COLUMNS FlexField Columns
FND_CURRENCIES Currencies
FND_DEFAULT_CONTEXT_FIELDS Default Descriptive Flexfields
FND_DESCRIPTIVE_FLEXS Descriptive Flexfields Registration
FND_DOC_SEQUENCE_ASSIGNMENTS Document Sequence Assignments
FND_DOC_SEQUENCE_CATEGORIES Document Sequence Categories
FND_DOCUMENT_CATEGORIES Document Categories
FND_DOCUMENT_DATATYPES Document Data Types
FND_DOCUMENT_SEQUENCES Document Sequences
FND_DOCUMENTS Documents
FND_GRANTS Permissions
FND_ID_FLEX_STRUCTURES Key Flexfield Structures
FND_LOOKUP_TYPES Oracle Application Object Library QuickCode Types
FND_LOOKUP_VALUES QuickCode Values
FND_MENUS Menu
FND_PRODUCT_GROUPS Product Groups
FND_PROFILE_OPTIONS User Profile Options
FND_RESPONSIBILITY Responsibilities
FND_USER Application users
GL_CODE_COMBINATIONS GL Code Combinations
GL_DAILY_CONVERSION_TYPES Conversion Rate Types
GL_DAILY_RATES Daily Conversion Rates
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_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_TRANSLATION_RATES

Extracted table name for Oracle 12 version = GL_DAILY_RATES

Foreign Currency Translation Rates
HZ_CREDIT_USAGE_RULE_SETS_B Credit Usages Rule Sets
HZ_CUST_PROFILE_CLASSES Standard Credit Profile Classes
MTL_ATP_RULES ATP Computation Rules
MTL_CATEGORIES_B Item Category Code Combination
MTL_CATEGORY_ACCOUNTS Accounts Categorization
MTL_CATEGORY_SET_VALID_CATS Category Sets Types
MTL_CATEGORY_SETS_B Category Sets
MTL_COMMODITY_CODES Commodity Codes
MTL_COUNTRY_ASSIGNMENTS Country Assignment
MTL_DEFAULT_CATEGORY_SETS Functional Area Default Category Sets
MTL_DESCRIPTIVE_ELEMENTS Descriptive Elements
MTL_ECONOMIC_ZONES_B Economic Zones
MTL_FORECAST_RULES Forecast Rules
MTL_GENERIC_DISPOSITIONS Account Alias
MTL_INTERCOMPANY_PARAMETERS Inter
MTL_INTERFACE_PROC_CONTROLS Interface Processes Control Parameters
MTL_INTERORG_PARAMETERS Inter
MTL_INTERORG_SHIP_METHODS Inter
MTL_ITEM_ATTRIBUTES Item Attributes
MTL_ITEM_CATEGORIES Item Categories
MTL_ITEM_LOCATIONS Item Locations
MTL_ITEM_SUB_DEFAULTS Subinventory Default Values
MTL_ITEM_SUB_INVENTORIES Subinventory Assignments
MTL_ITEM_TEMPL_ATTRIBUTES Attributes and Attribute Values for Item Templates
MTL_ITEM_TEMPLATES Item Templates
MTL_LE_ECONOMIC_ZONES Assignment of Legal Entity to EZ
MTL_MATERIAL_STATUSES_TL Inventory Status
MTL_MVT_STATS_RULE_SETS_B Movement Statistics for Rule Sets
MTL_MVT_STATS_RULES Validation Rule For Movement Statistics Fields
MTL_PARAMETERS Inventory Parameters
MTL_PICKING_RULES Picking Rules
MTL_PLANNERS Planner Code
MTL_SECONDARY_INVENTORIES Subinventory
MTL_STATUS_ATTRIBUTE_VALUES Item Status Code Attribute Values
MTL_SYSTEM_ITEMS_B Inventory Items
MTL_TRANSACTION_REASONS Inventory Transaction Reasons
MTL_TRANSACTION_TYPES MTL Transaction Types
MTL_TXN_SOURCE_TYPES Transaction Source Types
MTL_UNITS_OF_MEASURE_TL Units of Measure
MTL_UOM_CLASS_CONVERSIONS Conversion Rates Between Two UOM
MTL_UOM_CLASSES_TL Unit of Measure Classes
MTL_UOM_CONVERSIONS UOM Conversions
OE_CREDIT_CHECK_RULES Credit Check Rules
OE_CUST_ITEM_SETTINGS Item Shipment Tolerances
OE_DEF_ATTR_CONDNS Defaulting Attribute Conditions
OE_DEF_CONDN_ELEMS Defaulting Condition Elements
OE_HOLD_AUTHORIZATIONS Hold Authorizations
OE_ORDER_SOURCES Order Sources
OE_PC_ASSIGNMENTS OE Assignments
OE_PC_RSET_SEL_COLS Constraint Record Set Columns Matched
OE_PC_RSETS Constraint Record Sets
OE_SALES_CREDIT_TYPES Sales Credit Types
OE_SYSTEM_PARAMETERS_ALL Order Entry System Parameters
OE_TRANSACTION_TYPES_ALL OE Transaction Type
ORG_ACCESS Organization Access Rules
PER_ORG_STRUCTURE_ELEMENTS Organization Structure Elements
PER_ORG_STRUCTURE_VERSIONS Organization Structure Version
PER_ORGANIZATION_STRUCTURES Organization Structures
RA_ACCOUNT_DEFAULT_SEGMENTS Auto Accounting Segment
RA_ACCOUNT_DEFAULTS_ALL Auto Accounting
RA_BATCH_SOURCES_ALL RA Batch Sources
RA_CUST_TRX_TYPES_ALL AR Transaction Type
RA_GROUP_BYS AutoInvoice Group Columns
RA_GROUPING_RULES AutoInvoice Grouping Rules
RA_ITEM_EXCEPTION_RATES Item Tax Rate Exceptions
RA_LINE_ORDER_BYS AutoInvoice Line Ordering Rule Columns
RA_LINE_ORDERING_RULES AutoInvoice Line Ordering Rules
RA_RULE_SCHEDULES Accounting Rule Schedules
RA_TAX_EXEMPTIONS_ALL Tax Exemption Rate
RA_TERMS_B Payment Terms
RA_TERMS_LINES Payment Terms Lines
RA_TERMS_LINES_DISCOUNTS Payment Terms Line Discount
RCV_PARAMETERS Organization
RCV_ROUTING_HEADERS Receiving Routing Headers
WSH_CALENDAR_ASSIGNMENTS Calendar Assignments
WSH_DOC_SEQUENCE_CATEGORIES Shipping Document Categories
WSH_EXCEPTION_DEFINITIONS_B Base Exception Definitions
WSH_FREIGHT_COST_TYPES Freight Cost Types
WSH_GRANTS User Role Grants
WSH_PICK_GROUPING_RULES Pick Release Grouping Rules
WSH_PICK_SEQUENCE_RULES Pick Sequence Rules
WSH_REPORT_SET_LINES Report Set Lines
WSH_ROLES User Role Definitions
WSH_SHIPPING_PARAMETERS Shipping Parameters