ORA-20001: HR_FLEX_VALUE_MISSING:

Good day All,

Im tying to do an upload of jobs. im usinr the hr_pi_job.create_job api.. but running into the error

 "XUpload exception - -  ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, SEGMENT1, N, PROMPT, Job Name".

So im wondering, is there something i need to do before this can work??

HERE'S THE PROCEDURE:

CREATE OR REPLACE PROCEDURE APPS.Xxfbn_Job_UPLOADAS

v_business_group_id NUMBER;

l_job_group_id NUMBER;

v_job_id NUMBER;

v_job_definition_id NUMBER;

v_object_version_number NUMBER;

v_name VARCHAR (99);

lc_errmsg VARCHAR (2000);

CURSOR CURSOR1

IS