ETL9.2: Peoplecode error when creating SQL Objects through the SQL Objects component (Doc ID 2199085.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When trying to create a new SQL object from the SQL Objects component that requires a new EFFDT row, the following error occurs:

Class Record: assumed property LEFT_OPERAND_BTN is not a valid field name.
(2,274) FUNCLIB_TL_TA.UTILITIES.FieldFormula Name:InsertEffdtRow PCPC:8730
Statement:153
Called from:FUNCLIB_TL_TA.UTILITIES.FieldFormula Name:UpdateWhereClause
Statement:495
Called from:CONTROL_TL_TA.TL_UPDT_WHERE_BTN.FieldChange Statement:1

 

Replication Steps:

1 Navigate to Root > Set Up HCM > System Administration > Utilities > Build Time and Labor Rules > SQL Objects

2. Create a new SQL object that will require a new Effdt-row.

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