My Oracle Support Banner

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.


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
Called from:FUNCLIB_TL_TA.UTILITIES.FieldFormula Name:UpdateWhereClause
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.


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

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