23Apr/210
Oracle Nukes ETRM
In an announcement affecting may EBS customers, Oracle has stopped hosting the Electronic technical Reference Manual. Anyone who has to reference needs to download around 7gb files and unzip them which are around 47gb to their hard drive. All of these are static files devoid of any search capability hence very hard to use. Very unfortunate move by Oracle. An alternate location that has been hosted is ETRM Backup.
https://blogs.oracle.com/ebstech/update-to-ebs-electronic-technical-reference-manual-etrm
12Jun/150
Urgent Required- IT MNC- Oracle Apps SCM Professionals-Bangalore,Pune,Chennai,Hyderabad
We at Manpower Services, New Delhi have an excellent permanent opportunity for you with one of our TOP IT MNC,
About the Company : -
Its a Global Present company with having more than 60 offices & development centers across Europe, & Asia . Its has more than a lac employees.
Job Description :-
Designation : Lead Consultant /Sr Manager/Sr Architect /Technical Analyst /consultant/analyst
Location of Posting* - Bangalore,Pune,Chennai,
Profile / Skill Sets* :-
Oracle Apps SCM
Ensure design, build and implementation of work product.
Developing reusable components, tools for productivity and quality.
Mentoring and guiding the development teams in implementation with best practices, deployment.
Conduct PoCs to understand the effectiveness of the solution; incorporate feedback into the solution.
Solution benchmarking against the competitors.
Lead & handle Delivery responsibility for a portfolio
Interact with the internal/external stakeholders for weekly operations review and build relationships with the stakeholders.
Implement Quality measures to drive operational efficiencies and articulate the value to the customer.
Responsibilities:-
Understanding Customer Business Processes / Requirements and Analyzing their feasibility with respect to OTM features and functionalities.
Preparation of Project Scope, Business Requirement Blueprint and various Functional Specification Documents
Preparation of Business Process and Application level mapping documents
Configuring and Demonstrating critical end-end business scenarios as part of Conference Room Pilot (CRP) sessions
Assisting Technical team in translating the functional specifications into design specifications
Configuration of various master entities and modelling of customer business requirements as per the application standards
Suggesting innovative, cost and effort effective solution options for addressing various non-standard business requirements
Preparing functional Test Cases and Scenario documents
End-end Functional and Integration testing of various application modules and custom designed components
Training end users on the application functionality/features and assisting them during User Acceptance Testing (UAT) phase.
Providing Go-Live and post-implementation warranty support for resolving any business issues, in accordance with the agreed SLA terms
Analysing feasibility and impact of various Enhancements/Change Requirements (CRs) on existing configurations, before implementing the same
Exp- 3 - 14 Yrs
If you are interested, pls send your profile asap with mentioning following details:
Your % in 10th :
year of passing:-
Which state board:
Your % in 12th :
year of passing:
Which state board:
Your % in graduation :
year of passing:
Which university:
Your % in Post graduation :
year of passing:
Which university:
Name as per passport-
DOB :
Current CTC:
Expected CTC :
Notice period required:
Current Location:
Pan no. or passport no.(For duplicity check):
Did you apply for infosys earlier-(Y/N):
Working on contract /Permanent:
Feel free to contact me for any query and assistance.
Thanks & Regards
Ashwani Jaiswal
Consultant
Experis
Manpower Services India Pvt. Ltd.
M G Road,Gurgaon-122002
Haryana, India
D : +91 1246795457
Ashwani.jaiswal@in.experis.com
http://www.experis.in/
9Apr/150
Account Receivables Tables list oracle r12.2
| 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 |
2Apr/150
General Ledger tables
These are the general ledger module tables and the purpose they are used for
| GL_ACCESS_SETS | Data access set definitions |
| GL_ACCESS_SET_ASSIGNMENTS | Flattened data access set privilege assignments |
| GL_ACCESS_SET_NORM_ASSIGN | Data access set privilege assignments |
| GL_ACCOUNT_HIERARCHIES | Summary/Detail account hierarchies |
| GL_ALLOC_BATCHES | MassAllocations and MassBudget batches |
| GL_ALLOC_HISTORY | History of MassAllocation and MassBudget runs |
| GL_ALLOC_INTERIM_1 | Temporary table for MassAllocations and MassBudgets |
| GL_ALLOC_TARGETS | Temporary table for MassAllocations and MassBudgets |
| GL_APPLICATION_GROUPS | Application product groups that use Oracle General Ledger accounting periods |
| GL_ARCHIVE_DAILY_BALANCES | Archive daily aggregate balances |
| GL_ARCHIVE_HEADERS | Archive journal headers |
| GL_ALLOC_INTERIM_2 | Temporary table for MassAllocations and MassBudgets |
| GL_ALLOC_FORMULAS | MassAllocations and MassBudget formulas |
| GL_ALLOC_INTERIM_3 | Temporary table for MassAllocations and MassBudgets |
| GL_ALLOC_FORMULA_LINES | MassAllocations and MassBudget formula lines |
| GL_ARCHIVE_BATCHES | Archive journal batches |
| GL_ARCHIVE_BALANCES | Archive account balances |
| GL_ARCHIVE_LINES | Archive journal entry lines |
| GL_ARCHIVE_HISTORY | History of the archive and purges of journals and balances |
| GL_AUTOMATIC_POSTING_OPTIONS | Individual automatic posting criteria |
| GL_AUTOMATIC_POSTING_SETS | Sets of automatic posting criteria |
| GL_ARCHIVE_REFERENCES | Archive table for GL_IMPORT_REFERENCES |
| GL_AUTHORIZATION_LIMITS | Journal approval authorization limits for employees |
| GL_AUTO_ALLOC_BATCHES | Assignments of MassAllocation, Mass Budgets, Mass Encumbrances, Recurring Journals or Projects batches to an allocation set |
| GL_AUTO_ALLOC_BATCH_HISTORY | History of all batches included in an allocation set run |
| GL_AUTOREV_CRITERIA_SETS | Journal reversal criteria sets |
| GL_AUTOREVERSE_OPTIONS | Reversal criteria for generating automatic journal reversals |
| GL_AUTO_ALLOC_BAT_HIST_DET | Status of concurrent program submitted for each step in the allocation set |
| GL_AUTO_ALLOC_SETS | Autoallocation set definition for step-down or parallel allocations |
| GL_AUTO_ALLOC_SET_HISTORY | History of allocation set runs |
| GL_AUTO_ALLOC_REV_BATCHES | Reverse journal batches generated by AutoAllocation rollback process |
| GL_BC_DUAL2 | Budgetary control concurrency table |
| GL_BC_EVENT_TIMESTAMPS | Budgetary control events (Summary Templates and Budget Assignment Ranges) |
| GL_BALANCES | Account balances for both detail and summary accounts |
| GL_BALANCES_DELTA | Incremental changes to account balances |
| GL_BALANCES_DELTA_INTERIM | Interim tracking of incremental account balances |
| GL_BC_DUAL | Budgetary control concurrency table |
| GL_BC_OPTIONS | Budgetary control options |
| GL_BC_OPTION_DETAILS | Budgetary control option details |
| GL_BC_PACKETS | Budgetary control queue table |
| GL_BC_PACKETS_HISTS | GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS. |
| GL_BUDGETS | Budget definitions |
| GL_BUDGET_ASSIGNMENTS | Budget organization accounts |
| GL_BC_PACKET_ARRIVAL_ORDER | Budgetary control packet processing sequence |
| GL_BUDGET_ENTITIES | Budget organization definitions |
| GL_BC_PERIOD_MAP | Budgetary control period boundaries |
| GL_BUDGET_FROZEN_RANGES | Frozen account ranges for a budget or budget organization |
| GL_BUDGET_INTERFACE | Upload budget data from external sources |
| GL_BUDGET_ASSIGNMENT_RANGES | Budget organization account ranges |
| GL_BUDGET_BATCHES | Budget formula batches |
| GL_BUDGET_INTERIM | Budget posting interim balances |
| GL_BUDGET_TYPES | Budget type definitions |
| GL_BUDGET_PERIOD_RANGES | Status of budget period ranges (open/not open) |
| GL_CARRYFORWARD_RANGES | Ranges of encumbrance accounts to carry across fiscal years |
| GL_BUDGET_RANGE_INTERIM | Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms |
| GL_CONCURRENCY_CONTROL | Concurrent process internal locking mechanism |
| GL_BUDGET_VERSIONS | Budget version definitions |
| GL_CONCURRENT_SCHEDULES | Oracle General Ledger concurrent schedule definitions |
| GL_COA_MAPPINGS | Chart of accounts mapping definitions |
| GL_CONSOLIDATION_SETS | Consolidation sets |
| GL_CONS_BATCHES | Transaction method consolidation batches |
| GL_CONSOLIDATION | Consolidation definitions |
| GL_CONSOLIDATION_ACCOUNTS | Account ranges for consolidating balances |
| GL_CONSOLIDATION_AUDIT | Audit data for consolidation run |
| GL_CONS_SEGMENT_MAP | Consolidation segment rules |
| GL_CONS_SET_ASSIGNMENTS | Assignments of consolidations to consolidation sets |
| GL_CONSOLIDATION_HISTORY | History of consolidation runs |
| GL_CONS_FLEXFIELD_MAP | Consolidation account rules |
| GL_CONS_FLEX_HIERARCHIES | Consolidation subsidiary segment hierarchies |
| GL_DAILY_BALANCES | Daily aggregate balances for both detail and summary accounts |
| GL_DAILY_CONVERSION_RATES | Foreign currency daily exchange rates |
| GL_CROSS_RATE_RULES | Cross Rate Rules |
| GL_DAILY_RATES_INTERFACE | Import daily conversion rates |
| GL_DATE_PERIOD_MAP | Date to period mappings |
| GL_CROSS_RATE_RULE_DTLS | Cross Rate Rule Details |
| GL_DEFAS_ACCESS_SETS | Definition access set definitions |
| GL_DEFAS_ASSIGNMENTS | Definition access set privilege assignments |
| GL_DAILY_RATES | Daily conversion rates for foreign currency transactions |
| GL_CODE_COMBINATIONS | Account combinations |
| GL_DAILY_CONVERSION_TYPES | Foreign currency daily conversion rate types |
| GL_DEFAS_RESP_ASSIGN | Assignment of definition access sets to responsibilities |
| GL_EFC_BUDGET_MAPPING | Budget and budget organization mappings for Euro as Functional Currency process |
| GL_EFC_CHANGED_TRX | Transactions that need to be reprocessed by the Euro as Functional Currency process |
| GL_DOC_SEQUENCE_AUDIT | Sequential numbering audit table |
| GL_DYNAMIC_SUMM_COMBINATIONS | Newly created summary account combinations |
| GL_EFC_DISABLED_TRIGGERS | Triggers disabled by the Euro as Functional Currency process |
| GL_EFC_RUN_HISTORY | Euro as Functional Currency process history |
| GL_ELIMINATION_HISTORY | Intercompany elimination history |
| GL_ELIMINATION_JOURNALS | Intercompany elimination journals |
| GL_ELIM_ACCOUNTS_MAP | Intercompany elimination account mappings |
| GL_ENTITY_BUDGETS | Freeze budget organizations for particular budgets |
| GL_FIXED_CONV_RATES | Fixed conversion rates for changes in national currency |
| GL_ELIMINATION_SETS | Intercompany elimination set definitions |
| GL_ELIM_BAL_OPTIONS | Intercompany elimination balancing options. |
| GL_HISTORICAL_RATE_RANGES | Historical translation rates account ranges |
| GL_ENCUMBRANCE_TYPES | Encumbrance type definitions |
| GL_EXTRACT_HISTORY | Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract Incremental Balances |
| GL_IEA_AUTOGEN_MAP | Automatic account generation mapping rules for the Global Intercompany System |
| GL_HISTORICAL_RATES | Foreign currency translation rates for historical accounts |
| GL_IEA_CLEARING_ACCOUNTS | Clearing accounts |
| GL_IEA_INTERFACE | Transactional data for import into Global Intercompany System |
| GL_IEA_RECUR_HISTORY | History of recurring intercompany batch runs |
| GL_IEA_SEGMENT_RULE_MAP | Automatic account generation individual segment mapping rules for the Global Intercompany System |
| GL_IEA_SEGMENT_MAP | Automatic account generation segment mapping rules for the Global Intercompany System |
| GL_IEA_IMPORT_REGISTRY | Global Intercompany System import execution control |
| GL_IEA_SUBSIDIARIES | Subsidiary definitions |
| GL_IEA_RECUR_BATCHES | Recurring intercompany batches |
| GL_IEA_RECUR_LINES | Recurring intercompany transaction lines |
| GL_IEA_RECUR_TRANSACTIONS | Recurring intercompany transactions |
| GL_IEA_TRANSACTIONS | Intercompany transactions |
| GL_IEA_TRANSACTION_LINES | Intercompany transaction lines |
| GL_IMPORT_REFERENCES | Cross-references between subledgers and Oracle General Ledger's journal entries |
| GL_IMP_COA_ERR_INTERFACE | Error message interface table for the Chart of Account Segment Values Import process. |
| GL_IMP_COA_SEG_VAL_INTERFACE | Import of Chart of Accounts Segment Values |
| GL_INTERCOMPANY_ACCOUNTS | Assignments of intercompany due to and due from accounts to a source, category, and balancing segment value. |
| GL_IEA_TRANSACTION_TYPES | Intercompany transaction types |
| GL_INTERFACE_CONTROL | Journal import execution control |
| GL_IMP_COA_NORM_HIER_INTERFACE | Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values. |
| GL_ISPEED_COA_SEGMENTS | Chart of Accounts segments information. |
| GL_INTERCOMPANY_ACC_SETS | Intercompany transaction processing rules |
| GL_ISPEED_COA_TEMPLATES | Chart of Accounts template definition. |
| GL_INTERFACE | Import journal entry batches |
| GL_INTERFACE_HISTORY | Imported journal entry batches |
| GL_JE_INCLUSION_RULES | Journal Inclusion rule |
| GL_JE_SEGMENT_VALUES | Journal entry balancing and management segment values. |
| GL_JE_SOURCES_TL | Journal entry sources |
| GL_JE_CATEGORIES_TL | Journal entry categories |
| GL_JE_HEADERS | Journal entry headers |
| GL_JE_LINES | Journal entry lines |
| GL_JE_BATCHES | Journal entry batches |
| GL_JOURNAL_REPORTS_ITF | Interface table for RXi Oracle General Ledger journal reports. |
| GL_LEDGERS | Ledger definition |
| GL_LEDGER_CONFIG_DETAILS | Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup. |
| GL_LEDGER_NORM_SEG_VALS | Valid balancing segment values for ledger |
| GL_LEDGER_SETS | Ledger set definition |
| GL_LEDGER_CONFIGURATIONS | Primary ledgers |
| GL_LEDGER_SET_NORM_ASSIGN | Ledger set assignments |
| GL_LEDGER_RELATIONSHIPS | Relationships between ledgers |
| GL_LEDGER_SEGMENT_VALUES | Flattened valid balancing segment values for ledger |
| GL_LEDGER_SET_ASSIGNMENTS | Flattened ledger set assignments |
| GL_LEDGER_SET_REQUESTS | Ledger set child request status. |
| GL_LEGAL_ENTITIES_BSVS | Legal entity balancing segment value assignments. |
| GL_LOOKUPS_OLD | General Ledger lookups |
| GL_LE_VALUE_SETS | Legal entity value set assignments. |
| GL_MC_BOOK_ASSIGNMENTS | Assignments of reporting sets of books to primary sets of books |
| GL_MC_CONVERSION_RULES | Multiple reporting currency conversion rules for Oracle General Ledger |
| GL_MC_BOOK_ASSIGNMENTS_11I | Assignments of reporting sets of books to primary sets of books |
| GL_MC_UPGRADE_RATES | Exchange rates used for the multiple reporting currency upgrade programs |
| GL_MC_UPGRADE_HISTORY | History of upgrade for each application and reporting set of books |
| GL_MC_REPORTING_OPTIONS_11I | Multiple reporting currency conversion options by application/operating unit/asset book |
| GL_MGT_SEG_UPGRADE | Management segment upgrade unprocessed journal batches. |
| GL_MC_CONVERSION_RULES_11I | Multiple reporting currency conversion rules for Oracle General Ledger |
| GL_MC_REPORTING_OPTIONS | Multiple reporting currency conversion options by application |
| GL_MGT_SEG_UPGRADE_H | History of management segment upgrade. |
| GL_MOVEMERGE_ACCOUNTS | Mass maintenance request account mappings |
| GL_NET_INCOME_ACCOUNTS | Net income accounts |
| GL_OASIS_FIN_ASSIGNMENTS | Natural account value mappings for financial items |
| GL_OASIS_FIN_ASSIGNMENTS_11I | Natural account value mappings for financial items |
| GL_OASIS_FIN_ITEMS | Financial items |
| GL_OASIS_FIN_ITEMS_11I | Financial items |
| GL_OASIS_FIN_METRICS | The new table stores the summarized financial metrics. |
| GL_OASIS_FIN_METRICS_11I | Summarized financial metrics |
| GL_MOVEMERGE_REQUESTS | Mass maintenance request definitions |
| GL_OASIS_SUMMARY_DATA | Summarized financial data needed for Business Intelligence System reports |
| GL_PERIODS | Calendar period definitions |
| GL_PERIOD_SETS | Calendar definitions |
| GL_PERIOD_STATUSES | Calendar period statuses |
| GL_PERIOD_TYPES | Calendar period types |
| GL_POSTING_INTERIM | Posting interim balances |
| GL_RECURRING_BATCHES | Recurring journal entry and budget formula batches |
| GL_RECURRING_HEADERS | Recurring journal entry and budget formula headers |
| GL_REVALUATION | Revaluation default gain/loss account |
| GL_RECURRING_LINES | Recurring journal entry and recurring budget formula target lines |
| GL_RECURRING_LINE_CALC_RULES | Recurring journal entry and budget formula lines |
| GL_REVALUATIONS | Revaluation definitions |
| GL_REVALUATION_ACCOUNTS | Revaluation account ranges |
| GL_ROLLUP_GROUP_SCORES | Rollup group usages |
| GL_ROW_MULTIPLIERS | Constant row multipliers |
| GL_RX_TRIAL_BALANCE_ITF | Interface table for country-specific trial balance reports |
| GL_SEGMENT_FREQUENCIES | Segment value and period usages |
| GL_SEGVAL_INHERIT_HISTORY | Segment value inheritance history |
| GL_REVAL_ACCOUNT_RANGES | Revaluation account ranges |
| GL_SHARES_ACTIVITY | Stock split or dividend |
| GL_SHARES_OUTSTANDING | Number of shares outstanding |
| GL_STAT_ACCOUNT_UOM | Statistical units of measure |
| GL_STORAGE_PARAMETERS | Interim table storage parameters |
| GL_SETS_OF_BOOKS | Set of books definitions |
| GL_SUMMARY_HIERARCHY_INT | Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates |
| GL_SUMMARY_INTERIM | Temporary table for Summarization |
| GL_SETS_OF_BOOKS_11I | Set of books definitions |
| GL_SUMMARY_HIERARCHIES | Child segment value ranges for summary templates |
| GL_SYSTEM_SETUP | System setup information |
| GL_SUMMARY_TEMPLATES | Summary account templates |
| GL_SYSTEM_SETUP_11I | System setup information |
| GL_SYSTEM_USAGES | System feature usage |
| GL_SUSPENSE_ACCOUNTS | Additional suspense accounts for source/category combinations |
| GL_TAX_OPTIONS | Setup tax options |
| GL_TAX_OPTION_ACCOUNTS | Setup tax options for natural account values |
| GL_TEMPORARY_COMBINATIONS | Newly created account combinations |
| GL_TRACK_DELTA_BALANCES | GL_TRACK_DELTA_BALANCES stores information about requests to track incremental balances using the GL_BALANCES_DELTA table. |
| GL_TRANSACTION_DATES | Business vs. non-business days for transaction calendars |
| GL_TRANSACTION_CALENDAR | Transaction calendar definitions |
| GL_TRANSACTION_RATE_EXCEPTIONS | No longer used |
| GL_UPDATE_RECOVERY_H | Updated columns history for update recovery |
| GL_TRANSLATION_RATES | Foreign currency translation rates |
| GL_TRANSLATION_INTERIM | Foreign currency translated interim balances |
| GL_TRANSLATION_RATES_11I | Foreign currency translation rates |
| GL_TRANSLATION_STATUSES | Foreign currency translation status of periods |
| GL_TRANSLATION_TRACKING | Foreign currency translation history |
| GL_USSGL_ACCOUNT_PAIRS | USSGL account pairings |
| GL_USSGL_TRANSACTION_CODES | USSGL transaction codes |
| GL_XFR_CALENDAR_MAPPINGS | This table is used to store calendar mappings between EBS and Fusion ledger. |
| GL_XFR_CCID_MAPPINGS | This table contains the account mappings for each period for a ledger mapping. |
| GL_XFR_INTERFACE | This table is a custom version of the gl_interface table for use by the balance transfer. |
| GL_WEIGHTED_AVG_DETAILS | No longer used |
| GL_XFR_LEDGER_BSV_MAPS | Stores specific Balancing segment values of a Fusion Ledger that can be used for booking balances by the external instances. |
| GL_XFR_LED_MAP_PERIODS | This table contains the transfer information for each period that has been transferred for a ledger mapping. |
| GL_XFR_PERIOD_MAPPINGS | Uses Calendar Mapping Id and stores mapping between EBS periods to Fusion Periods. |
| GL_XFR_LEDGER_MAPPINGS | This table is used to store ledger mappings between EBS and Fusion ledger. |
| GL_XFR_SOURCE_SYSTEMS | Stores the list of External Instances with URL info that will be used to drill down from Fusion GL balances to the external instance |
| GL_XFR_SYSTEM_LEDGERS | Stores the list of Fusion Ledgers with their corresponding BSV assignment type. |
| GL_XFR_TRACKING | This table contains the tracking information that Golden Gate will use to launch Journal Import. |
2Apr/150
Account Payables Tables
These are the account payables tables and their functions
| AP_1096_DATA_ALL | Summary payment information for 1099 type suppliers |
| AP_1099_TAPE_DATA_ALL | Supplier payment amounts by MISC type for 1099 reports on magnetic media |
| AP_ACCOUNTING_EVENTS_ALL | Accounting events table |
| AP_AE_HEADERS_ALL | Accounting entry headers table |
| AP_AGING_PERIODS | Aging period definitions |
| AP_AGING_PERIOD_LINES | Individual aging period information |
| AP_ALLOCATION_RULES | AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each record in this table indicates the type of allocation rule that will be generated. The available rule ty |
| AP_ALLOCATION_RULE_LINES | AP_ALLOCATION_RULE_LINES contains the records that establish which percentage and/or amount of a charge line is to be allocated to a specific item line. Allocation rule lines are created as children of an allocation rule, which is stored |
| AP_AUD_AUDIT_REASONS | This table stores the reasons why an expense report is audited. |
| AP_AUD_QUEUES | This table stores a list of expense reports for auditing along with their assignments to auditors. |
| AP_APINV_APPROVERS | This table connects approvers to their invoice components, either theinvoice header or the invoice line. The records are created during the InvoiceApproval Workflow process. |
| AP_AUD_AUDITORS | This table stores the auditor information |
| AP_AUD_AUDIT_REASONS_ARC | OIE Archive Table for Audit Reasons |
| AP_AUD_AUTO_AUDITS | This table stores an audit list. |
| AP_AUD_RULE_ASSIGNMENTS_ALL | This table stores the rule set assignments for organizations. |
| AP_AUD_RULE_SETS | This table stores the audit rule set information. |
| AP_AUD_WORKLOADS | This table stores auditor workloads assigned to auditors for various periods. |
| AP_AWT_TEMP_DISTRIBUTIONS_ALL | Withholding tax temporary distributions |
| AP_AWT_BUCKETS_ALL | Summary amount of tax withheld to date for a particular supplier site |
| AP_BANK_CHARGES | Bank charges definition information |
| AP_AWT_GROUP_TAXES_ALL | Withholding group taxes |
| AP_AWT_GROUPS | Withholding tax groups |
| AP_AWT_TAX_RATES_ALL | Withholding tax rates |
| AP_BANK_CHARGE_LINES | Ranges for bank charges and tolerance limits |
| AP_BATCHES_ALL | Summary invoice batch information |
| AP_BANK_TRANSMISSIONS | This table corresponds to the Transmission Window. |
| AP_CARD_DETAILS | New Card Details |
| AP_CARDS_ALL | Information about credit cards issued to employees |
| AP_CARD_CODES_ALL | Information for credit card codes that you define |
| AP_CARD_GL_SETS_ALL | Descriptive information about credit card GL account sets |
| AP_CARD_PARAMETERS | Card Expense Type Mappings |
| AP_CARD_CODE_SETS_ALL | Descriptive information about credit card code sets assigned to and used by card programs |
| AP_CARD_PROFILES_ALL | Information about the profiles assigned to credit cards distributed to your employees |
| AP_CARD_PROFILE_LIMITS_ALL | Reserved for a future feature |
| AP_CARD_PROGRAMS_ALL | Information about credit card programs you have defined |
| AP_CARD_EMP_CANDIDATES | New Card Employee Candidates |
| AP_CARD_CURRENCIES | The AP_CARD_CURRENCIES table is used to convert numeric currency values to the ISO currency code for Oracle Internet Expenses credit card transactions |
| AP_CARD_GL_ACCTS_ALL | Information about the GL accounts and descriptions for credit card GL account sets |
| AP_CARD_SUPPLIERS_ALL | This table contains all of the information relating to the supplier, supplier site, and credit card. |
| AP_CHECKRUN_CONC_PROCESSES_ALL | Temporary table for tracking payment batch concurrent programs |
| AP_CARD_REQUESTS_ALL | Reserved for a future feature |
| AP_CC_ACCEPTORS | This table stores information about credit card acceptors who provide detail-level transaction information. |
| AP_CHECK_INTEGERS | No Longer Used |
| AP_CC_TRX_DETAILS | This table stores detail-level credit card transaction information. |
| AP_CC_TRX_DETAILS_ARC | Archive table for CC Trx Details |
| AP_CHECK_TRANSMISSIONS | Temporary table containing payment information used for posting to the general ledger |
| AP_CHECKRUN_CONFIRMATIONS_ALL | Temporary table for payment batch confirmations |
| AP_CHECKS_ALL | Supplier payment data |
| AP_CHECK_FORMATS | No Longer Used |
| AP_CHECK_STOCKS_ALL | No Longer Used |
| AP_CHRG_ALLOCATIONS_ALL | No longer used |
| AP_CREDIT_CARD_TRXNS_ARC | OIE Archive Table for Credit Card Transactions |
| AP_CURRENCY_GROUP | Payment currencies for the Payment Process Request Template or the Payment Process Request. |
| AP_DOC_SEQUENCE_AUDIT | Voucher numbers assigned to invoices and payments |
| AP_CREDIT_CARD_TRXNS_ALL | Detailed information about the credit card transactions of your employees |
| AP_DBI_LOG | Log table to track the operations on Payables transaction tables relevant to the Daily Business Intelligence product. |
| AP_DISTRIBUTION_SET_LINES_ALL | Individual Distribution Set line definitions |
| AP_DISTRIBUTION_SETS_ALL | Invoice Distribution Set definitions |
| AP_DUPLICATE_VENDORS_ALL | Supplier information used by Supplier Merge |
| AP_ENCUMBRANCE_LINES_ALL | Encumbrance lines table |
| AP_EXPENSE_PARAMS_ALL | This table stores the Internet Expenses parameters for organizations. |
| AP_EXPENSE_REPORT_HEADERS_ARC | OIE Archive Table for Expense Report Headers |
| AP_EXPENSE_REPORT_LINES_ARC | OIE Archive Table for Expense Report Lines |
| AP_EXPENSE_FEED_DISTS_ALL | Accounting information for credit card transactions |
| AP_EXPENSE_FEED_LINES_ALL | Detailed information about credit card transactions imported from the credit card issuer |
| AP_EXP_LOCATIONS | Physical Address |
| AP_EXPENSE_REPORTS_ALL | Descriptive information about expense report templates |
| AP_EXPENSE_REPORT_HEADERS_ALL | Header information about employee expense reports |
| AP_EXPENSE_REPORT_LINES_ALL | Expense item information for employee expense reports |
| AP_EXPENSE_REPORT_PARAMS_ALL | Expense type information for expense report templates |
| AP_EXP_REPORT_DISTS_ALL | Expense distributions |
| AP_EXP_REPORT_DISTS_ARC | OIE Archive Table for Expense Report Distributions |
| AP_HISTORY_INVOICES_ALL | Summary information about purged invoices |
| AP_HISTORY_INV_PAYMENTS_ALL | Relationships between purged invoices and invoice payments |
| AP_FLEX_SEGMENT_MAPPINGS_ALL | Accounting Flexfield segment sequences used for Expense Distribution Detail Report |
| AP_HISTORY_CHECKS_ALL | Summary information about purged invoice payments |
| AP_INCOME_TAX_TYPES | 1099 supplier types |
| AP_HOLDS_ALL | Invoice hold information |
| AP_HOLD_CODES | Invoice hold and release codes |
| AP_INTEREST_PERIODS | Interest rates and period information used to create Interest invoices |
| AP_INCOME_TAX_REGIONS | Income tax region information for supplier tax reporting purposes |
| AP_INTERFACE_CONTROLS | Temporary table for importing invoices from the open interface tables |
| AP_INTERFACE_REJECTIONS | Information about data that could not be loaded by Payables Open Interface Import |
| AP_INVOICES_INTERFACE | Information used to create an invoice using Payables Open Interface Import |
| AP_INVOICES_UPG_CONTROL | AP_INVOICES_UPG_CONTRO is used to maintain the record of pre-upgrade programs submitted and their progress. |
| AP_INVOICE_KEY_IND_ALL | Compiled invoice information for Key Indicators Report |
| AP_INVOICE_DISTRIBUTIONS_ALL | Invoice distribution line information |
| AP_INVOICE_LINES_ALL | AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. |
| AP_INVOICE_LINES_INTERFACE | Information used to create one or more invoice distributions |
| AP_INVOICE_PAYMENTS_ALL | Invoice payment records |
| AP_INVOICES_ALL | Detailed invoice records |
| AP_INVOICE_PREPAYS_ALL | Invoice prepayment records |
| AP_INVOICE_RELATIONSHIPS | Relationships between invoices and interest invoices automatically created for overdue invoices |
| AP_INVOICE_TRANSMISSIONS | Temporary table for the invoice information used for posting to the general ledger |
| AP_INV_APRVL_HIST_ALL | AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. |
| AP_LIABILITY_BALANCE | Denormalized information about liability accounting entry lines associated with invoices and payments that have been transferred to GL |
| AP_LINES_UPG_SYNC_DATA | AP_LINES_UPG_SYNC_DATA is used to record the invoice information that are captured through the triggers on the invoice transaction tables. |
| AP_LINE_APRVL_HIST_ALL | AP_LINE_APRVL_HIST_ALL contains the approval and rejection history of each invoice line that passes through the Invoice Approval Workflow's approval phase process. The process inserts a record for each approver assigned to review an invoice |
| AP_INV_SELECTION_CRITERIA_ALL | Payment batch invoice selection criteria |
| AP_LE_GROUP | Legal entities for the Payment Process Request Template or the Payment Process Request. |
| AP_MAP_CODES | QuickCode Map |
| AP_MAP_TYPES_B | Mapping Rules |
| AP_MC_INVOICES | Detailed invoice records in MRC defined reporting currency |
| AP_MC_CHECKS | Supplier payment data in MRC defined reporting currency |
| AP_MC_INVOICE_DISTS | Invoice distribution line information in MRC defined reporting currency |
| AP_MC_INVOICE_PAYMENTS | Invoice payment records in MRC defined reporting currency |
| AP_MAP_TYPES_TL | Translations for AP_MAP_TYPES_B |
| AP_MATCHED_RECT_ADJ_ALL | Tracks receipts that have been modified after invoices have been matched to them |
| AP_MC_PAYMENT_HISTORY | Payment history records in MRC defined reporting currency |
| AP_NEGOTIATION_HIST | Tracks the information changed during negotiation |
| AP_NOTES | This table stores information about notes |
| AP_NOTES_ARC | Archive table for AP Notes |
| AP_NO_MATCH_TRXNS | The AP_NO_MATCH_TRXNS table tracks the matching status of transactions |
| AP_OTHER_PERIOD_TYPES | Recurring invoice, key indicator, and withholding tax period type definitions |
| AP_PAYCARD_TRX_FEE_HEADER | Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This tablecorresponds to the header region of the 'Transaction Fees' window. There will be one row in th |
| AP_PAYCARD_TRX_FEE_LINES | Table AP_PAYCARD_TRX_FEE_LINES stores line level information of the Transaction fees defined for a Payment Card in Oracle Payables. This table corresponds to the lines region of the "Transaction Fees" window. For a unique combination of |
| AP_PAYCARD_TRX_FEE_HEADER_ALL | Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This table corresponds to the header region of the 'Transaction Fees' window.There will be one row in th |
| AP_OTHER_PERIODS | Recurring invoice, key indicator, payment terms, and withholding tax time period definitions |
| AP_PAYMENT_HISTORY_ALL | Maturity and reconciliation history for payments |
| AP_OU_GROUP | Operating units for the Payment Process Request Template or the Payment Process Request. |
| AP_PAYMENT_HIST_DISTS | The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row |
| AP_PAYMENT_DISTRIBUTIONS_ALL | Payment distribution information |
| AP_PAYMENT_KEY_IND_ALL | Compiled payment information for Key Indicators Report |
| AP_PAYMENT_REP_ITF | Payables Interface table for RX payment reports |
| AP_PAYMENT_PROGRAMS | Payment programs used for defining payment formats |
| AP_POL_CAT_OPTIONS_ALL | This table stores category-specific rules. |
| AP_PAYMENT_SCHEDULES_ALL | Scheduled payment information on invoices |
| AP_PAYMENT_TEMPLATES | User Defined Payment Process Request Templates |
| AP_PAY_GROUP | Pay groups for the Payment Process Request Template or the Payment Process Request. |
| AP_PBATCH_SETS_ALL | Payment batch sets |
| AP_PBATCH_SET_LINES_ALL | Payment batch set lines |
| AP_POL_CONTEXT | This table stores user-specific organization context. |
| AP_POL_EXRATE_OPTIONS_ALL | This table stores exchange rate tolerances for policy compliance validation. |
| AP_POL_EXRATE_TOLERANCES | This table stores exchange rate tolerances for policy compliance validation. |
| AP_POL_LOCATIONS_TL | This table stores policy schedule location information. |
| AP_POL_HEADERS | This table stores the policy schedule header information. |
| AP_POL_ITEMIZATIONS | This table stores itemization information for expense types. |
| AP_POL_LINES | This table stores the policy schedule line information. |
| AP_POL_VIOLATIONS_ALL | This table is used to store policy violation information for expensereports. |
| AP_POL_LINES_HISTORY | This table stores the life cycle of a policy schedule line. |
| AP_POL_LOCATIONS_B | This table stores policy schedule location information. |
| AP_POL_VIOLATIONS_ARC | OIE Archive Table for Policy Violations |
| AP_POL_SCHEDULE_OPTIONS | This table stores policy schedule-specific rules. |
| AP_POL_SCHEDULE_PERIODS | This table stores policy schedule period information. |
| AP_PREPAY_APP_DISTS | This table details the distribution of prepayment application invoice distributions to the recipient invoice distribution. Records in this table will be created during the data extraction pre-processing from AP to SLA. The records in th |
| AP_PREPAY_HISTORY_ALL | AP_PREPAY_HISTORY_ALL countains the history of a prepayment which includes its related prepayment applications, prepayment unapplications and prepayment application adjustments. A row is created in APPH when the Prepayment Applied, Prepay |
| AP_PRODUCT_SETUP | AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units. This table contains information such as your default payment terms and payment method. Your Orac |
| AP_R115_UPGRADE | Release 11i upgrade values for FUTURE DATED and MANUAL FUTURE DATED payment methods |
| AP_RECON_CHECK_RESULTS | Temporary storage of payment subtotals used for bank account reconciliation comparison |
| AP_RECON_DETAILS | Temporary storage of header and detail bank reconciliation information |
| AP_RECON_DISTRIBUTIONS_ALL | Reconciliation distributions records |
| AP_PURGE_INVOICE_LIST | Temporary storage of invoice IDs for invoice purge candidates |
| AP_RECON_ERROR_CHK_GROUPS | Bank reconciliation error checking structures used by AutoClear |
| AP_RECON_ERROR_CHK_GROUP_LINES | Associated reconciliation table records used by AutoClear |
| AP_RECON_RECORD_CODES | Bank reconciliation record descriptions used by AutoClear |
| AP_RECON_SUMMARIES | Temporary storage of bank-supplied reconciliation categorized sub-totals |
| AP_RECON_TRANSACTION_CODES | Bank detail reconciliation transaction codes |
| AP_RECON_LOCKS | Temporary table for monitoring AutoClear processes |
| AP_REPORTING_ENTITY_LINES_ALL | Balancing segment information associated with a tax reporting entity |
| AP_RECON_RECORD_SPECS | Bank reconciliation flat file structures used by AutoClear |
| AP_RECURRING_PAYMENTS_ALL | Recurring invoice parameters |
| AP_REPORTING_ENTITIES_ALL | Tax identification information for a tax reporting entity |
| AP_SELECTED_INVOICES_ALL | Temporary storage of invoices selected for payment in a payment batch |
| AP_SELECTED_INVOICE_CHECKS_ALL | No Longer Used |
| AP_SELF_ASSESSED_TAX_DIST_ALL | ap_self_assessed_tax_dist contains self assessed tax distributions |
| AP_SUPPLIER_BALANCE_ITF | Stores records for the AP Supplier Open Balance Letter report |
| AP_SUPPLIER_INT_REJECTIONS | Contains suppliers, sites, contacts rejections information. |
| AP_SUPPLIERS | AP_SUPPLIERS stores information about your supplier level attributes. |
| AP_SUPPLIER_SITES_INT | AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to |
| AP_SUP_SITE_CONTACT_INT | AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th |
| AP_SUPPLIERS_INT | AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp |
| AP_SUPPLIER_SITES_ALL | AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. |
| AP_SYSTEM_PARAMETERS_ALL | Payables system defaults and parameters |
| AP_TAX_DERIVATIONS | No longer used. |
| AP_TAX_RECVRY_RATES_ALL | No longer used |
| AP_TB_BALANCES_TMP | AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date |
| AP_TEMP_APPROVAL_ALL | No longer used |
| AP_TAX_CODES_ALL | Tax code information |
| AP_TERMS_LINES | Detail information about payment terms |
| AP_TOLERANCES_ALL | Matching and invoice variance testing tolerance levels |
| AP_TAX_RECVRY_RULES_ALL | No longer used |
| AP_TRANSMISSIONS_SETUP | No Longer Used |
| AP_TERMS_TL | Payment term definitions |
| AP_TOLERANCE_TEMPLATES | Matching and invoice variance testing tolerance levels |
| AP_TRIAL_BAL | No longer used |
| AP_TRIAL_BALANCE | Denormalized information about posted invoices for your accrual set of books |
| AP_UNSELECTED_INVOICES_ALL | This table holds invoices that could not be paid by a payment batch. |
| AP_USER_EXCHANGE_RATES | User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies. |
| AP_VENDOR_AUDIT_TMP | Temporary table for duplicate supplier candidates during Supplier Merge |
| AP_VENDOR_KEY_IND_ALL | Compiled supplier information for the Key Indicators Report |
| AP_WEB_ACCFLEX_SEGMENTS | Accounting flexfield setup. |
| AP_WEB_AMEX_PARAMS | Download parameters for American Express |
| AP_WEB_EMPLOYEE_INFO_ALL | This table is used to store employee information. |
| AP_WEB_PREFERENCES | Stores the user preferences for Oracle Internet Expenses. |
| AP_WEB_SIGNING_LIMITS_ALL | Tracks signing limit authority for Self-Service Expenses-entered expense reports |
| AP_WEB_VAT_SETUP_ALL | This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant fields on the Expense Line Details page. |
| AP_WHT_ITF | Information for the submission of the AP Withholding Tax extract program |
| FINANCIALS_PURGES | Invoice purge selection criteria and purged invoice statistical data |
| AP_WEB_PROXY_ASSIGNMENTS | Stores reporting access rights relationships. |
| FINANCIALS_PURGES_ALL | Invoice purge selection criteria and purged invoice statistical data |
| OIE_ADDON_MILEAGE_RATES | This table stores additional information for a mileage expense type. |
| OIE_ADDON_MILEAGE_RATES_ARC | OIE Archive Table for Add on Mileag Rates |
| OIE_ALLOCATION_PREFS | User Allocation Preferences |
| OIE_ATTENDEES_ALL | Holds the attendee and recipient data for the current expense type. |
| FINANCIALS_SYSTEM_PARAMS_ALL | Oracle Financials system parameters and defaults |
| OIE_ATTENDEES_ARC | OIE Archive Table for Attendee Information |
| OIE_ATTENDEE_GROUPS | Table to hold the Attendee Groups that are created by the users |
| OIE_ATTENDEE_GROUP_DETAILS | OIE Attendee Group Details |
| OIE_CURRENT_PAGE_SETTING | This table stores the current setting of a region (hide-show, table..) on a page for each user. |
| OIE_DATA_CAPTURE_FIELDS | Stores the field behavior for the data capture rules. |
| OIE_DATA_CAPTURE_OPTIONS | Stores the attendee types enabled for the data capture rules. |
| OIE_DATA_CAPTURE_RULES | Stores the expense type data capture rules. |
| OIE_DUP_DETECT_RULES | OIE Duplicate Detection Rules |
| OIE_DISTRIBUTION_SETS_ALL | Distribution Set Header Table |
| OIE_DUP_DETECT_RS_DETAIL | OIE Duplicate Detection Rule Set Details |
| OIE_DUP_DETECT_RS_SUMMARY | OIE Duplicate Detection Rule Set Summary |
| OIE_DUP_RULE_ASSIGNMENTS_ALL | OIE Duplicate Detection Rule Assignments |
| OIE_PDM_DAILY_BREAKUPS | This table holds per diem data for a rate period. |
| OIE_PDM_DAILY_BREAKUPS_ARC | OIE Archive Table for PerDiem Daily Breakups |
| OIE_PDM_DESTINATIONS_ARC | OIE Archive Table for PerDiem Destinations |
| OIE_POL_RATES_INTERFACE | This table serves as an interface / staging table for uploaded CONUS and OCONUS rates which can be used to generate policy schedules. |
| OIE_SET_DISTRIBUTIONS | Set Distribution Table. |
| OIE_PDM_DESTINATIONS | This table holds per diem destination information. |
31Mar/150
Order workflow statuses
These are the predefined order workflow statuses and their meanings.
| Code | Meaning | Description |
|---|---|---|
| ACTIVE | Active | Active |
| AWAITING_START_DATE | Awaiting Start Date | Awaiting Start Date |
| BOOKED | Booked | Booked |
| CANCELLED | Cancelled | Cancelled |
| CLOSED | Closed | Closed |
| CUSTOMER_ACCEPTED | Customer Accepted | Customer Accepted |
| DEAL_APPROVED | Ready for Deal Update | Ready for Deal Update |
| DEAL_SUBMITTED | Submitted-Deals Workbench | Submitted-Deals Workbench |
| DRAFT | Draft | Draft |
| DRAFT_CUSTOMER_REJECTED | Draft - Customer Rejected | Draft - Customer Rejected |
| DRAFT_INTERNAL_REJECTED | Draft - Internal Rejected | Draft - Internal Rejected |
| DRAFT_SUBMITTED | Draft Submitted | Draft Submitted |
| ENTERED | Entered | Entered |
| EXPIRED | Expired | Expired |
| INTERNAL_APPROVED | Internal Approved | Internal Approved |
| INTERNAL_REJECTED | Internal Rejected | Internal Rejected |
| INVOICED | Invoice Interface - Complete | Invoice Interface - Complete |
| INVOICE_HOLD | Awaiting Invoice Interface - On Hold | Awaiting Invoice Interface - On Hold |
| INVOICE_INCOMPLETE | Awaiting Invoice Interface - Incomplete Data | Awaiting Invoice Interface - Incomplete Data |
| INVOICE_NOT_APPLICABLE | Invoice Interface - Not Applicable | Invoice Interface - Not Applicable |
| LOST | Lost | Lost |
| OFFER_EXPIRED | Offer Expired | Offer Expired |
| PENDING_CUSTOMER_ACCEPTANCE | Pending Customer Acceptance | Pending Customer Acceptance |
| PENDING_INTERNAL_APPROVAL | Pending Internal Approval | Pending Internal Approval |
| PENDING_PRICING_APPROVAL | Pending Pricing Approval | Pending Pricing Approval |
| PRICING_APPROVED | Pricing Approved | Pricing Approved |
| REJECTED_PENDING_CANC | Rejected - Pending Cancellation | Rejected - Pending Cancellation |
| RETURN_REJECTED | Return Rejected | Return Rejected |
| SUBMITTED | Submitted | Submitted |
| TERMINATED | Terminated | Terminated |
| WORKING | User Working | User Working |
31Mar/150
Order Management List of Shipping Statuses
These are the available shipping statuses in oracle apps order management
| Code | Meaning | Description |
|---|---|---|
| CA | Cancelled | Departure is Cancelled |
| CB | Backordered | Delivery is fully Backordered |
| CL | Closed | Departure/Delivery is Closed |
| OP | Open | Departure/Delivery is Open |
| PA | Packed | Delivery is Packed |
| PL | Planned | Departure/Delivery is Planned |
31Mar/150
Places to look for help Oracle Apps
There are many great websites that will help you when you are troubleshooting processes in oracle apps.
The first thing you can do is login to oracle support where they have a log of bugs / issues encountered by other customers. They even have white papers on how to implement modules.
If you want to know the meanings of each columns in a tables and their relations with each entity you can search it on the ETRM.
It has detailed diagrams, entity relations, table descriptions and field descriptions of each fields and schema descriptions. You donot need oracle CSI to access this.
Curently ETRM has table & data dictionary details for 11.5.7, 11.5.8 ,11.5.9, 11.5.10, 12.0, 12.1.1 and 12.2.2 versions. You can search for all lookup types and their codes.
11Jul/140
Accenture Looking for Oracle Apps SCM–OPM Functional-Hyderabad-SSE/TL
Please send your updated resume only forward on sanjay@thinkpeople.in - Please send more references.
Opening with Accenture Services Pvt Ltd.
Skills : Oracle SCM – OPM Functional Professionals
Position: Sr. Snoftware Engineer & Team Leader.
Work Experience : 3.00 years To 10.00 Years
Work Location : Hyderabad
Job Type : Permanent
10Apr/140
Oracle apps vision instance access
These are the websites / companies which provide free access to oracle apps vision instances.
You need and oracle CSI number to get access to these instances
InfoSemantics
http://www.infosemantics.com/oracle-r12-vision-instance/
Solution Beacon
http://www.solutionbeacon.com/
Oracle Contractors
http://www.oraclecontractors.com/home/home.html
you have to register first with them to request access for vision instances.
Recent Posts
- Oracle Nukes ETRM
- Urgent Required- IT MNC- Oracle Apps SCM Professionals-Bangalore,Pune,Chennai,Hyderabad
- Account Receivables Tables list oracle r12.2
- General Ledger tables
- Account Payables Tables
Recent Comments
Archives
- April 2021
- June 2015
- April 2015
- March 2015
- July 2014
- April 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- August 2013
- January 2013
- June 2012
- May 2012
Categories
- Account Payables
- Advanced Pricing
- General Ledger
- implementation
- Inventory
- jobs
- Multi Org
- Oracle apps general
- oracle fnd
- oracle forms
- oracle hrms
- Order Management
- Purchasing
- Receivables
- Uncategorized
- vision instances