Results for “ce_system_parameters_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_RECEIVABLES_TRX_ALL is the Receivables activity accounting definition table in Oracle E-Business Suite, owned by the AR schema. It stores the setup of Receivables activities — the named, reusable accounting rules that determine how specific transaction and receipt events are posted to the General Ledger. Each row represents one activity, such as an autoinvoice line activity, a receipt activity, a chargeback, a late charge, an adjustment, or an unapplied/unearned cash activity. The table carries the account combination, the set of books, activity type and status, effective dates, and optional default accounting distribution set that Receivables uses when generating distributions.

In the documented schema, each activity resolves to a GL code combination and can be referenced by receipt methods, bank account uses, collection system parameters, and, for Brazilian localization, receipt method account extensions. Under a heuristic Data Vault interpretation, AR_RECEIVABLES_TRX_ALL is best modelled as a hub: its business identity is the surrogate RECEIVABLES_TRX_ID, with NAME acting as the business key, and numerous dependent tables referencing it as foreign keys. Descriptive attributes such as description, status, type, and effective dates would typically be split into an accompanying satellite in a dimensional-vault design.

Key Information Stored

• RECEIVABLES_TRX_ID — surrogate primary key (AR_RECEIVABLES_TRX_PK); the unique identifier referenced throughout Receivables.
• NAME — business key and the user-facing activity name (AR_RECEIVABLES_TRX_UK1); also part of unique index AR_RECEIVABLES_TRX_U1 with ORG_ID and ZD_EDITION_NAME.
• TYPE / STATUS — classify the activity (for example receipt, adjustment, chargeback, miscellaneous) and control whether it is active or inactive.
• CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS; the default accounting flexfield used when distributions are created.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I; scopes the activity to a ledger.
• DEFAULT_ACCTG_DISTRIBUTION_SET — foreign key to AR_DISTRIBUTION_SETS_ALL; supplies distribution sets for the activity.
• DESCRIPTION — free-text explanation of the activity.
• START_DATE_ACTIVE / END_DATE_ACTIVE / INACTIVE_DATE — effective dating used to restrict activity usage by period.
• ACCOUNTING_AFFECT_FLAG / GL_ACCOUNT_SOURCE / TAX_CODE_SOURCE — control how tax and GL accounts are derived.
• ASSET_TAX_CODE / LIABILITY_TAX_CODE / TAX_RECOVERABLE_FLAG — tax determination attributes for the activity.
• RISK_ELIMINATION_DAYS — used in risk and revenue recognition processing.
• ORG_ID — operating unit (multi-org) discriminator.
• ZD_EDITION_NAME — editioning/suffix column supporting the multi-organization data model.
• ATTRIBUTE1–15 / GLOBAL_ATTRIBUTE1–20 — descriptor flexfields for customer extensions.
• WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting establishes the link between receipt activity, receipt method, and GL account. A standard join resolves the activity name against the ledger and code combination:

• Listing active receipt activities for an operating unit by filtering on ORG_ID, SET_OF_BOOKS_ID and STATUS.
• Joining to AR_RECEIPT_METHOD_ACCOUNTS_ALL on EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID and BR_STD_RECEIVABLES_TRX_ID to report receipt method accounting.
• Joining to CE_BANK_ACCT_USES_ALL on the same activity foreign keys to report bank account activity mappings.
• Resolving CODE_COMBINATION_ID to GL_CODE_COMBINATIONS to display account strings.
• For Brazilian localization, joining JL_BR_AR_REC_MET_ACCTS_EXT_ALL on CALCULATED_INTEREST_RECTRX_ID, INTEREST_WRITEOFF_RECTRX_ID, INTEREST_REVENUE_RECTRX_ID, ABATEMENT_WRITEOFF_RECTRX_ID and ABATEMENT_REVENUE_RECTRX_ID to report interest and abatement accounts.
• Driving Open Interface or AutoInvoice loads by selecting activity definitions as validation lookups.

A representative query selects NAME, TYPE, STATUS and CODE_COMBINATION_ID from AR_RECEIVABLES_TRX_ALL, joining GL_CODE_COMBINATIONS on CODE_COMBINATION_ID and filtering by ORG_ID and STATUS = 'A'. Extracts feeding AR_XLA_HEADERS_EXTRACT, AR_XLA_LINES_EXTRACT and AR_INTEREST_LINES_ALL also depend on RECEIVABLES_TRX_ID for attribution.

Related Objects

• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID to resolve account strings.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID for ledger context.
• AR_DISTRIBUTION_SETS_ALL — joined on DEFAULT_ACCTG_DISTRIBUTION_SET.
• AR_RECEIPT_METHOD_ACCOUNTS_ALL — references EDISC, UNEDISC and BR_STD activity IDs.
• CE_BANK_ACCT_USES_ALL — references the same activity IDs for bank account accounting.
• AR_CASH_RECEIPTS_ALL / AR_RECEIVABLE_APPLICATIONS_ALL / AR_ADJUSTMENTS_ALL — reference RECEIVABLES_TRX_ID on posted transactions.
• AR_SYSTEM_PARAMETERS_ALL — references PENALTY, FINCHRG and IREC service charge activity IDs.
• JL_BR_AR_REC_MET_ACCTS_EXT_ALL — Brazilian receipt method extension referencing five activity columns.
• AR_INTEREST_LINES_ALL / AR_LATE_CHARGE_DOC_GT — reference RECEIVABLES_TRX_ID for interest and late charge processing.
• CE_SYSTEM_PARAMETERS_ALL / CE_TRANSACTION_CODES — reference RECEIVABLES_TRX_ID for cash management defaults.