Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Question
1
Views
0
Comments
3231950
3231950 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications Forum

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