Results for “entered_currency”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
RG_REPORT_PARAMETERS is a table in the RG (Application Report Generator) schema within Oracle EBS 12.1.1 and 12.2.2. Its documented description is "Assignments of budgets, encumbrances, and currencies to reports." It stores the parameter definitions that drive the Financial Statement Generator-style reporting functionality historically associated with the RG product, binding a report's parameter set to specific budget versions, encumbrance types, and currency definitions.
The table carries 32 documented columns and is classified under a heuristic Data Vault model as a link. This classification reflects its structure: it holds foreign key references to multiple parent entities (GL_BUDGET_VERSIONS, GL_ENCUMBRANCE_TYPES, and three references into FND_CURRENCIES), making it an associative entity that resolves relationships between report parameter sets and those reference objects rather than acting as an independent hub.
Key Information Stored
The primary key is RG_REPORT_PARAMETERS_PK, composed of PARAMETER_SET_ID, DATA_TYPE, and PARAMETER_NUM. A unique index, RG_REPORT_PARAMETERS_U1, is defined on the same three columns, making this combination the documented business-key candidate as well as the physical identifier for each row.
PARAMETER_SET_ID— Groups individual parameters into a set and links the assignment to a report.DATA_TYPE— Identifies the kind of parameter (for example, budget, encumbrance, or currency), pairing withPARAMETER_NUMto form the key.PARAMETER_NUM— Sequence number positioning the parameter within its set.PARAMETER_ID— The referenced identifier for budget versions or encumbrance types, depending onDATA_TYPE.UNIT_OF_MEASURE_ID_11I— Currency reference column joined toFND_CURRENCIES.ENTERED_CURRENCY— The transaction/entered currency for the report parameter.LEDGER_CURRENCY— The ledger (functional) currency associated with the parameter.CURRENCY_TYPEandCURRENCY_TYPE_11I— Currency classification indicators.PERIOD_NUM— Period reference used in the report assignment.FISCAL_YEAR_OFFSET— Offset applied to the fiscal year for period selection.- Standard WHO columns (
CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) for audit tracking. CONTEXTandATTRIBUTE1throughATTRIBUTE15— Descriptive flexfield segments for extensibility.
Common Use Cases and Queries
A typical use case is determining which currencies and budgets have been assigned to a given report parameter set. Because the search term FND_CURRENCIES was associated with this object, currency-resolution queries are common. The following pattern joins the three currency references to FND_CURRENCIES:
- Resolving entered currency:
SELECT rp.PARAMETER_SET_ID, fc.NAME FROM RG_REPORT_PARAMETERS rp, FND_CURRENCIES fc WHERE rp.ENTERED_CURRENCY = fc.CURRENCY_CODE; - Resolving ledger currency: substitute
rp.LEDGER_CURRENCYfor the join. - Resolving the unit-of-measure currency via
rp.UNIT_OF_MEASURE_ID_11I. - Listing budgets assigned to a report by joining
PARAMETER_IDtoGL_BUDGET_VERSIONS. - Listing encumbrance assignments by joining
PARAMETER_IDtoGL_ENCUMBRANCE_TYPES. - Filtering by
DATA_TYPEto separate budget, encumbrance, and currency rows within a parameter set.
These queries support reporting diagnostics, migration validation, and audit of report configuration.
Related Objects
The documented foreign keys tie RG_REPORT_PARAMETERS to the following reference tables, which are its most significant related objects:
GL_BUDGET_VERSIONS— joined viaPARAMETER_ID; supplies budget version definitions.GL_ENCUMBRANCE_TYPES— joined viaPARAMETER_ID; supplies encumbrance type definitions.FND_CURRENCIES— referenced three times, viaUNIT_OF_MEASURE_ID_11I,ENTERED_CURRENCY, andLEDGER_CURRENCY, providing the currency master data central to the searched term.
Given the heuristic link classification, the parent tables above act as the hubs this table connects, and the RG_REPORT_PARAMETERS_PK composite key governs all downstream joins.
-
Assignments of budgets, encumbrances, and currencies to reports
-
View: RG_CURRENCIES_V 12.2.2
10SC ONLY
APPS.RG_CURRENCIES_V·↳ RG_REPORT_PARAMETERS·Explore RG module →
-
Fetches accounting entries for 'cenvat claim reversal' event
APPS.JAI_PO_REC_CENVAT_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_PO_REC_RMA_AEL_V 12.2.2
Fetch accounting entries when third party is customer, to handle 'rma accounting event'
APPS.JAI_PO_REC_RMA_AEL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES·Explore JA module →
-
View: JAI_RG_FUND_TRF_AEL_V 12.2.2
APPS.JAI_RG_FUND_TRF_AEL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES·Explore JA module →
-
10SC ONLY
APPS.GL_ALLOC_FORMULA_LINES_V·↳ GL_ALLOC_FORMULA_LINES·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore GL module →
-
View: JAI_PO_REC_VAT_AEL_V 12.2.2
Fetch accounting entries for 'vat claim' event
APPS.JAI_PO_REC_VAT_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
10SC ONLY
APPS.GL_ALLOC_FORMULA_LINES_V·↳ GL_ALLOC_FORMULA_LINES·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore GL module →
-
View: JAI_PO_REC_MTL_AEL_V 12.2.2
Fetch accounting entries for Deliver event with Source 'Inventory India', Category 'MTL'
APPS.JAI_PO_REC_MTL_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_PO_OSPM_AEL_V 12.2.2
Base view of OSP manually entered
APPS.JAI_PO_OSPM_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
Assignments of budgets, encumbrances, and currencies to reports
-
View: JAI_PO_OSP_DISP_AEL_V 12.2.2
Base view of OSP
APPS.JAI_PO_OSP_DISP_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_PROJECT_INV_AEL_V 12.2.2
Base view for projects
APPS.JAI_PROJECT_INV_AEL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES·Explore JA module →
-
View: JAI_AP_MANUAL_AEL_V 12.2.2
Base view of Manual entry
APPS.JAI_AP_MANUAL_AEL_V·↳ FND_GLOBAL·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·Explore JA module →
-
View: JAI_PO_REC_AEL_V 12.2.2
Base view of PO receipt
APPS.JAI_PO_REC_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: RG_CURRENCIES_V 12.1.1
10SC ONLY
APPS.RG_CURRENCIES_V·↳ RG_REPORT_PARAMETERS·Explore RG module →
-
Fetch accounting entries when third party is Vendor, to handle events: 'Receipt', 'Cenvat Claim', 'RTV', 'RTR', 'Deliver' 'Correction', 'BOE Application and relieving'
APPS.JAI_PO_REC_VENDOR_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
MassAllocations and MassBudget formula lines
-
Recurring journal entry and budget formula lines
-
View: JAI_AP_SET_AEL_V 12.2.2
Base view of service tax settlement
APPS.JAI_AP_SET_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_AP_STDIST_AEL_V 12.2.2
Base view of service tax distribution UI
APPS.JAI_AP_STDIST_AEL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES·Explore JA module →
-
View: JAI_INV_INTERORG_AEL_V 12.2.2
Base view of OFI inter org transfer UI
APPS.JAI_INV_INTERORG_AEL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES·Explore JA module →
-
View: JAI_INV_RGCO_AEL_V 12.2.2
Base view of RG consolidation
APPS.JAI_INV_RGCO_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_INV_RG1_AEL_V 12.2.2
APPS.JAI_INV_RG1_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_INV_RG23_AEL_V 12.2.2
Base view of RG23 Register
APPS.JAI_INV_RG23_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
MassAllocations and MassBudget formula lines
-
Recurring journal entry and budget formula lines
-
VIEW: APPS.RG_CURRENCIES_V 12.1.1
-
VIEW: APPS.RG_CURRENCIES_V 12.2.2
-
VIEW: APPS.JAI_INV_RG1_AEL_V 12.2.2
-
VIEW: APPS.JAI_AP_SET_AEL_V 12.2.2
-
Gives meaning to the XLA_ACCT_ATTRIBUTES_B.ASSIGNMENT_GROUP_CODE when displayed on any UI.