Error When Using Submission E-signature Fields in Recruiting Subject Area: [ORA-00904: "T412"."ELECTRONICSIGNATURENO": invalid identifier at OCI call OCIStmtExecute]
Last updated on NOVEMBER 27, 2017
Applies to:Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 15B to 17A [Release 15 to 17]
Information in this document applies to any platform.
Adding any Submission E-Signature fields in the Recruiting Subject Area (Job Submission > Submission E-Signature) causes the analysis to produce the error:
Oracle Error code: 904, message: ORA-00904: "T412"."ELECTRONICSIGNATURENO": invalid identifier at OCI call OCIStmtExecute.
The Submission E-Signature fields are newly added fields in 15B.3 (Maintenance Pack 3).
- in 15B.4 and below, a different error is thrown: "table or view does not exist"
- in 15B.5 - 15B.8, the "invalid identifier" is thrown only when you add any field with the "E-Signature" fields (they run fine by themselves but once you add Candidate Identifier or Req. Identifier, they error out)
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