1 2 Previous Next 16 Replies Latest reply: Feb 27, 2013 5:04 PM by Jeroen van Meenen RSS

    Error while download HR integrator having parameter

    user-Keen
      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