My Oracle Support Banner

ETL9.2: Page Composer Approvals Setup Has Orphaned Rows. (Doc ID 2795774.1)

Last updated on NOVEMBER 04, 2024

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Approvals

ACTUAL BEHAVIOR
---------------
Page composer developer registration provide access to two layouts for Payable Time Details, one for small form factor and one for extra large form factor,
EOPCMAIN_ID HMDI3041100000000640 and HMDI3041100000000641

but when the approvals page loads there are 4 layouts. 2 of which cannot be modified in the developer registration.
HMD0000372 and HMD0000054

select * from
PS_EOPCMAIN_DISP where
DESCR254 like 'Payable Time Details%'

or

select * from PS_EOPCAPP_SREC2VW where recname like 'TL_PAY_VW_FL%'

User modified all layouts using TL_PAY_VW_FL to use TL_PAY_VW_FL_LL custom view on page composer developer registration and two of the rows in PS_EOPCAPP_SREC2VW still point to TL_PAY_VW_FL and cannot be modified from screen.

These rows all have the same eopcmain_field_hsh so all get loaded on the approvals page. 19rWLmW6AjJryb+KTvjYG0zXWcQ=

When they go to page composer developer registration page for approvals/TLPayableTime and modify the descr for the two rows displaying as Payable Time Details, two of the rows in

select * from PS_EOPCAPP_SREC2VW where recname like 'TL_PAY_VW_FL%'

change to the new value and the other two do not.

The user would get an error saying the view did not exist

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