OBIA 796 DAC Load Using -lpf Option for pmcmd Command Instead of the -paramfile Option Configured in infa_command.xml (Doc ID 2010115.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

$$HR_WRKFC_EXTRACT_DATE Parameter is not getting picked up by DAC, so the ETL mappings are failing with the following error:-

2014-12-12 19:38:00 : ERROR : (1426 | READER_1_1_1) : (IS | Infa_BI_iHDEV) : xxx.yyyy.zzzz.net : RR_4035 : SQL Error [
ORA-00936: missing expression

Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : SELECT IASG.EMPLID ,IASG.EMPL_RCD ,IASG.ASSGN_END_EVENT_DT
,CASE WHEN IASG.ASSGN_END_EVENT_DT = JOB.EFFECTIVE_START_DATE OR
                            IASG.ASSGN_END_EVENT_DT = PERF.EFFECTIVE_START_DATE OR
                            IASG.ASSGN_END_EVENT_DT = SPVST.EFFECTIVE_START_DATE
              THEN 0
              ELSE 1
END
,IASG.DATASOURCE_NUM_ID ,JOB.HR_ORG_ID ,JOB.HR_ORG_PRV_ID,JOB.JOB_ID ,JOB.JOB_PRV_ID
,JOB.PAY_GRADE_ID,JOB.PAY_GRADE_PRV_ID,JOB.HR_POSITION_ID ,JOB.HR_POSITION_PRV_ID
,JOB.LOCATION_ID ,JOB.LOCATION_PRV_ID ,JOB.SUPERVISOR_ID ,JOB.SUPERVISOR_PRV_ID ,JOB.REPORTS_TO
,JOB.REPORTS_TO_PRV ,JOB.EMPL_TYPE ,JOB.EMPL_STATUS ,JOB.PER_ORG ,JOB.JOB_INDICATOR
,JOB.FULL_PART_TIME ,JOB.REG_TEMP ,JOB.FLSA_STATUS,JOB.UNION_CD ,JOB.REG_REGION  ,JOB.EMPL_CLASS
,JOB.SETID_EMPL_CLASS ,JOB.COMP_FREQUENCY,JOB.BUSINESS_UNIT_HR ,JOB.BUSINESS_UNIT_GL
,JOB.COMPANY, JOB.PAYGROUP,JOB.CURRENCY_CD,JOB.ORIG_HIRE_DT,JOB.HIRE_DT,JOB.LAST_HIRE_DT,JOB.ORG_INST_SRV_DT
,JOB.SERVICE_DT,JOB.DEPT_ENTRY_DT,JOB.JOB_ENTRY_DT,JOB.GRADE_ENTRY_DT,JOB.POSITION_ENTRY_DT,JOB.LAST_PROM_DT
,JOB.LAST_SAL_INCR_DT,JOB.HEADCOUNT,JOB.FTE,JOB.COMPRATE ,JOB.ANNUAL_RT,JOB.MONTHLY_RT,JOB.DAILY_RT,JOB.HOURLY_RT
,PERF.PERF_NRMLZD_RATING,PERF.REVIEW_RATING,JOB.STD_HOURS_MONTH,JOB.EMP_IND,JOB.CWR_IND
,SPVST.SUPERVISOR_FLAG
,'0'  X_CUSTOM
FROM
W_PSFT_WEVT_IASG_PS  IASG
LEFT OUTER JOIN W_PSFT_WEVT_PERF_PS  PERF
 ON IASG.EMPLID = PERF.EMPLID AND
         IASG.EMPL_RCD = PERF.EMPL_RCD AND
         IASG.DATASOURCE_NUM_ID = PERF.DATASOURCE_NUM_ID AND
         IASG.ASSGN_END_EVENT_DT BETWEEN PERF.EFFECTIVE_START_DATE
                                     AND PERF.EFFECTIVE_END_DATE
LEFT OUTER JOIN W_PSFT_SUPV_STATUS_PS  SPVST
 ON  IASG.EMPLID = SPVST.EMPLID AND
         IASG.DATASOURCE_NUM_ID = SPVST.DATASOURCE_NUM_ID AND
         IASG.ASSGN_END_EVENT_DT BETWEEN PERF.EFFECTIVE_START_DATE
                                     AND PERF.EFFECTIVE_END_DATE
,W_PSFT_WEVT_JOB_PS   JOB
WHERE IASG.EMPLID = JOB.EMPLID
AND IASG.EMPL_RCD = JOB.EMPL_RCD
AND IASG.DATASOURCE_NUM_ID = JOB.DATASOURCE_NUM_ID
AND IASG.ASSGN_END_EVENT_DT BETWEEN JOB.EFFECTIVE_START_DATE
                                     AND JOB.EFFECTIVE_END_DATE
AND JOB.MAX_EFFSEQ_IND = 1
AND JOB.TERMINATION_DT IS NULL
AND IASG.ASSGN_END_EVENT_DT > 

Oracle Fatal Error].
2014-12-12 19:38:00 : ERROR : (1426 | READER_1_1_1) : (IS | Infa_BI_iHDEV) : node01_xxxx.zzz.uu.xxx.net : BLKR_16004 : ERROR: Prepare failed.
2014-12-12 19:38:00 : INFO : (1426 | WRITER_1_*_1) : (IS | Infa_BI_iHDEV) : node01_xxxx.zzz.uu.xxx.net : WRT_8333 : Rolling back all the targets due to fatal session error.
2014-12-12 19:38:00 : INFO : (1426 | WRITER_1_*_1) : (IS | Infa_BI_iHDEV) : node01_xxxx.zzz.uu.xxx.net : WRT_8325 : Final rollback executed for the target [W_WRKFC_EVT_FS] at end of load
2014-12-12 19:38:00 : INFO : (1426 | WRITER_1_*_1) : (IS | Infa_BI_iHDEV) : node01_xxxx.zzz.uu.xxx.net : WRT_8035 : Load complete time: Fri Dec 12 08:08:00 2014

 

NOTE: The pmcmd command that DAC generates is using -lpf(default setting) instead of -paramfile, though the configuration is done for -paramfile in infa_command.xml.


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