Cases When Accounting Calendar Period Name Can Be Edited
(Doc ID 2890863.1)
Last updated on AUGUST 19, 2022
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.
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.
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
|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';|