SCRTY_SJTDLY: Nightly SJT Refresh Process Runs to No Success (Doc ID 1456911.1)

Last updated on MARCH 29, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


Application Engine SCRTY_SJTDLY abending when running Refresh SJT Process

Navigation: Setup HRMS -> Security -> Core Row Level Security -> Nightly SJT Refresh Process

SQL object not defined (108,520)
Meta-SQL error at or near position 117 in statement (108,512)
Process 5041759 ABENDED at Step SCRTY_SJTUPD.25InsSJ1.Step01 (SQL) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS TO REPLICATE
--------------------
1. Setup HRMS -> Security -> Core Row Level Security -> Nightly SJT Refresh Process
2. Add a new run control id
3. Run the program

EXPECTED BEHAVIOR:
----------------------------------
Expected: Application Engine SCRTY_SJTDLY should run to success

ERROR MESSAGE
-----------------------
SQL object not defined (108,520)
Meta-SQL error at or near position 117 in statement (108,512)
Process 5041759 ABENDED at Step SCRTY_SJTUPD.25InsSJ1.Step01 (SQL) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms