This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Feb 27, 2013 3:04 PM by OzzieJeroen RSS

Error while download HR integrator having parameter

user-Keen Explorer
Currently Being Moderated
We created HR integrator and then selected Standalone_Integrator_Queries for assigning parameters which are following.


Example:
Integrator Name - CUSTOM TEST People3 INTG
SQL Where Clause – WHERE EFFECTIVE_DATE = '31-DEC-4712' AND EMPLOYEE_NUMBER = $PARAM$.EMPLOYEE_NUMBER
1st Parameter Name – EMPLOYEE_NUMBER
1st Parameter Type – Varchar2
1st Parameter Prompt– EMPLOYEE_NUMBER

Below error while download file for particular employee.

SQL error: ORA-00904: "EFFECTIVE_DATE": invalid identifier occurred processing stored SQL for Content 800:GENERAL_362_CNT.
Download parameters are not complete

Secondly, now if remove effective parameter coditions and reload the same then layout taking twice input for the employee field, is there any table which is configured parameter with integrator

thanks
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points