Solution : PeopleSoft CREFs set to expire on 31-DEC-2010

There are around 1560 (approx) content reference expiry date set to 31-DEC-2010.

Steps to resolve this:

1. Download the project from support.oracle.com : -  
     https://support.oracle.com/CSP/main/article?cmd=sh ow&type=NOT&id=1183084.1

    Oracle delivered a project which resets  expiry date to NULL. Run the app engine from AppDesigner.

2. Run the Portal Security Sync.

3. Cleare AppServ Cached & Browser.

    Check the PSPRSMDEFN table to verify the Expirty Date set null.

Source: Oracle

If the above not worked.

1. Assigne PeopleSoft Administrator role to PS user from backend.
    Insert into psroleuser values('PS','PeopleSoft Administrator','N');

either of the steps will work.

:-)