Fusion Global HR: JBO-27122 SQL Statement Preparation Error Message In The Audit Process And Validation Of Position Tree (Doc ID 1618084.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Manage Position Trees
---------------------------------
Issue

Enter a position tree, change status to valid and start the audit procedure. During effective date validator get error JBO-27122 : SQL Error during statement preparation, Statement: Select sysdate FROM dual

Steps to duplicate:

Setup and Maintenance;
Overview;
Name: POSITION TREE -> Search
Manage Position Tree -> Go to Task
Expand Tree POSITION TREE QGOG
Select next level POSITION TREE QGOG
Action -> Set Status -> Active
Button: "On Line Audit"
Starts the procedure Audit...
Message Error: Error in Audit
//----------------------------------------------------------
[18:54:04] Starting Validator AuditProcessor:Executing Basic Validations
[18:54:04] Starting Validator AuditProcessor:Executing Tree Structure based validations
[18:54:04] Starting Validator AuditProcessor:Basic Validations passed during tree version audit
[18:54:04] Starting Validator AuditProcessor:Executing node level validations for tree version
[18:54:04] Starting Validator AuditProcessor:audit completed for 0 nodes.
[18:54:37] Starting Validator AuditProcessor:audit completed for 1000 nodes.
[18:55:06] Starting Validator AuditProcessor:audit completed for 2000 nodes.
[18:55:14] Starting Validator AuditProcessor:Executing usage limit validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed usage limit validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed node level validations for tree version
[18:55:14] Starting Validator AuditProcessor:Executing effective date validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed effective date validations for tree version
[18:55:14] Starting Validator AuditProcessor:Executing Active Version validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed Active Version validations for tree version
[18:55:14] Starting Validator AuditProcessor:Executing Referenced Tree Version validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed Referenced Tree Version validations for tree version
[18:55:14] Starting Validator AuditProcessor:Executing root node validations for tree version
[18:55:14] Starting Validator AuditProcessor:Completed root node validations for tree version
[18:55:14] Starting Validator Name: Effective Date Validator
[18:55:14] An error occured during the audit process
[18:55:14]
[18:55:14] JBO-27122: SQL error during statement preparation. Statement: SELECT sysdate FROM dual

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