ETL9.2: Peoplecode error when creating SQL Objects through the SQL Objects component
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
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.
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