My Oracle Support Banner

The display period names from the Start/End Period drop-down list on "Collect Transactions" are not showing correctly (Doc ID 1470644.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.
If the period name has format XXX-YY, where XXX is first 3 characters of the month and YY is the last 2 digits of the year. Then the display period names from the Start/End Period drop-down list on "Collect Transactions" page (Nav: Compensation Manager reponsibility> Tasks > Collect Transactions, pick the Transaction Source) will show correctly.

Examples:
DEC-11 (ie. month DECEMBER 2011), the display period name from the Start/End Period drop-down list will show DEC-2011
JAN-12 (ie. month JANUARY 2012), the display period name from the Start/End Period drop-down list will show JAN-2012
FEB-12 (ie. month FEBRUARY 2012), the display period name from the Start/End Period drop-down list will show FEB-2012


But if customer is not following the format XXX-YY above and using the period name in the format below,

P12-11 (ie. month DECEMBER 2011), the display period name from the Start/End Period drop-down list will show P12-2011
P1-12 (ie. month JANUARY 2012), the display period name from the Start/End Period drop-down list shows P1-12012
P2-12 (ie. month FEBRUARY 2012), the display period name from the Start/End Period drop-down list shows P2-12012

The display period name P12-2011 is normal and understandable, but not with display period names P1-12012 and P2-12012 as these causes confusion to end users. It makes more sense that P1-12012 is P1-2012 and P2-12012 is P2-2012 instead.

Also, customer did not have this problem in Release 11i, but only after having upgraded to Release 12.x



This is because the design has changed since Release 12.x, the display period names are obtained by the query below.

SELECT DISTINCT PS.PERIOD_YEAR, PERIOD_ID, SUBSTR(PERIOD_NAME,1,3)||PS.PERIOD_YEAR DISPLAY_NAME,
PS.PERIOD_NAME
FROM CN_PERIOD_STATUSES PS
WHERE (PS.ORG_ID, PS.PERIOD_SET_ID, PS.PERIOD_TYPE_ID) =
(SELECT R.ORG_ID, R.PERIOD_SET_ID, R.PERIOD_TYPE_ID
FROM CN_REPOSITORIES R
WHERE R.ORG_ID = :1)
AND PS.PERIOD_STATUS in ('O', 'F')
ORDER BY PERIOD_ID


In Release 11i, the display period names are obtained by the query below

select period_id, period_name, period_year,
nvl(freeze_flag, 'N') freeze_flag, period_status
from cn_period_statuses cps where exists
(select 1 from cn_repositories cr
where cr.period_set_id = cps.period_set_id
and cr.period_type_id = cps.period_type_id) order by period_id

Goal

 Need to customize the code to give the proper display period names when customer is not using the period name with format XXX-YY

Solution

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
Goal
Solution


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