GL Setup Upload
Description
GL Setup Upload creates and updates the General Ledger setup that you would otherwise maintain one screen at a time across the GL Setup menu: accounting calendars and their periods, period types, journal sources and categories, encumbrance types, statistical units of measure, ledger options, ledger sets, data access sets, and the AutoReverse and AutoPost criteria. Fifteen supplied templates mean you only ever see the columns for the one thing you are maintaining, and it is equally useful for downloading an existing setup to review or to document it.
When to use it
- Build a new calendar – create a calendar and all of its periods in one file rather than a row at a time.
- Set up reference data in bulk – period types, journal sources, journal categories, encumbrance types and statistical units of measure.
- Maintain ledger sets and data access sets – create the sets and add or remove their member ledgers.
- Change ledger options – update the options of existing ledgers.
- Maintain journal automation – AutoReverse criteria and their options, and AutoPost sets and their priorities.
- Review an existing setup – download any of the above without uploading a change, for review or documentation.
Before you start
- Blitz Report is installed and you are signed in to a responsibility with access to the General Ledger setup forms.
- Anything you reference already exists – each value is validated against its list. Ledgers in particular cannot be created here, so a ledger you assign to a ledger set must already exist.
- You know which entity you are maintaining, so you can pick the matching template.
Step 1 – Open the upload and pick a template
Run GL Setup Upload from the Blitz Report menu and choose the template for the entity you are maintaining. There is one template per entity, and it does two things for you: it shows only that entity’s columns instead of all of them, and it sets the Row Type on every row automatically, so you cannot accidentally mix entities.
The templates are Period Type, Calendar Period, Journal Source, Journal Category, Encumbrance Type, Statistical Unit of Measure, Ledger Set, Ledger Set Assignment, Data Access Set, Data Access Set Assignment, Ledger, AutoReverse Criteria Set, AutoReverse Option, AutoPost Set and AutoPost Option.
Step 2 – Set the parameters and download the template
| Parameter | Purpose |
|---|---|
| Upload Mode | Create gives an empty template. Create, Update downloads the existing records so you can review or change them. |
| Row Type | Limits the download to one entity. Each template sets this for you, so you normally leave it alone. |
| Calendar | Limits Calendar Period rows to one calendar. |
| Period Type | Limits Period Type and Calendar Period rows to one period type. |
| Chart of Accounts | Limits the rows that belong to a chart of accounts: statistical units of measure, ledger sets and their assignments, data access sets and their assignments, ledgers and AutoPost sets. |
Step 3 – The fifteen row types
Every row has a Row Type that says what it defines. Only the columns belonging to that entity are read; the rest are ignored. The templates group naturally into four areas:
| Area | Row types |
|---|---|
| Calendars | Period Type, Calendar Period |
| Journal reference data | Journal Source, Journal Category, Encumbrance Type, Statistical Unit of Measure |
| Ledgers and security | Ledger, Ledger Set, Ledger Set Assignment, Data Access Set, Data Access Set Assignment |
| Journal automation | AutoReverse Criteria Set, AutoReverse Option, AutoPost Set, AutoPost Option |
Each row is treated as a create or an update automatically, by checking whether the record already exists – you never set an action yourself. A row that changes nothing is reported as “No change.” and is not written.
Step 4 – Calendars
A Period Type row needs Periods Per Year and Year Type In Name to create it, and neither can be changed afterwards.
A Calendar Period row creates or updates one period. The calendar itself is created together with its first period, so you can simply type a new calendar name on the first row rather than creating the calendar separately. Enter either a Period Name or a Period Prefix; a prefix is expanded to prefix-YY. Once a period has been used by a transaction only its description and flexfield can still be changed. Set Delete Period to Yes to remove a period that has never been used. After the upload the calendar is checked for gaps and overlaps between its periods and any are reported as a warning.
Step 5 – Journal reference data
Journal Source rows carry Import Journal References, Require Journal Approval, Import Using Key, Freeze Journals and the Effective Date Rule. Journal Category rows create the category and, on creation, also seed its document sequence category and its AutoReverse options for every ledger. Encumbrance Type rows maintain the type and its Enabled flag – disable a type rather than trying to remove it. Statistical Unit of Measure rows assign a unit of measure to a natural account segment value of a chart of accounts, and Delete Stat UOM removes the assignment.
Step 6 – Ledgers and security
Ledger rows update the options of an existing ledger. New ledgers cannot be created here – see below.
Ledger Set and Data Access Set rows create or update the set itself; the Assignment row types add the member ledgers, and Delete Assignment removes one. The chart of accounts, calendar and period type of a set are fixed once it exists.
Assignments do not take effect until Oracle’s General Ledger Accounting Setup Program has flattened them, so the upload submits that program for you, once per chart of accounts, and reports its request id in the row message. You do not need to submit anything by hand.
Step 7 – Journal automation
An AutoReverse Criteria Set row creates the set; its behaviour lives on the AutoReverse Option rows, one per journal category. An existing criteria set cannot be updated or deleted from the upload, only its options can be changed.
AutoPost Set rows create or update the set, and AutoPost Option rows hold the priorities within it, with Delete Option to remove one. The chart of accounts, calendar and period type of an AutoPost set are fixed once it exists.
Step 8 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the extra validation the upload defines, then saves the file. Correct anything it flags before continuing.
Step 9 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which processes each row independently, so one bad row does not stop the rest. When it finishes, a result report opens showing each row as success or error with a message.
What’s produced
- Created or updated General Ledger setup records for whichever of the fifteen entities your rows describe, including their descriptive flexfield values.
- For ledger set and data access set assignments, a submitted General Ledger Accounting Setup Program request, with its request id reported on the row.
- A result report listing every row with a status and a message, for example “Calendar period created.”, “No change.” or the reason a row failed.
What this upload cannot do
Oracle does not publish a supported interface for a few of these actions, so rather than write to the tables behind Oracle’s back the upload declines them and tells you where to do it:
- Create a ledger. Only the Accounting Setup Manager can create a ledger, because creating one also builds the accounting setup around it. The Ledger row type updates the options of a ledger that already exists.
- Delete a ledger set or a data access set. Both can be created and updated, and their assignments can be removed, but the set itself has to be removed in its own form.
- Update or delete an AutoReverse criteria set. Change its options instead; the set itself is deleted in the Journal Reversal Criteria Set form.
Common questions
Do I have to set the Row Type myself?
No. Pick the template for what you are maintaining and the Row Type is set on every row for you and cannot be edited. It is only worth thinking about if you deliberately put several entities in one file.
Can I put more than one entity in the same file?
Yes. Rows are processed top to bottom, so put a parent above anything that depends on it – a ledger set above its assignments, an AutoPost set above its options, and a calendar’s first period above its later ones.
How do I create a new calendar?
Type the new calendar name on a Calendar Period row. The calendar is created together with its first period, so there is no separate step.
Why can I only change the description on some periods?
Because those periods have already been used by transactions. Oracle only allows the description and the flexfield to change once a period has been used, and the upload enforces the same rule.
Why have my ledger set changes not taken effect?
Assignments are staged until Oracle’s General Ledger Accounting Setup Program has flattened them. The upload submits that program automatically and reports its request id; if the request is still running, wait for it to complete.
How do I remove something?
Set the relevant Delete column to Yes: Delete Period for a calendar period, Delete Stat UOM for a statistical unit of measure, Delete Assignment for a ledger set or data access set member, and Delete Option for an AutoPost priority. Anything else is disabled or end-dated rather than deleted.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| You can only modify periods that have never been used. | The period has been used by a transaction. | Change only its description or flexfield. To restructure a used calendar, add new periods instead. |
| Either Period Name or Period Prefix is required. | A Calendar Period row identifies no period. | Enter a Period Name, or a Period Prefix which is expanded to prefix-YY. |
| Period Prefix and Period Name cannot contain spaces. / cannot contain quotes. | The period name would be invalid in Oracle. | Remove the spaces or quotes from the name or prefix. |
| Periods Per Year cannot be changed on an existing period type. | Periods Per Year and Year Type In Name are fixed once a period type exists. | Leave them as downloaded, or create a new period type. |
| Chart of Accounts cannot be changed on an existing ledger set. | The chart of accounts, calendar and period type of a set are fixed once it exists. | Leave them as downloaded, or create a new set. |
| No change. A reversal criteria set cannot be updated, only its options can. | A criteria set row tried to change the set itself. | Change its AutoReverse Option rows instead. |
| A reversal criteria set can only be deleted in the Journal Reversal Criteria Set form. | Oracle publishes no supported interface to delete a criteria set. | Delete it in that form. |
| Autopost Reversal cannot be Yes when Autoreverse is No. | The two options contradict each other. | Set Autoreverse to Yes, or clear Autopost Reversal. |
| This action cannot be performed by the upload. | The row asked for something Oracle exposes no supported interface for, such as creating a ledger. | See “What this upload cannot do” above and use the form named there. |
select x.action_, x.status_, x.message_, x.modified_columns_, x.row_type, x.calendar, x.calendar_description, x.enable_security, x.period_prefix, x.period_type, x.period_year, x.quarter, x.period_num, x.start_date, x.end_date, x.period_name, x.adjustment_period, x.period_description, x.delete_period, x.periods_per_year, x.year_type_in_name, x.journal_source, x.journal_source_key, x.import_journal_references, x.require_journal_approval, x.import_using_key, x.freeze_journals, x.effective_date_rule, x.journal_category, x.journal_category_key, x.encumbrance_type, x.enabled, x.chart_of_accounts, x.account_segment_value, x.unit_of_measure, x.delete_stat_uom, x.description, x.period_type_context, x.period_type_attribute1, x.period_type_attribute2, x.period_type_attribute3, x.period_type_attribute4, x.period_type_attribute5, x.period_context, x.period_attribute1, x.period_attribute2, x.period_attribute3, x.period_attribute4, x.period_attribute5, x.period_attribute6, x.period_attribute7, x.period_attribute8, x.source_context, x.source_attribute1, x.source_attribute2, x.source_attribute3, x.source_attribute4, x.source_attribute5, x.category_context, x.category_attribute1, x.category_attribute2, x.category_attribute3, x.category_attribute4, x.category_attribute5, x.ledger_set, x.short_name, x.default_ledger, x.ledger, x.delete_assignment, x.data_access_set, x.access_set_type, x.all_segment_values, x.segment_value, x.retained_earnings_account, x.suspense_allowed, x.rounding_account, x.cta_account, x.reserve_encumbrance_account, x.net_income_account, x.enable_average_balances, x.translate_eod, x.translate_qatd, x.translate_yatd, x.enable_budgetary_control, x.require_budget_journals, x.enable_journal_approval, x.enable_automatic_tax, x.consolidation_ledger, x.future_enterable_periods, x.transaction_calendar, x.daily_rate_type, x.period_average_rate_type, x.period_end_rate_type, x.enable_reconciliation, x.net_closing_balance, x.criteria_set, x.reversal_method, x.reversal_period, x.reversal_date, x.autoreverse, x.autopost_reversal, x.autopost_set, x.submit_all_priorities, x.number_of_priorities, x.effective_days_before, x.effective_days_after, x.posting_priority, x.balance_type, x.delete_option, x.row_type_sort, row_number() over (order by x.row_type_sort, x.calendar, x.period_type, x.period_year, x.period_num, x.journal_source, x.journal_category, x.encumbrance_type, x.data_access_set, x.criteria_set, x.autopost_set, x.posting_priority, x.ledger, x.chart_of_accounts, x.account_segment_value) upload_row from ( select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Period Type' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, gpt.number_per_fiscal_year periods_per_year, decode(gpt.year_type_in_name,'C','Calendar','F','Fiscal') year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gpt.description, xxen_util.display_flexfield_context(101,'GL_PERIOD_TYPES',gpt.context) period_type_context, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE1',gpt.rowid,gpt.attribute1) period_type_attribute1, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE2',gpt.rowid,gpt.attribute2) period_type_attribute2, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE3',gpt.rowid,gpt.attribute3) period_type_attribute3, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE4',gpt.rowid,gpt.attribute4) period_type_attribute4, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE5',gpt.rowid,gpt.attribute5) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 1 row_type_sort from gl_period_types gpt where 1=1 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Calendar Period' row_type, gps.period_set_name calendar, gps.description calendar_description, xxen_util.meaning(gps.security_flag,'YES_NO',0) enable_security, gp.entered_period_name period_prefix, gpt.user_period_type period_type, gp.period_year, gp.quarter_num quarter, gp.period_num, gp.start_date, gp.end_date, gp.period_name, xxen_util.meaning(gp.adjustment_period_flag,'YES_NO',0) adjustment_period, gp.description period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, xxen_util.display_flexfield_context(101,'GL_PERIODS',gp.context) period_context, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE1',gp.rowid,gp.attribute1) period_attribute1, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE2',gp.rowid,gp.attribute2) period_attribute2, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE3',gp.rowid,gp.attribute3) period_attribute3, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE4',gp.rowid,gp.attribute4) period_attribute4, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE5',gp.rowid,gp.attribute5) period_attribute5, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE6',gp.rowid,gp.attribute6) period_attribute6, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE7',gp.rowid,gp.attribute7) period_attribute7, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE8',gp.rowid,gp.attribute8) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 2 row_type_sort from gl_period_sets gps, gl_periods gp, gl_period_types gpt where 2=2 and gps.period_set_name=gp.period_set_name and gp.period_type=gpt.period_type union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Journal Source' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, gjsv.user_je_source_name journal_source, gjsv.je_source_key journal_source_key, xxen_util.meaning(gjsv.journal_reference_flag,'YES_NO',0) import_journal_references, xxen_util.meaning(gjsv.journal_approval_flag,'YES_NO',0) require_journal_approval, xxen_util.meaning(gjsv.import_using_key_flag,'YES_NO',0) import_using_key, xxen_util.meaning(gjsv.override_edits_flag,'YES_NO',0) freeze_journals, decode(gjsv.effective_date_rule_code,'L','Leave Alone','R','Roll Date','F','Fail') effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gjsv.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, xxen_util.display_flexfield_context(101,'GL_JE_SOURCES',gjsv.context) source_context, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE1',gjsv.row_id,gjsv.attribute1) source_attribute1, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE2',gjsv.row_id,gjsv.attribute2) source_attribute2, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE3',gjsv.row_id,gjsv.attribute3) source_attribute3, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE4',gjsv.row_id,gjsv.attribute4) source_attribute4, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE5',gjsv.row_id,gjsv.attribute5) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 3 row_type_sort from gl_je_sources_vl gjsv where 3=3 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Journal Category' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, gjcv.user_je_category_name journal_category, gjcv.je_category_key journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gjcv.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, xxen_util.display_flexfield_context(101,'GL_JE_CATEGORIES',gjcv.context) category_context, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE1',gjcv.row_id,gjcv.attribute1) category_attribute1, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE2',gjcv.row_id,gjcv.attribute2) category_attribute2, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE3',gjcv.row_id,gjcv.attribute3) category_attribute3, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE4',gjcv.row_id,gjcv.attribute4) category_attribute4, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE5',gjcv.row_id,gjcv.attribute5) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 4 row_type_sort from gl_je_categories_vl gjcv where 4=4 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Encumbrance Type' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, get.encumbrance_type, xxen_util.meaning(get.enabled_flag,'YES_NO',0) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, get.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 5 row_type_sort from gl_encumbrance_types get where 5=5 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Statistical Unit of Measure' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, gsau.account_segment_value, gsau.unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 6 row_type_sort from gl_stat_account_uom gsau, fnd_id_flex_structures_vl fifsv where 6=6 and gsau.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger Set' row_type, gl.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, gl.name ledger_set, gl.short_name, gld.name default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 7 row_type_sort from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_access_sets gas, gl_ledgers gld where gl.object_type_code='S' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gl.accounted_period_type and gas.name(+)=gl.name and gas.automatically_created_flag(+)='Y' and gld.ledger_id(+)=gas.default_ledger_id and 7=7 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger Set Assignment' row_type, gls.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, gls.name ledger_set, to_char(null) short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 8 row_type_sort from gl_ledger_set_norm_assign glsna, gl_ledgers gls, gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt where glsna.ledger_set_id=gls.ledger_id and glsna.ledger_id=gl.ledger_id and gls.object_type_code='S' and nvl(glsna.status_code,'X')<>'D' and fifsv.id_flex_num=gls.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gls.accounted_period_type and 8=8 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Data Access Set' row_type, gas.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, xxen_util.meaning(gas.enabled_flag,'YES_NO',0) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gas.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, gld.name default_ledger, to_char(null) ledger, to_char(null) delete_assignment, gas.name data_access_set, decode(gas.security_segment_code,'F','Full Ledger','B','Balancing Segment Value','M','Management Segment Value') access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 9 row_type_sort from gl_access_sets gas, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_ledgers gld where gas.automatically_created_flag='N' and fifsv.id_flex_num=gas.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gas.accounted_period_type and gld.ledger_id(+)=gas.default_ledger_id and 9=9 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Data Access Set Assignment' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, gas.name data_access_set, to_char(null) access_set_type, xxen_util.meaning(nvl(gasna.all_segment_value_flag,'N'),'YES_NO',0) all_segment_values, gasna.segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 10 row_type_sort from gl_access_set_norm_assign gasna, gl_access_sets gas, gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gasna.access_set_id=gas.access_set_id and gasna.ledger_id=gl.ledger_id and gas.automatically_created_flag='N' and nvl(gasna.status_code,'X')<>'D' and fifsv.id_flex_num=gas.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and 10=10 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger' row_type, gl.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, gl.short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, gcck_ret.concatenated_segments retained_earnings_account, xxen_util.meaning(gl.suspense_allowed_flag,'YES_NO',0) suspense_allowed, gcck_rnd.concatenated_segments rounding_account, gcck_cta.concatenated_segments cta_account, gcck_res.concatenated_segments reserve_encumbrance_account, gcck_ni.concatenated_segments net_income_account, xxen_util.meaning(gl.enable_average_balances_flag,'YES_NO',0) enable_average_balances, xxen_util.meaning(gl.translate_eod_flag,'YES_NO',0) translate_eod, xxen_util.meaning(gl.translate_qatd_flag,'YES_NO',0) translate_qatd, xxen_util.meaning(gl.translate_yatd_flag,'YES_NO',0) translate_yatd, xxen_util.meaning(gl.enable_budgetary_control_flag,'YES_NO',0) enable_budgetary_control, xxen_util.meaning(gl.require_budget_journals_flag,'YES_NO',0) require_budget_journals, xxen_util.meaning(gl.enable_je_approval_flag,'YES_NO',0) enable_journal_approval, xxen_util.meaning(gl.enable_automatic_tax_flag,'YES_NO',0) enable_automatic_tax, xxen_util.meaning(gl.consolidation_ledger_flag,'YES_NO',0) consolidation_ledger, gl.future_enterable_periods_limit future_enterable_periods, gtc.name transaction_calendar, gl.daily_translation_rate_type daily_rate_type, gl.period_average_rate_type, gl.period_end_rate_type, xxen_util.meaning(gl.enable_reconciliation_flag,'YES_NO',0) enable_reconciliation, xxen_util.meaning(gl.net_closing_bal_flag,'YES_NO',0) net_closing_balance, gacs.criteria_set_name criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 11 row_type_sort from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_code_combinations_kfv gcck_ret, gl_code_combinations_kfv gcck_rnd, gl_code_combinations_kfv gcck_cta, gl_code_combinations_kfv gcck_res, gl_code_combinations_kfv gcck_ni, gl_transaction_calendar gtc, gl_autorev_criteria_sets gacs where gl.object_type_code='L' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gl.accounted_period_type and gcck_ret.code_combination_id(+)=gl.ret_earn_code_combination_id and gcck_rnd.code_combination_id(+)=gl.rounding_code_combination_id and gcck_cta.code_combination_id(+)=gl.cum_trans_code_combination_id and gcck_res.code_combination_id(+)=gl.res_encumb_code_combination_id and gcck_ni.code_combination_id(+)=gl.net_income_code_combination_id and gtc.transaction_calendar_id(+)=gl.transaction_calendar_id and gacs.criteria_set_id(+)=gl.criteria_set_id and 11=11 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoReverse Criteria Set' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gacs.criteria_set_desc description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, gacs.criteria_set_name criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 12 row_type_sort from gl_autorev_criteria_sets gacs where 12=12 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoReverse Option' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, gjcv.user_je_category_name journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, gacs.criteria_set_name criteria_set, xxen_util.meaning(gao.method_code,'REVERSAL_OPTION_CODE',101) reversal_method, decode(gao.reversal_period_code,'NO_DEFAULT','No Default','SAME_PERIOD','Same Period','NEXT_PERIOD','Next Period','NEXT_NON_ADJ_PERIOD','Next Non Adjusting Period') reversal_period, xxen_util.meaning(gao.reversal_date_code,'AUTOREVERSE_DATE_RULE',0) reversal_date, xxen_util.meaning(gao.autoreverse_flag,'YES_NO',0) autoreverse, xxen_util.meaning(gao.autopost_reversal_flag,'YES_NO',0) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 13 row_type_sort from gl_autoreverse_options gao, gl_autorev_criteria_sets gacs, gl_je_categories_vl gjcv where gao.criteria_set_id=gacs.criteria_set_id and gao.je_category_name=gjcv.je_category_name and 13=13 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoPost Set' row_type, gaps.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, xxen_util.meaning(gaps.enabled_flag,'YES_NO',0) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gaps.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, gaps.autopost_set_name autopost_set, xxen_util.meaning(gaps.submit_all_priorities_flag,'YES_NO',0) submit_all_priorities, gaps.num_of_priority_options number_of_priorities, gaps.effective_days_before, gaps.effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 14 row_type_sort from gl_automatic_posting_sets gaps, fnd_id_flex_structures_vl fifsv, gl_period_types gpt where fifsv.id_flex_num=gaps.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gaps.accounted_period_type and 14=14 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoPost Option' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, gapo.period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, decode(gapo.je_source_name,'ALL','ALL',gjsv.user_je_source_name) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, decode(gapo.je_category_name,'ALL','ALL',gjcv.user_je_category_name) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, decode(gapo.ledger_id,-1234567890,'ALL',gl.name) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, gaps.autopost_set_name autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, gapo.posting_priority, (select flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE_ALL' and flvv.security_group_id=0 and flvv.lookup_code=gapo.actual_flag) balance_type, to_char(null) delete_option, 15 row_type_sort from gl_automatic_posting_options gapo, gl_automatic_posting_sets gaps, gl_ledgers gl, gl_je_sources_vl gjsv, gl_je_categories_vl gjcv where gapo.autopost_set_id=gaps.autopost_set_id and gl.ledger_id(+)=gapo.ledger_id and gjsv.je_source_name(+)=gapo.je_source_name and gjcv.je_category_name(+)=gapo.je_category_name and 15=15 ) x |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Upload Mode |
| LOV | |
| Row Type |
| LOV | |
| Calendar |
| LOV | |
| Period Type |
| LOV | |
| Chart of Accounts |
| LOV |