AR_ADJUSTMENTS_REP_ITF | RXi interface table for the Adjustments Register report |
AR_ACTIVITY_DETAILS | Receivable Activities Details |
AR_ADJUSTMENTS_ALL | Pending and approved invoice adjustments |
AR_AGING_BUCKETS | Aging bucket lines used in Receivables aging reports |
AR_AGING_BUCKET_LINES_TL | Provides multi-lingual support (MLS) for aging bucket periods. MLS enables you to store and print data that you define in multiple languages. |
AR_AGING_EXTRACT | Temporary table used in MFAR aging report process |
AR_AGING_PAYMENT_SCHEDULES | Temporary table used in MFAR aging report process |
AR_AGING_MFAR_EXTRACT | Temporary table used in MFAR aging report process |
AR_AGING_BUCKET_LINES_B | An individual aging bucket period that is part of an aging bucket set |
AR_APPROVAL_ACTION_HISTORY | Approval and change history for invoice adjustments |
AR_APP_RULES | Application Rules |
AR_ACTION_NOTIFICATIONS | Employees to be notified about a particular customer call |
AR120GIR_PERIODS | AR120GIR Periods |
AR_ARCHIVE_CONTROL_DETAIL | Detailed archive and purge information |
AR_ARCHIVE_DETAIL | Line and distribution-level archive information |
AR_APPROVAL_USER_LIMITS | User adjustment approval limits |
AR_APP_RULE_SETS | Application Rule Sets |
AR_ARCHIVE_PURGE_INTERIM | Interim table used by the Archive and Purge program |
AR_ARCHIVE_CONTROL | Historical archive and purge information |
AR_ARCHIVE_PURGE_LOG | Log information generated during the Archive and Purge process |
AR_AUTOCASH_HIERARCHIES | AutoCash Rule Sets information |
AR_AUDIT_DATA | Temporary table used in the rollforward process |
AR_AUTOREC_EXCEPTIONS | Temporary table used to store exceptions found by Automatic Receipts and its related programs |
AR_AUTOREC_INTERIM | Temporary table used in the autoreceipts parallel process |
AR_ARCHIVE_HEADER | Header-level archive information |
AR_AUTOCLEAR_INTERIM | Temporary table used in the autoclearance parallel process |
AR_BANK_DIRECTORY | This table stores bank information. |
AR_BPA_CONTENT_AREAS_B | Release 11i: Used by Bill Presentment Architecture |
AR_BATCHES_ALL | Receipt batch information |
AR_BPA_AREA_ITEMS | The AR_BPA_AREA_ITEMS table stores the selected content items for each template defined in Bill Presentment Architecture. |
AR_BASE_GL_ACCT_BALANCES | Used as a processing table for Cumulative Activity Balance Report. |
AR_BATCH_SOURCES_ALL | Accounting, bank account, and numbering information for a batch |
AR_BPA_CONTENT_AREAS_TL | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_DATASRC_APPS_TL | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_DATASRC_APPS_B | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_DATA_SOURCES_B | The AR_BPA_DATA_SOURCES_B table stores all the data sources that Bill Presentment Architecture can access. |
AR_AUTOCASH_RULES | Application method for each rule in an AutoCash Rule Set |
AR_BPA_DATA_SOURCES_TL | The AR_BPA_DATA_SOURCES_TL table stores all the data sources that Bill Presentment Architecture can access. |
AR_BPA_DATA_SRC_PARAMS | The AR_BPA_DATA_SRC_PARAMS table stores the parameters that are used to present transaction data from the AR_BPA_DATA_SOURCES table on a Bill Presentment Architecture bill. |
AR_BPA_ITEMS_TL | The AR_BPA_ITEMS_TL table provides multilingual support (MLS) for content items defined in Bill Presentment Architecture. |
AR_BPA_PRINT_REQUESTS | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_PAGE_SETUPS_B | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_ITEMS_B | The AR_BPA_ITEMS_B table stores all the content items that can be added to a bill template using the Bill Presentment Architecture. |
AR_BPA_PAGE_SETUPS_TL | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_DATA_SOURCES | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_RULES_TL | The AR_BPA_RULES_TL table provides multilingual support (MLS) for assignment rules defined in Bill Presentment Architecture. Data in this table is maintained in the Assignment Rules page. Each row includes the rule name and description. MLS |
AR_BPA_RULE_ATTRIBUTES_B | The AR_BPA_RULE_ATTRIBUTES_B table stores all assignment attributes of assignment rules defined in Bill Presentment Architecture. |
AR_BPA_TEMPLATES_TL | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_TEMPLATES_B | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_RULE_ATTRIBUTES_TL | The AR_BPA_RULE_ATTRIBUTES_TL table provides multilingual support (MLS) for assignment attributes of assignment rules defined in Bill Presentment Architecture. |
AR_BPA_TEMPLATE_FIELDS | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_TEMPLATE_FILES | Release 11i: Used by Bill Presentment Architecture |
AR_BPA_URL_PARAMS | The AR_BPA_URL_PARAMS table stores all parameters for the URLs defined in Bill Presentment Architecture. |
AR_BR_FMT_TMP | Temporary table used to format and build Bills Receivable reports. |
AR_BPA_URLS_TL | The AR_BPA_URLS_TL table provides multilingual support (MLS) for URLs defined in Bill Presentment Architecture. |
AR_BPA_URLS_B | The AR_BPA_URLS_B table stores all URLs defined in Bill Presentment Architecture. |
AR_BR_STATUS_REP_ITF | RXi report interface table for the Bills Receivable by Status report |
AR_BPA_RULES_B | The AR_BPA_RULES_B table stores the template assignment rules defined in Bill Presentment Architecture. |
AR_CALL_ACTIONS | Customer call actions |
AR_BR_STAMP_VALUES_ALL | Bills Receivable-specific table that contain stamp information |
AR_CASH_AUTOMATCHES | This table stores Automatch Cash Rule Details (BETA) |
AR_CASH_AUTOMATCHES_TL | This table stores language specific details of Automatch Cash Rules (BETA) |
AR_CASH_AUTOMATCH_DTLS | This table stores string transformation details of an Automatch Rule (BETA) |
AR_BR_STATUS_SUM_ITF | RXi report interface table for the Bills Receivable by Status report |
AR_CASH_AUTOMATCH_RULE_MAP | This table stores Automatch rules associated to a Rule Set (BETA) |
AR_CASH_AUTO_RULE_SETS | This table stores Automatch Rule Set details (BETA) |
AR_CASH_RECOS_ALL | This table stores Recommendation details generated for the document number references provided (BETA) |
AR_CASH_AUTO_RULE_SETS_TL | This table stores language specific details of Automatch Rule Sets (BETA) |
AR_CASH_RECEIPT_HISTORY_ALL | History of actions and status changes in the life cycle of a receipt |
AR_CASH_RECOS_PS_GT | GT Table for Recommendations UI (BETA) |
AR_BR_TRX_BATCH_RPT | Report table for the Automatic Transaction Batch report |
AR_CASH_RECO_LINES_ALL | This table stores Application Details for the Recommendations generated in AR_CASH_RECOS_ALL (BETA) |
AR_CASH_REMIT_REFS_ALL | This table stores Cash Remittance Reference details (BETA) |
AR_CASH_RECEIPTS_ALL | Detailed receipt information |
AR_CCID_CORRECTIONS_ALL | Individual GL distribution lines that contain invalid code combinations (GL accounts) |
AR_CASH_REMIT_REFS_INTERIM | An Interim Table used to store the subset of data from AR_CASH_REMIT_REFS_ALL for a particular run of Auto Cash Application Program (BETA) |
AR_CASH_BASIS_DISTS_ALL | Distribution of payments over revenue accounts, used in Cash Basis Accounting |
AR_CC_ERROR_MAPPINGS | This table stores credit card errors and the corresponding corrective actions for automation. |
AR_CC_ERROR_HISTORY | This table stores the execution report information for AutoReceipt or Remittance batches. |
AR_CHANGE_MATRIX | This table is no longer used. |
AR_CCID_BY_GL_ACCOUNTS | Used as a processing table for Cumulative Activity Balance Report. |
AR_CHARGE_SCHEDULES | Charge Schedules |
AR_CHARGE_SCHEDULE_HDRS | Charge Schedule Headers |
AR_CHARGE_SCHEDULE_LINES | Charge Schedule lines |
AR_CLOSED_GL_PERIODS | Used as a processing table for Cumulative Activity Balance Report. |
AR_CMGT_AUTO_RULES | The AR_CMGT_AUTO_RULES table stores rules about whether a credit review and credit decision may be accomplished without user intervention. |
AR_CMGT_AUTO_RECOMMENDS | The AR_CMGT_AUTO_RECOMMENDS table stores the credit recommendations that result from automated credit reviews. |
AR_CMGT_CASE_FOLDERS | The AR_CMGT_CASE_FOLDERS table stores information for each case folder. |
AR_CMGT_CF_AGING_DTLS | The AR_CMGT_CF_AGING_DTLS table stores the calculated aging bucket values for the customer under credit review when the case folder is created. |
AR_CMGT_AUTO_RULE_DTLS | The AR_CMGT_AUTO_RULE_DTLS table stores rules about whether a credit review and credit decision may be processed without user intervention. |
AR_CMGT_CF_DNB_DTLS | The AR_CMGT_CF_DNB_DTLS table identifies to Oracle Credit Management where Dun & Bradstreet Global Data Product report data is stored, when purchased and imported for use in a credit review. |
AR_CMGT_CF_ANL_NOTES | The AR_CMGT_CF_ANL_NOTES table stores topical notes created by the credit analyst and stored in the case folder during a credit review. |
AR_CMGT_CF_DTLS | The AR_CMGT_CF_DTLS table stores each data point and its value that you selected for display in a case folder. |
AR_CMGT_CF_RECOMMENDS | The AR_CMGT_CF_RECOMMENDS table stores the credit recommendations submitted for each case folder. |
AR_CMGT_BANK_REF_ACCTS | The AR_CMGT_BANK_REF_ACCTS table stores detailed bank account balance information for the company under credit review. |
AR_CMGT_BANK_REF_DATA | The AR_CMGT_BANK_REF_DATA table stores information about the banks where a company under credit review has active accounts. |
AR_CMGT_CHECK_LISTS | The AR_CMGT_CHECK_LISTS table stores information about your organizations credit policies. Each checklist defines what data points and requirements exist for different types of credit reviews. |
AR_CMGT_CHECK_LIST_DTLS | The AR_CMGT_CHECK_LIST_DTLS table stores detail level information for a checklist in Oracle Credit Management. |
AR_CMGT_DATA_POINTS_TL | The AR_CMGT_DATA_POINTS_TL table provides multilingual support (MLS) for all case folder data points that are available for display in Oracle Credit Management. |
AR_CMGT_COLLATERAL_DATA | The AR_CMGT_COLLATERAL_DATA table stores detailed information about assets that can be pledged to secure credit available by the company under credit review pledged to secure credit. |
AR_CMGT_DATA_POINTS_B | The AR_CMGT_DATA_POINTS_B table stores information about the details of each data point in Oracle Credit Management. |
AR_CMGT_CREDIT_REQUESTS | The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request. |
AR_CMGT_DNB_ELEMENTS_TL | The AR_CMGT_DNB_ELEMENTS_TL table provides multilingual support (MLS) for all Dun & Bradstreet data points displayed in a case folder in Oracle Credit Management. MLS lets you store and print information that you define in multiple language |
AR_CMGT_FINANCIAL_DATA | The AR_CMGT_FINANCIAL_DATA table stores financial statements information about the company under credit review. |
AR_CMGT_GUARANTOR_DATA | The AR_CMGT_GUARANTOR_DATA table stores information about an entity who is legally responsible for fulfilling a credit obligation if the primary party, the company under credit review, fails to pay its debt. |
AR_CMGT_SCORES | The AR_CMGT_SCORES table stores header level information for a credit scoring model. |
AR_CMGT_SCORE_DTLS | The AR_CMGT_SCORE_DTLS table stores detail level information for a credit scoring model used in Oracle Credit Management. |
AR_CMGT_HOLD_DETAILS | This table stores hold details of a credit request |
AR_CMGT_DNB_ELEMENTS_B | The AR_CMGT_DNB_ELEMENTS_B table identifies the intersection between where Dun & Bradstreet Global Data Product report data is stored and how it is retrieved for display in Oracle Credit Management. Each report has a number of data points t |
AR_CMGT_DNB_MAPPINGS | The AR_CMGT_DNB_MAPPINGS table identifies each data point contained within the Dun & Bradstreet Global Data Product reports and maps them to Oracle Credit Management. |
AR_CMGT_OTHER_DATA | The AR_CMGT_OTHER_DATA table stores detailed information about Venture Capital funding in use by the company under credit review. |
AR_CMGT_TRADE_REF_DATA | The AR_CMGT_TRADE_REF_DATA table stores information about the a companys credit and trade relationships of a company under credit review with other creditors. |
AR_CMGT_SCORE_WEIGHTS | The AR_CMGT_SCORE_WEIGHTS table stores weights for each data point in a scoring model. |
AR_CMGT_SETUP_OPTIONS | The AR_CMGT_SETUP_OPTIONS table stores information that you supply to customize Oracle Credit Management. |
AR_COLLECTION_INDICATORS_ALL | Collection Indicators for a closed period, used by the Collection Indicators report |
AR_CONC_PROCESS_REQUESTS | Currently running or terminated concurrent requests |
AR_COGS_REV_ITF | The AR_COGS_REV_ITF table holds temporary data for the COGS RXi reports. |
AR_COLLECTORS | Information about collectors |
AR_COLIND | Temporary table used by the Oracle Business Intelligence System (OBIS) |
AR_CONS_BILL_CYCLES_TL | The AR_CONS_BILL_CYCLES_TL table provides multilingual support (MLS) for each billing cycle that you define in Receivables. MLS lets you store and print data that you define in multiple languages. |
AR_CONC_REQUEST_MESSAGES | Untranslated messages for server PL/SQL error and log reporting |
AR_CONS_BILL_CYCLE_DATES | This table stores billing dates for given billing cycle. |
AR_CONS_BILL_CYCLES_B | The AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables creates one row for each billing cycle that you define. This information iis used to distinguish which activity to include on a bill. |
AR_CONS_INV_TRX_LINES_ALL | Transaction lines included on a consolidated billing invoice |
AR_CONS_INV_TRX_ALL | Transactions included on a consolidated billing invoice |
AR_CONS_INV_ALL | Information about a consolidated billing invoice |
AR_CONFIRMATION_ACTIONS | This table stores information about which action to take based on the information that is included in trading partner's confirmation message. |
AR_CONT_ACTIONS_ALL | Maps contingencies and revenue recognition events |
AR_CREATE_RECEIPTS_ERROR | Used to store error details during receipt creation |
AR_CORRESPONDENCES_ALL | Dunning letters sent to a customer |
AR_CREDIT_HISTORIES | History of changes to a customer's credit profile |
AR_CREDIT_MEMO_AMOUNTS | GL dates for credit memos that use invoicing rules to back out revenue |
AR_CORR_PAY_SCHED_ALL | Intersection table to show invoices referenced in a dunning letter |
AR_CUSTOMER_ALT_NAMES | Alternate customer names for AutoLockbox name matching |
AR_CUSTOMER_BALANCE_ITF | Customers selected for the Customer Open Balance Letter report |
AR_CUSTOMER_PROFILE_CLASSES | Customer profile class information |
AR_CUSTOMER_PROFILE_AMOUNTS | Customer profile amount limits for each currency |
AR_CUSTOMER_CALLS_ALL | Customer call information |
AR_CUST_PROF_CLASS_AMOUNTS | Customer profile class amount limits for each currency |
AR_CUSTOMER_CALL_TOPICS_ALL | Topic of a customer call |
AR_CUSTOMER_PROFILES | Customer credit information |
AR_DEFERRAL_REASONS | Revenue Contingency Definitions |
AR_DEFERRED_LINES_ALL | Stores revenue status information at the line level |
AR_DISPUTE_HISTORY | A history of invoice disputes for each payment schedule |
AR_DISTRIBUTIONS_ALL | Accounting records for receipts |
AR_DISTRIBUTION_SETS_ALL | Groups together a set of distribution lines |
AR_DOCUMENT_TRANSFERS | This table stores information about document transfer to your trading partners. |
AR_DISTRIBUTION_SET_LINES_ALL | The percentage and account for each line in a distribution set |
AR_DUNNING_LETTERS_CUSTOM_TL | Provides multi-lingual support (MLS) for custom dunning letters |
AR_DUNNING_LETTERS_TL | Provides multi-lingual support (MLS) for standard dunning letters |
AR_DOC_SEQUENCE_AUDIT | A record for every document number generated |
AR_DUNNING_LETTERS_B | Information about dunning letters |
AR_DUNNING_LETTER_SETS | Sequence in which dunning letters are sent |
AR_DUNNING_LETTER_SET_LINES | Individual lines within a dunning letter set |
AR_GL_ACCT_BALANCES | Used as a processing table for Cumulative Activity Balance Report. |
AR_GTA_RULE_DFFS_ALL | transfer rule defined on DFF on AR transaction |
AR_GTA_SYSTEM_PARAMETERS_ALL | System parameters for GTA |
AR_GTA_BATCH_NUMBERING | GTA invoice batch number |
AR_GTA_TRX_HEADERS_ALL | Header-level information for GTA Invoice |
AR_GTA_TAX_LIMITS_ALL | Limted information for GTA invoice |
AR_GTA_RULE_HEADERS_ALL | Header-level information for transfer rule |
AR_GTA_TRXIMP_TMP | Temporary interface table for VAT invoice |
AR_GTA_RULE_TRX_TYPES_ALL | Transfer rule defined on transaction type |
AR_INTEREST_BATCHES_ALL | Late Charge batches |
AR_GTA_TYPE_MAPPINGS | Transaction type mapping to Tax Registration Number and Invoice Type |
AR_INTERFACE_CONTS_ALL | Contingency information for transactions imported using AutoInvoice |
AR_INTEREST_LINES_ALL | Late Charge lines |
AR_GTA_TRX_LINES_ALL | Detail information for GTA invoice and VAT invoice |
AR_INTERIM_CASH_RCPT_LINES_ALL | Temporary table used to store QuickCash payment applications |
AR_INTERIM_CASH_RECEIPTS_ALL | QuickCash payments processed by the PostBatch program |
AR_INTERIM_POSTING | Used for posting when Cash Basis accounting is used |
AR_INTERIM_CASH_LINE_DETAILS | Temporary table used to store QuickCash payment applications - line level details |
AR_IREC_PRINT_REQUESTS | Stores iReceivables transaction print requests and BPA immediate print output. |
AR_IREC_SELFREG_SITE_QS | Contains the self registration site verification questions. |
AR_IREC_SELFREG_CUST_QS | Contains the self registration customer verification questions. |
AR_LATE_CHARGE_TRX_T | Late Charge processing table |
AR_LC_CUST_SITES_T | Late Charge processing table |
AR_LINE_CONTS_ALL | Stores contingencies for a billing line |
AR_JOURNAL_INTERIM_ALL | Temporary table used by the Journal Entries report |
AR_IREC_USER_ACCT_SITES_ALL | Contains the list of customer site IDs accessible by the current user. |
AR_LOCATION_ACCOUNTS_ALL | Stores the tax accounting information |
AR_LOCATION_RATES | Sales tax rates for each tax authority |
AR_LOCATION_VALUES_OLD | Defines the location and description for each of the value sets used in the Sales Tax Location flexfield |
AR_LOCATION_RATES_OLD | Sales tax rates for each tax authority |
AR_LOCKBOXES_ALL | Lockbox details used by the AutoLockbox program |
AR_LOCATION_COMBINATIONS | Defines each distinct tax authority |
AR_LOCATION_VALUES | Defines the location and description for each of the value sets used in the Sales Tax Location flexfield |
AR_LOC_COMBINATIONS_OLD | Defines each distinct tax authority |
AR_MC_ADJUSTMENTS | Currency-related information about invoice adjustments for each reporting set of books |
AR_MC_BATCHES | Currency-related information about receipt batches for each reporting set of books |
AR_MC_CASH_RECEIPTS | Currency-related information about receipts for each reporting set of books |
AR_MC_DISTRIBUTIONS_ALL | Currency-related information about distributions generated by the different steps in the life cycle of a cash receipt |
AR_MC_CASH_BASIS_DISTS_ALL | Distribution of payments over revenue accounts, used in Cash Basis Accounting for MRC |
AR_MC_CASH_RECEIPT_HIST | Currency-related information about each step in the life cycle of a receipt for each reporting set of books |
AR_MC_RATE_ADJUSTMENTS | Currency-related information about exchange rate adjustments for each reporting set of books |
AR_MC_PAYMENT_SCHEDULES | Currency-related information about all transactions except adjustments and miscellaneous cash receipts |
AR_MC_RECEIVABLE_APPS | Cash and credit memo applications for each reporting set of books |
AR_MISC_CASH_DISTRIBUTIONS_ALL | All accounting entries for miscellaneous cash applications |
AR_MC_MISC_CASH_DISTS | Currency and accounting information about miscellaneous cash applications for each reporting set of books |
AR_MEMO_LINES_ALL_TL | Provides multilingual support (MLS) for standard memo lines |
AR_MC_TRANSACTION_HISTORY | Stores posting-related information about transaction history lines for each reporting set of books associated with the parent record. |
AR_MEMO_LINES_ALL_B | Standard memo lines for debit memos, on-account credits, debit memo reversals, and chargebacks |
AR_NOTES | Memopad information for customer calls |
AR_PAYMENTS_INTERFACE_ALL | Imported Lockbox information that was not validated |
AR_PERIODS | Information about accounting periods |
AR_PERIOD_TYPES | Information about accounting period types |
AR_POSTING_REPORT_INTERIM | Temporary table used by the Posting Execution report |
AR_PMTS_INTERFACE_LINE_DETAILS | Table used to store Imported Lockbox line level application information that was not validated. |
AR_POSTING_CONTROL | Details of each General Ledger Interface submission |
AR_PURGE_OE_EXCEPTIONS | Interim table used by the Archive and Purge process to store identifiers for transactions that cannot be purged |
AR_PURGE_REC_AUX | Interim table used by the Archive and Purge process to store identifiers for selected receipts |
AR_PURGE_TRX_AUX | Interim table used by the Archive and Purge program to store identifiers for selected transactions |
AR_PAYMENT_SCHEDULES_ALL | All transactions except adjustments and miscellaneous cash receipts |
AR_RATE_ADJUSTMENTS_ALL | Information about adjustments made to the exchange rates of foreign currency receipts |
AR_RECEIPTS_REP_ITF | Report Exchange interface table for the Receivables Receipts reports |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | Account information for accounts used by payment methods |
AR_RECEIPT_METHODS | Information about payment methods |
AR_RAMC_AUDIT_TRAIL | This maintains revenue related status changes for invoices. |
AR_REC_TRX_LE_DETAILS_ALL | Stores the tax_rate_codes by legal entity for each receivable activity. |
AR_RECEIPT_CLASSES | Information about receipt classes |
AR_RECEIVABLES_TRX_ALL | Accounting information for Receivables activities |
AR_REVENUE_ADJUSTMENTS_ALL | Stores information about specific revenue adjustments |
AR_RECEIVABLE_APPLICATIONS_ALL | Accounting information for cash and credit memo applications |
AR_SELECTION_CRITERIA | Stores the selection criteria on a entity. |
AR_SALES_TAX_REP_ITF | Report Exchange interface table for the US Sales Tax report |
AR_SALES_TAX | Sales tax information for each tax authority defined in Oracle Receivables |
AR_STATEMENT_CYCLES | Information about statement cycles |
AR_STATEMENT_HEADERS | Interim table of statement header information |
AR_STATEMENT_CYCLE_INTERVALS | Statement cycle intervals |
AR_STANDARD_TEXT_TL | Multilingual support (MLS) for standard text messages that you define for statements |
AR_STATEMENT_CYCLE_DATES_ALL | Dates within a cycle for sending customer statements |
AR_STANDARD_TEXT_B | Standard statement messages |
AR_STATEMENT_LINE_CLUSTERS | Interim table of transaction lines that appear on a statement |
AR_STATEMENTS_HISTORY_ALL | The history of every customer statement that you generate |
AR_SUM_REF_EVENT_HIST | The AR_SUM_REF_EVENT_HIST table temporarily stores the history of all AR business events that different transactional activities raise while the Refresh AR Transactions Summary Tables concurrent program is running. |
AR_TAX_CONDITION_LINES_ALL | Tax Condition Lines |
AR_TAX_CONDITION_ACTIONS_ALL | Actions performed by Tax Condition Sets |
AR_TAX_CONDITIONS_ALL | Tax Condition Sets |
AR_SYSTEM_PARAMETERS_ALL | Oracle Receivables system options |
AR_TAX_EXTR_SUB_AP_EXT | This table is an extension to AR_TAX_EXTRACT_SUB_ITF to store transaction tax information specific to Oracle Payables. |
AR_TAX_EXTRACT_DCL_ITF | Reporting and legal entities selected by the Tax Reporting Ledger Tax Extract program |
AR_TAX_EXTR_SUB_AR_EXT | This table is an extension to AR_TAX_EXTRACT_SUB_ITF to store transaction tax information specific to Oracle Receivables. |
AR_TAX_EXTR_SUB_COM_EXT | This table is an extension to AR_TAX_EXTRACT_SUB_ITF to store the transaction tax information from Oracle Receivables, Oracle Payables and Oracle General Ledger. |
AR_TAX_GROUP_CODES_ALL | Tax codes within a tax group |
AR_TAX_EXTRACT_SUB_ITF | Tax Extract interface table |
AR_TAX_INTERFACE | Sales tax rates import table |
AR_TA_ASGN_TO_INT_ALL | Interface table that stores details about all salespersons and collectors. Can be used by external deduction management systems |
AR_TA_CASHAPP_OB_ALL | Stores the current open balance of all transactions processed by the Cash Engine for a transmission |
AR_TA_CUST_INT_ALL | Interface table that stores details about all customers; can be used by external Deduction Management Systems. |
AR_TA_CR_AGEN_INF_ALL | Stores credit information coming from a credit agency for customer-location combination |
AR_TA_CUST_HIER_CHILD | Stores information about child customers and the mapping to parent customers. Part of a parent-child hierarchy definition between customers |
AR_TA_CUST_HIER_PARNT | Stores information about parent customers that belong to parent-child hierarchies between customers |
AR_TAX_EXTRACT_MATRIX_ITF | Stores the details of matrix columns for the interface table of the Tax Reporting Ledger |
AR_TA_DEDN_ASSGNS_ALL | Stores assignment history information for deduction transactions |
AR_TA_DEDN_RELATE_ALL | Stores the relationships between deductions moved from an external Deduction Management System and new transaction created in Trade Accounting |
AR_TA_DEDN_INT_ALL | Interface table that stores deductions being moved between Trade Accounting and external Deduction Management System |
AR_TA_LEGACY_CUST_INT | Contains details of customers, including Retailed Market Areas, defined in legacy systems |
AR_TA_LEGACY_STAT_INT | Contains promotion statuses defined in the legacy system |
AR_TA_PROF_ASSGNT_ALL | Stores the mapping of receipt profiles with the key flexfield |
AR_TA_CUST_TRXSTR_ALL | Stores the link between original deductions and split or merged deductions |
AR_TA_PROMOTIONS_INT | Interface table that contains imported promotion data that was not validated or transferred to destination tables |
AR_TA_PAYMNT_HIST_ALL | Stores payment history information for customer-location combination for each period |
AR_TA_PROMOTIONS_ALL | Stores data about promotions |
AR_TA_PROM_CUST_MAP | Contains mapping of the customers defined in the legacy system with those defined in Oracle Financials |
AR_TA_PROM_CUST_ALL | Stores legacy customers, for imported promotion data along with corresponding Oracle customers |
AR_TA_PROM_PAYMNT_ALL | Stores payment allowance details for promotions |
AR_TA_PROM_PAYMNT_TYP | Defines the type of allowance for promotions |
AR_TA_PROM_LINES_INT | Interface table that contains imported promotion details about products, payments (allowances), or customers, that were not validated or transferred to destination tables |
AR_TA_PROM_PRODS_ALL | Stores product details for promotions |
AR_TA_PROM_STATUS_MAP | Contains mapping of promotion statuses defined in the legacy system with those defined in Oracle Financials |
AR_TA_RECON_INFO_ALL | Temporary table used by the AutoReconciliation report |
AR_TA_RISK_COMENT_ALL | Comments associated with customer-location combination |
AR_TA_REMIT_PROF_ALL | Stores setup information about customer remittance processing |
AR_TA_RECV_TRXSET_ALL | Stores association of Transaction Sets with Receivable accounts |
AR_TA_RULES_ALL | Details of all rules that are used by the Cash Engine to match receipt lines to transactions in the database |
AR_TA_RULE_SETS_ALL | Details of the rule sets defined in Trade Accounting |
AR_TA_REMIT_HIST_ALL | Contains the application details of all Receipts and Receipt lines processed by the Cash Engine |
AR_TA_RULE_OUTPUT | Trade Accounting rule output |
AR_TA_RULE_SET_LN_ALL | Details of the transaction types and event types contained in a transaction set |
AR_TA_TRX_SETS_ALL | Details of the transaction sets defined in Trade Accounting |
AR_TA_TRX_SET_LN_ALL | Details of the transaction types and event types contained in a transaction set |
AR_TA_TRX_TYP_INT_ALL | Interface table that stores details about all transaction types; can be used by external Deduction Management Systems. |
AR_TA_TRX_TO_CREATE | Information about the transactions that the Cash Engine needs to create |
AR_TA_VERSIONS | Trade Accounting versions |
AR_TRANSACTION_HISTORY_ALL | Life cycle of a transaction |
AR_TRANSMISSIONS_ALL | Lockbox transmission information |
AR_TRANS_FIELD_FORMATS | Format of each field in a Lockbox transmission format |
AR_TRX_BAL_SUMMARY | This table stores the fields, such as 'Total Invoices Value |
AR_TRANSACTIONS_REP_ITF | Report Exchange interface table for the Receivables Transactions reports |
AR_TRANS_RECORD_FORMATS | Format of a record within a Lockbox transmission format |
AR_UPG_120_CONTROL | This table is used to control ar 12.0 upgrade scripts |
AR_TRX_SUMMARY | This table stores the fields, such as 'Total Invoices Value |
AR_VAT_TAX_ALL_TL | Multi-lingual support (MLS) for each tax code that you define |
AR_VAT_TAX_ALL_B | Tax codes defined in the Tax Codes and Rates window |
AR_TRX_SUMMARY_HIST | This table stores the history of all the modifications, performed on different transactions, which would affect the data in the summary tables. |
HZ_ADAPTER_LOGS | The HZ_ADAPTER_LOGS table tracks requests for service from data integration services providers |
HZ_ADAPTERS | The HZ_ADAPTERS table stores information about the adapters that are configured to provide data integration services |
HZ_ADAPTER_USERS | Stores user information for adapters |
HZ_ADDRESS_USAGES | Contains the address usages per country |
HZ_ADAPTER_TERRITORIES | The HZ_ADAPTER_TERRITORIES table stores information about the countries or territories that are supported for a particular data integration service adapter |
HZ_ADDRESS_USAGE_DTLS | Contains the required geography |
HZ_BUS_OBJ_DEFINITIONS | Stores definitions of TCA business objects |
HZ_BUS_OBJ_TRACKING | Tracks granular (V2) entities for raising Business Object events |
HZ_CERTIFICATIONS | Certifications given to parties |
HZ_BILLING_PREFERENCES | Invoicing format |
HZ_CITIZENSHIP | Person's claimed nationality |
HZ_CLASS_CODE_RELATIONS | Relationships between classification codes |
HZ_CLASS_CATEGORIES | Classification categories for classifying parties and related entities |
HZ_CLASS_CODE_DENORM | Denormalization of the classification code hierarchy |
HZ_CLASS_CATEGORY_USES | Usage of class categories by owner tables |
HZ_CONTACT_PREFERENCES | Stores contact preference information for parties or their addresses and contact points |
HZ_CONTACT_POINTS | Electronic methods of communicating with parties |
HZ_CONTACT_RESTRICTIONS | Restrictions on contacting parties |
HZ_CREDIT_RATINGS | Credit ratings of parties |
HZ_CREDIT_PROFILES | Profiles about a party's credit policy |
HZ_CREDIT_PROFILE_AMTS | Credit limits in specified currency |
HZ_CREDIT_RATINGS_EXT_B | Stores extensible attributes for credit ratings. |
HZ_CREDIT_RATINGS_EXT_TL | Provides multilingual support for extensible credit rating attributes. |
HZ_CREDIT_USAGES | Association between credit limit and credit usage rule set |
HZ_CREDIT_USAGE_RULES | Usage rules assigned to each credit limit |
HZ_CREDIT_USAGE_RULE_SETS_TL | Sets of credit usage rules translated into multiple languages |
HZ_CREDIT_USAGE_RULE_SETS_B | Sets of credit usage rules in the base language |
HZ_CUST_ACCOUNTS_M | This table is used to store the deleted records for HZ_CUST_ACCOUNTS during account merge |
HZ_CUST_ACCOUNT_ROLES_M | This table stores the information of a customer account role from HZ_CUST_ACCOUNT_ROLES table before the account merge happens. The primary key for this table is CUST_ACCOUNT_ROLE_ID, CUSTOMER_MERGE_HEADER_ID. |
HZ_CUST_ACCOUNTS | Stores information about customer accounts. |
HZ_CUSTOMER_MERGE_LOG | This table is used to record account merge audit history |
HZ_CUSTOMER_PROFILES | Credit information for customer accounts and customer account sites |
HZ_CUST_ACCT_RELATE_ALL_M | This table is used to store the deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge |
HZ_CUST_ACCT_RELATE_ALL | Relationships between customer accounts |
HZ_CUST_ACCT_SITES_ALL_M | The HZ_CUST_ACCT_SITES_ALL_M table stores the information of customer profile amounts from HZ_CUST_ACCT_SITES_ALL table before the account merge happens. The primary key for this table is CUST_ACCT_SITE_ID , CUSTOMER_MERGE_HEADER_ID. |
HZ_CUST_ACCOUNT_ROLES | Roles that parties perform in customer accounts |
HZ_CUST_ACCT_SITES_ALL | Stores all customer account sites across all operating units |
HZ_CUST_MERGE_LOG_DICT | This table is used to define the data in hz_customer_merge_log |
HZ_CUST_CONTACT_POINTS | This table is no longer used |
HZ_CUST_PROFILE_AMTS_M | The HZ_CUST_PROFILE_AMTS_M table stores the information of customer profile amounts from HZ_CUST_PROFILE_AMTS table before the account merge happens.The primary key for this table is CUST_ACCT_PROFILE_AMT_ID, CUSTOMER_MERGE_HEADER_ID. |
HZ_CUSTOMER_PROFILES_M | This table is used to store the deleted records for hz_customer_profiles during account merge |
HZ_CODE_ASSIGNMENTS | Intersection table linking industrial classification codes to parties or related entities |
HZ_CUST_PROFILE_AMTS | Stores information about the credit limits specified for a customer's profile. |
HZ_CUST_PROFILE_CLASSES | Standard credit profile classes |
HZ_CUST_PROF_CLASS_AMTS | Customer profile class amount limits for each currency |
HZ_CUST_SITE_USES_ALL_M | The HZ_CUST_SITE_USES_ALL_M table stores the information of customer site uses from HZ_CUST_SITE_USES_ALL table before the account merge happens. The primary key for this table is CUST_SITE_USE_ID , CUSTOMER_MERGE_HEADER_ID. |
HZ_DL_SELECTED_CRITERIA | Stores criteria for selecting parties to include in batches |
HZ_DQM_SH_SYNC_INTERFACE | Stores the list of entities that have been created or updated by the DQM API since the DQM Shadow Staging Program concurrent program was last run. |
HZ_DQM_SYNC_INTERFACE | Stores the list of entities that have been updated by the DQM API. |
HZ_DSS_ASSIGNMENTS | Data sharing group assignments |
HZ_DQM_SETUP_DIAGNOSTICS | Table for storing the Diagnostic Data for reports |
HZ_DNB_REQUEST_LOG | Requests for information from Dun & Bradstreet |
HZ_DQM_STAGE_LOG | This table logs the phases that the DQM Staging Program is at |
HZ_DSS_CRITERIA | Data sharing group criteria |
HZ_DSS_ENTITIES | Entities that can be secured |
HZ_DSS_GROUPS_B | Data Sharing Groups |
HZ_CUST_SITE_USES_ALL | Stores business purposes assigned to customer account sites. |
HZ_DSS_GROUPS_TL | Translation table for HZ_DSS_GROUPS_TL |
HZ_DSS_SECURED_ENTITIES | Entities that are secured by a particular data sharing group |
HZ_DUP_BATCH | Duplicate Identification Batch |
HZ_DUP_EXCLUSIONS | Duplicate Exclusions |
HZ_DUP_MATCH_DETAILS | Match Details |
HZ_DSS_SCHEME_FUNCTIONS | Functions that are used by a particular data security scheme |
HZ_DUP_MERGE_PARTIES | Parties to be Merged |
HZ_DUP_RESULTS | The HZ_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables. The table includes information about the potential from and to parties. Data in this table is only used for t |
HZ_DUP_SET_PARTIES | Parties belonging to a Duplicate Party Set |
HZ_EDUCATION | Person's education information |
HZ_EMAIL_DOMAINS | Entity that holds email domains of organization parties. |
HZ_ENTITY_ATTRIBUTES | Entities and Attribute information used by Third Party Data Integration. |
HZ_DUP_SETS | Duplicate Party Sets |
HZ_EXT_DATA_RULES_TL | Rule Name translation table for Third Party Data Integration. |
HZ_FINANCIAL_PROFILE | Financial accounts of parties |
HZ_FINANCIAL_NUMBERS | Details of financial reports |
HZ_FINANCIAL_REPORTS | Financial reports of parties |
HZ_FIN_NUMBERS_EXT_TL | Provides multilingual support for extensible financial number attributes. |
HZ_FIN_REPORTS_EXT_B | Stores extensible attributes for financial reports. |
HZ_GEOGRAPHIES | The HZ_GEOGRPHIES table stores data representing physical geographies. |
HZ_FIN_REPORTS_EXT_TL | Provides multilingual support for extensible financial report attributes. |
HZ_GEOGRAPHY_IDENTIFIERS | HZ_GEOGRPHY_IDENTIFIERS stores multiple identifiers used to describe the same geography. |
HZ_GEOGRAPHY_TYPES_TL | HZ_GEOGRPHY_TYPES_TL stores Geography Types in MLS languages. |
HZ_GEOGRAPHY_RANGES | Stores ranges associated with a given geography. |
HZ_GEO_NAME_REFERENCE_LOG | Stores the mapping log between location elements and Master Reference geography elements based on Geography Name Matching. |
HZ_FIN_NUMBERS_EXT_B | Stores extensible attributes for financial numbers. |
HZ_GEO_STRUCT_MAP_DTL | The HZ_GEO_STRUCT_MAP_DTL table stores the actual mapping of location component and geography type for the details defined in the HZ_GEO_STRUCT_MAP table. |
HZ_GEO_STRUCTURE_LEVELS | Stores the geographical hierarchical structures. |
HZ_GEO_STRUCT_MAP | The HZ_GEO_STRUCT_MAP table stores the map attributes for which a mapping of location components and geography types are defined. |
HZ_GEO_NAME_REFERENCES | Stores the mapping between location elements and Master Reference geography elements based on Geography Name Matching. |
HZ_IMP_ADAPTERS | The HZ_IMP_ADAPTERS table stores information about using location services adapters to validate addresses in the interface tables before importing to the TCA Registry. The table includes the countries that the user chooses to validate, the |
HZ_HIERARCHY_NODES | Contains denormalized data for hierarchical relationships. |
HZ_IMP_ADDRESSES_SG | TCA internal table for processing information loaded into the HZ_IMP_ADDRESSES_INT |
HZ_GEOGRAPHY_TYPES_B | HZ_GEOGRPHY_TYPES_B stores Geography Type classification for geographies: both Master Reference Geography Types and non-Master Reference Geography Types. |
HZ_IMP_ADDRESSUSES_INT | TCA import table for HZ_PARTY_SITE_USES |
HZ_IMP_ADDRESSES_INT | TCA import table for HZ_LOCATIONS and HZ_PARTY_SITES |
HZ_IMP_ADDRESSUSES_SG | TCA internal table for processing information loaded into the HZ_IMP_ADDRESSUSES_INT |
HZ_IMP_BATCH_DETAILS | The HZ_IMP_BATCH_DETAILS table stores detail information about imports of records from the interface tables to the TCA Registry. The table includes the number of times that the batch has run, the import status, and the request identifier of |
HZ_IMP_CLASSIFICS_SG | TCA internal table for processing information loaded into the HZ_IMP_CLASSIFICS_INT |
HZ_IMP_BATCH_SUMMARY | The HZ_IMP_BATCH_SUMMARY table stores information about import batches |
HZ_IMP_CONTACTPTS_SG | TCA internal table for processing information loaded into the HZ_IMP_CONTACTPTS_INT |
HZ_IMP_CONTACTPTS_INT | TCA import table for HZ_CONTACT_POINTS |
HZ_EMPLOYMENT_HISTORY | Person's employment information |
HZ_IMP_CLASSIFICS_INT | TCA import table for HZ_CODE_ASSIGNMENTS |
HZ_IMP_CREDITRTNGS_INT | TCA import table for HZ_CREDIT_RATINGS |
HZ_IMP_CONTACTROLES_INT | TCA import table for HZ_ORG_CONTACT_ROLES |
HZ_IMP_CONTACTROLES_SG | TCA internal table for processing information loaded into the HZ_IMP_CONTACTROLES_INT |
HZ_IMP_CONTACTS_SG | TCA internal table for processing information loaded into the HZ_IMP_CONTACTS_INT |
HZ_IMP_CREDITRTNGS_SG | TCA internal table for processing information loaded into the HZ_IMP_CREDITRTNGS_INT |
HZ_IMP_DUP_PARTIES | This table holds the ID's of the parties that matched the given match rule criteria, along with their scores, and if any party crossed the auto merge threshold and should be auto merged |
HZ_IMP_DUP_DETAILS | No Comments |
HZ_IMP_ERRORS | TCA import table used to record error found during the import process |
HZ_IMP_FINREPORTS_SG | TCA internal table for processing information loaded into the HZ_IMP_FINREPORTS_INT |
HZ_IMP_FINNUMBERS_SG | TCA internal table for processing information loaded into the HZ_IMP_FINNUMBERS_INT |
HZ_IMP_FINREPORTS_INT | TCA import table for HZ_FINANCIAL_REPORTS |
HZ_IMP_FINNUMBERS_INT | TCA import table for HZ_FINANCIAL_NUMBERS |
HZ_IMP_OSR_CHANGE | TCA internal table for processing information loaded into the |
HZ_IMP_PARTIES_INT | TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES |
HZ_IMP_INT_DEDUP_RESULTS | The HZ_IMP_INT_DEDEUP_RESULTS table stores the set of duplicates identified as part of the duplicate identification of interface tables. Each set is identified by a unique "winner" record that should remain if the other duplicates in the se |
HZ_IMP_TMP_ERRORS | TCA import table used during runtime to record errors found during import process |
HZ_IMP_RELSHIPS_INT | TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES |
HZ_IMP_PARTIES_SG | TCA internal table for processing information loaded into the HZ_IMP_PARTIES_INT |
HZ_IMP_TMP_REL_END_DATE | TCA internal table for storing relationships to be end dated during bulk import |
HZ_IMP_WORK_UNITS | TCA import table used to manage work units during the import process |
HZ_IMP_RELSHIPS_SG | TCA internal table for processing information loaded into the HZ_IMP_RELSHIPS_INT |
HZ_INDUSTRIAL_REFERENCE | Industrial references for organizations |
HZ_INT_DUP_RESULTS | The HZ_INT_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables. The table includes information about the source identifiers and source systems of the party records in th |
HZ_IMP_CONTACTS_INT | TCA import table for HZ_PARTIES, HZ_RELATIONSHIPS and HZ_ORG_CONTACTS |
HZ_LOCATIONS_EXT_B | Stores extensible attributes for locations. |
HZ_LOCATIONS_EXT_TL | Provides multilingual support for extensible location attributes. |
HZ_LOCATIONS | Physical addresses |
HZ_LOCATION_PROFILES | The HZ_LOCATION_PROFILES table stores information, including a history of any changes and address validations for a subset of attributes from the HZ_LOCATIONS table |
HZ_LOC_ASSIGNMENTS | Relationship between a location and a tax authority defined in AR_LOCATION_COMBINATIONS |
HZ_MATCH_RULES_B | Stores information about match rules. |
HZ_LOG2 | No longer used. |
HZ_LOC_ASSIGNMENTS_OBS | No longer used in R12. |
HZ_MATCH_RULE_CONDITIONS | Stores information conditions and match rules in match rule sets |
HZ_MATCH_RULE_PRIMARY | Stores information about primary attributes in a match rule. |
HZ_MATCH_RULE_SECONDARY | Stores information about secondary attributes in a match rule. |
HZ_MERGE_DICTIONARY | Tables affected by party merge concurrent program |
HZ_MERGE_BATCH | Party Merge batch header information |
HZ_MATCH_RULES_TL | Stores translated information about match rules. |
HZ_MERGE_ENTITY_ATTRIBUTES | Attribute level merge information for Party Merge |
HZ_MERGE_PARTYDTLS_SUGG | Suggested default details for operations performed on the records for merge |
HZ_MERGE_PARTIES_SUGG | Suggested default information of party merge batch details |
HZ_MERGE_PARTY_DETAILS | Details regarding operations performed on the records |
HZ_MERGE_PARTY_HISTORY | History of records affected by Party Merge operation |
HZ_MERGE_PARTIES | Party Merge batch detail information |
HZ_ORG_CONTACT_ROLES | Roles played by organization contacts |
HZ_ORG_CONTACTS | People as contacts for parties |
HZ_NON_PURGE_CANDIDATES | Stores the parties that have not been identified for purge along with denormalized information about the parties. |
HZ_ORGANIZATION_PROFILES | Detailed information about organizations |
HZ_MERGE_PARTY_LOG | Information about the Party Merge operation |
HZ_ORGANIZATION_INDICATORS | Indicators related to finance, legal, and business standing for business sites |
HZ_ORG_PROFILES_EXT_SG | Staging table for copying extensions data for organization profile versioning. |
HZ_ORG_PROFILES_EXT_TL | Provides multilingual support for extensible organization attributes. |
HZ_ORIG_SYSTEMS_B | Stores basic source system information |
HZ_MOBILE_PREFIXES | Mobile telephone number prefixes based on country |
HZ_ORIG_SYSTEMS_TL | Provides multilingual support for source system information |
HZ_PARAM_TAB | No longer used |
HZ_ORIG_SYS_MAPPING | The HZ_ORIG_SYS_MAPPING table stores the mapping among source systems and owner table names. |
HZ_ORIG_SYS_REFERENCES | The HZ_ORIG_SYSTEM_REFERENCES table stores the mapping between source system references and the owner tables. |
HZ_ORG_PROFILES_EXT_B | Stores extensible attributes for organizations. |
HZ_PARTY_RELATIONSHIPS | Relationships between parties |
HZ_PARTIES | Information about parties such as organizations, people, and groups |
HZ_PARTY_PREFERENCES | Party Preferences |
HZ_PARTY_INTERFACE | Information about party retrieved from external source |
HZ_PARTY_INTERFACE_ERRORS | Information about API errors |
HZ_PARTY_SITES_EXT_B | Stores extensible attributes for party sites. |
HZ_PARTY_SITES_EXT_TL | Provides multilingual support for extensible party site attributes. |
HZ_PARTY_SITE_USES | The way that a party uses a particular site or address |
HZ_PARTY_USAGES_TL | Provides multilingual support for party usage definitions. |
HZ_PARTY_SITES | Links party to physical locations |
HZ_PERSON_INTEREST | Information about a person's personal interests |
HZ_PARTY_USAGE_RULES | Stores party usage rules. |
HZ_PERSON_LANGUAGE | Languages that a person speaks, reads, or writes |
HZ_PARTY_USAGES_B | Stores party usage definition. |
HZ_PER_PROFILES_EXT_SG | Staging table for copying extensions data for person profile versioning. |
HZ_PER_PROFILES_EXT_TL | Provides multilingual support for extensible person attributes. |
HZ_PARTY_USG_ASSIGNMENTS | Stores information about party usage assignments. |
HZ_PRIMARY_TRANS | Stores information about transformation for the primary attributes. |
HZ_PER_PROFILES_EXT_B | Stores extensible attributes for persons. |
HZ_PHONE_AREA_CODES | Telephone number area codes based on country |
HZ_PHONE_COUNTRY_CODES | Country-specific phone number information |
HZ_PHONE_FORMATS | Country-specific phone number formats |
HZ_PURGE_BATCHES | Stores the Batches that have been created for purge. |
HZ_PURGE_CANDIDATES | Stores the parties that have been identified for purge along with denormalized information about the parties. |
HZ_REFERENCES | References given for parties |
HZ_REG_VERIFICATIONS | HZ_REG_VERIFICATIONS serves as an audit table for each access verification question generated during the registration process. |
HZ_RELATIONSHIPS | Relationships between entities |
HZ_REGISTRATIONS | Stores registration attempts for each unique user and access domain combination. |
HZ_ROLE_RESPONSIBILITY | Responsibilities for parties related to their roles in the accounts |
HZ_RELATIONSHIP_TYPES | Relationship types |
HZ_SECURITY_ISSUED | Financial instruments issued by an organization |
HZ_SECONDARY_TRANS | Stores information about transformation for the secondary attributes. |
HZ_SRCH_CONTACTS | This table stores the transformed data for the contacts in the interface tables. |
HZ_SRCH_PARTIES | This table stores the transformed data for the parties in the interface tables. |
HZ_SRCH_PSITES | This table stores the transformed data for the addresses in the interface tables. |
HZ_SRCH_CPTS | This table stores the transformed data for the contact points in the interface tables. |
HZ_STAGED_CONTACTS | Contact information that is staged for DQM. |
HZ_STAGED_CONTACT_POINTS | Contact point information that is staged for DQM. |
HZ_STAGED_PARTY_SITES | Party Site information that is staged for DQM. |
HZ_STOCK_MARKETS | Exchanges for buying and selling financial instruments |
HZ_STAGED_PARTIES | Party information that is staged for DQM. |
HZ_STYLES_B | Styles to classify formats. |
HZ_STYLES_TL | Translation table for HZ_STYLES_B |
HZ_STYLE_FMT_LAYOUTS_B | Layout of particular style format Variation components. |
HZ_STYLE_FMT_LOCALES | Specific locations for style formats. |
HZ_STYLE_FMT_LAYOUTS_TL | Translation table for HZ_STYLE_FMT_LAYOUTS_B |
HZ_SELECT_DATA_SOURCES | Selected data sources for Third Party Data Integration. |
HZ_STYLE_FORMATS_B | Specific formats valid for one or more locations. |
HZ_STYLE_FMT_VARIATIONS | Variations in layout for style formats. |
HZ_STYLE_FORMATS_TL | Translation table for HZ_STYLE_FORMATS_B. |
HZ_SUSPENSION_ACTIVITY | The point in time that a service is no longer provided |
HZ_THIRDPARTY_RULE | Overwrite rules for specific attributes for Third Party Data Integration. |
HZ_THIRDPARTY_EXCEPS | Exceptions to overwrite rules for specific attributes of specific parties for Third Party Data Integration. |
HZ_TIMEZONES_TL | Time zone translations |
HZ_TIMEZONE_MAPPING | Mapping of address elements to time zones |
HZ_TRANS_ATTRIBUTES_B | Stores information about the transformations on attributes. |
HZ_TIMEZONES | Time zone information |
HZ_TRANS_ATTRIBUTES_TL | Stores translated information about the transformations on attributes. |
HZ_TRANS_FUNCTIONS_B | Stores transformation functions. |
HZ_TRANS_FUNCTIONS_TL | Stores translated transformation functions. |
HZ_USER_CREATE_RULES | User data creation rules for Third Party Data Integration. |
HZ_USER_OVERWRITE_RULES | User overwrite rules for Third Party Data Integration. |
HZ_WIN_SOURCE_EXCEPS | Stores attribute exception information if data are overwritten contrary to the Third Party Data Integration data source ranking. |
HZ_WORD_REPLACEMENTS | Word replacement rules for Fuzzy Find functionality |
HZ_WORD_RPL_COND_ATTRIBS | Stores attributes associated with word replacement conditions. |
HZ_WORD_RPL_CONDS_B | Stores information about conditions in word replacement lists |
HZ_WORD_LISTS | Word Replacement Lists for Data Quality Management. |
HZ_WORD_RPL_CONDS_TL | Provides multilingual support for word replacement conditions. |
HZ_WORK_CLASS | Classifications or groupings of work activities |
RA_ACCOUNT_COMBINATIONS | Account information for internal Oracle users |
RA_ACCOUNT_DEFAULT_SEGMENTS | AutoAccounting segment information |
RA_ADDRESSES_ALL | Customer address information |
RA_BATCH_SOURCES_ALL | Sources of invoice, credit memo and commitments |
RA_BATCHES_ALL | Invoice batch information |
RA_ACCOUNT_DEFAULTS_ALL | AutoAccounting information |
RA_CM_REQUEST_LINES_ALL | Pending and approved credit memo request lines |
RA_CM_REQUESTS_ALL | Pending and approved credit memo requests |
RA_CONTACT_ROLES | Contact roles |
RA_CUSTOMERS | Customer information |
RA_CUSTOMER_BANKS_INT_ALL | Customer Interface table for customer banks |
RA_CUSTOMERS_INTERFACE_ALL | Customer Interface table |
RA_CUSTOMER_MERGES | Information about customers, addresses, and site uses that are being merged or moved |
RA_CUSTOMER_PROFILES_INT_ALL | Customer Interface table for customer profile information |
RA_CUSTOMER_MERGE_HEADERS | This table is used to store the high level information about an account merge request. |
RA_CUSTOMER_RELATIONSHIPS_ALL | Information about customer relationships |
RA_CUSTOMER_TRX_LINES_ALL | Invoice, debit memo, chargeback, credit memo and commitment lines |
RA_CUSTOMER_TRX_ALL | Header-level information about invoices, debit memos, chargebacks, commitments and credit memos |
RA_CUST_TRX_LINE_GL_DIST_ALL | Accounting records for revenue, unearned revenue and unbilled receivables |
RA_CUST_PAY_METHOD_INT_ALL | Customer Interface table for Payment Methods |
RA_CUST_RECEIPT_METHODS | Payment Methods assigned to a customer and/or customer site |
RA_CUST_TRX_LINE_SALESREPS_ALL | Sales credit assignments for transactions |
RA_GROUPING_TRX_TYPES | Transaction types associated with AutoInvoice grouping rules |
RA_CUST_TRX_TYPES_ALL | Transaction type for invoices, commitments and credit memos |
RA_GROUPING_RULES | AutoInvoice grouping rules |
RA_GROUP_BY_COLUMNS | Table of columns to group by for AutoInvoice grouping rules |
RA_INTERFACE_ERRORS_ALL | Interface data that failed AutoInvoice validation |
RA_INTERFACE_SALESCREDITS_ALL | Sales credit information for transactions imported using AutoInvoice |
RA_GROUP_BYS | Columns to group by for each grouping rule and transaction type |
RA_ITEM_EXCEPTION_RATES | Product tax rate exceptions |
RA_LINE_ORDERING_RULES | AutoInvoice line ordering rules |
RA_LINE_ORDER_BYS | Columns to order by for each AutoInvoice line ordering rule |
RA_INTERFACE_DISTRIBUTIONS_ALL | Accounting distributions for transactions imported using AutoInvoice |
RA_LINE_ORDER_BY_COLUMNS | Table of columns to order by for AutoInvoice line ordering rules |
RA_MC_BATCHES | Currency-related information about invoice batches for each reporting set of books |
RA_MC_CUSTOMER_TRX | Currency-related information about invoice, debit memo, commitment, and credit memo header information |
RA_MC_CUSTOMER_TRX_LINES | Stores currency-related information about transaction lines for each reporting set of books that is associated with the parent record |
RA_MC_TRX_LINE_GL_DIST | Currency and accounting records for revenue, unearned revenue and unbilled receivables |
RA_RECUR_INTERIM | Temporary table that holds invoices to be copied |
RA_PHONES | Telephone and communications information |
RA_REMIT_TOS_ALL | Links remit-to addresses with state and country |
RA_RULES | Invoicing and accounting rules |
RA_RULE_SCHEDULES | Accounting schedules for invoices with rules |
RA_SALESREP_TERRITORIES | Territory information for salespeople |
RA_SALESREPS_ALL | Information about salespeople |
RA_TAX_EXEMPTIONS_ALL | Percentage that a customer, site, or item is exempt from a tax code |
RA_SITE_USES_ALL | Business purpose of a customer address |
RA_CONTACT_PHONES_INT_ALL | Used by Customer Interface to import contact and telephone information |
RA_TERMS_LINES_DISCOUNTS | Discount information for Payment Terms |
RA_TERMS_TL | Multi-lingual support (MLS) for Payment Terms |
RA_TERRITORIES | Territory information |
RA_TERMS_LINES | Line information for Payment Terms |
RA_TERMS_B | Payment Term information |
Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's: Additions API if you have requirement to add assets directly via PL/SQL then use FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using FA_ADJUSTMENT_PUB.DO_ADJUSTMENT for any process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...
Comments
Post a Comment