Cases When Accounting Calendar Period Name Can Be Edited
(Doc ID 2890863.1)
Last updated on DECEMBER 28, 2023
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.22.04.0 to N/A [Release 1.0]Information in this document applies to any platform.
Purpose
There are scenarios where users want to edit period names, start/end date, adjustment period flag for a period, but application does not allow. This is a valid behavior and no issue from the application.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Troubleshooting Steps |
select * from gl_period_statuses where period_name = <Period_name> and period_type = <period_type from gl_calendars>>; |
select period_set_name,same_pa_gl_period from pjf_bu_impl_all where period_set_name = <<period_set_name from gl_calendars>> |
If same_pa_gl_period = Y, only one set of periods. PA refers to data from GL_PERIOD_STATUSES and application_id = 10037 |
if same_pa_gl_period = N, then a separate copy is maintained. In this case, refer to some more tables from Projects and see if the period is referred or not. |
select * from pjf_periods_all; |
select * from xcc_control_budgets where period_set_name = 'period_set_name from gl_calendars' and period_type = 'period_type from gl_calendars'; |
select * from xcc_cb_period_statuses where period_name = 'period name in issue'; |
select ledger_id,name,period_set_name,latest_encumbrance_year from gl_ledgers where period_set_name = 'period_set_name from gl_calendars'; |
References |