Users Can Change the Cost Calendar Periods that Have Status of "Never Opened" to "Open" Even Though the Calendar Assignment Has Been Marked for Purge (Doc ID 2974709.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

Symptoms

Business has two cost calendars setup that are both valid calendars - A and B.
Each calendar has the same Legal Entity assigned to two cost types: STND and ACTU.
On the Assign Cost Calendar form, users have Mark for Purge the Assignment for the cost type that was not valid for that calendar.
Users have also Marked for Purge the periods on the period status for the Marked for Purge assignment.

The period status form however has some periods that have a Period Status of "Never Opened". These cannot be Marked for Purge as the record does not exist in gmf_period_statuses until the period has as status of "Open".
Even though the Assignment is Marked for Purge, it was found that the user can change the "Never Opened" periods to "Open".

Requirement is to prevent users being able to change the status to Open on the deleted assignment or delete these future periods from gmf_period_statuses table for periods that have never been open.


The issue can be reproduced at will with the following steps:
1. Responsibility: OPM Financials
2. Navigation: Setup > Cost Calendars
3. Click Assignments.
4. Click on the Assignment then go to Actions menu and select Mark for Purge and Save.
5. Click on Period Status and change status to Open.

Changes

Cause

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