Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Error ORA-00907: missing right parenthesis while performing full load for HCM

Question

Views

Comments

3231950 Rank 2 - Community Beginner

Nov 1, 2016 10:22AM in Oracle Business Intelligence Applications

Hi,

I am facing the following error when i am performing the first full load for the HCM module. we are implemeting 11.1.1.10 .

the full error is the following:

ODI-1228: Task SDE_PSFT_TalentMgmt_AchievementsFact.W_TLNT_PRFL_ACHVMNT_FS (Integration) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Is there any fix for this issue ?

Thanks in advance

MFA for Oracle Community

Oracle Business Intelligence Applications

Categories

Error ORA-00907: missing right parenthesis while performing full load for HCM