My Oracle Support Banner

PA_PERIODS_ALL.GL_PERIOD_NAME Has an Incorrect Period (Doc ID 2942070.1)

Last updated on JUNE 04, 2024

Applies to:

Oracle Project Costing - Version 12.2 and later
Oracle Project Intelligence - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

The table.column, PA_PERIODS_ALL.GL_PERIOD_NAME, has an incorrect value (i.e. 23-May) for a valid period (i.e 24-Apr-2023 to 30-Apr-2023).  The value should be i.e. 23-Apr (April 2023).  Note: The gl_period_name column is not shown in the PA Maintain Period Statuses screen (> Projects responsibility > Setup > System > PA Periods).

 

STEPS TO REPRODUCE

1. Run the following query:

2. Check the column, gl_period_name, to see if the value is correct is correct or not.

Note: The gl_period_name column is not shown in the PA Maintain Period Statuses screen (> Projects responsibility > Setup > System > PA Periods).

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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