My Oracle Support Banner

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 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.

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
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 t1.project_id,,t1.description,t1.start_date,t1.completion_date,t2.current_planning_period
from pjf_projects_all_vl t1, pjo_planning_options t2
where t1.project_id = t2.project_id
and t2.current_planning_period = 'period_name in issue'
order by 4 desc;
 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';

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.