1 Reply Latest reply: Jul 22, 2013 4:35 AM by Kwesi Fox RSS

    ORA-20001 FLEX-ID DOES NOT EXIST

    Kwesi Fox

      Hi Experts,

       

      Please am having this issue when running create Grade api for HCM of Oracle EBS.

       

      When i execute this script below to existing Business Group( Vision University 1759 or Vision Corporation 202 ) data is transferred to per_grades and per_grade_definitions tables

       

      But when i execute this same script pointing to a Business Group  (TEST  BG 7891) we created by ourself  it gives error code ORA-20001 FLEX-ID DOES NOT EXIST

       

      I have a strong feeling that creating our Business Group and setting up the Grade Flexfield has a problem, but i can 't trace the fault, am not EBS expert

       

      Please can you please advice where am going wrong !!

       

       

      Thanks,

      Kwesi

       

       

       

      SCRIPT BELOW:

       

      Procedure Create_Grade

      is

      l_Validate  Boolean := FALSE;

      l_Business_Group_id Number(15,2);

      l_Date_From Date;

      l_Sequence  Number(15,2);

      l_Grade_id  Number(15,2);

      l_Object_Version_Number Number(15,2);

      l_Grade_Definition_id Number(15,2);

      l_Name  Varchar2(100);

      l_OVN Number(15,2) := 1;

      i Number;

      Begin

      For Grad In (Select * from chr_Grades where OVN IN l_OVN) loop 

      Begin

      apps.hr_grade_api.Create_Grade(

      p_Validate => l_Validate,

      p_Business_Group_id =>7891,

      p_Date_From => to_Date(sysdate,'DD-MM-YYYY'),

      p_Sequence => 11,

      p_Grade_id => l_Grade_id,

      p_Object_Version_Number => l_Object_Version_Number,

      p_Grade_Definition_id => l_Grade_Definition_id,

      p_Name => l_Name,

      p_segment1 => Grad.Grade_id,

      p_segment2 => Grad.Grade_Name,

      p_segment3 => Grad.Grade_Description

      );

       

      Update chr_Grades Set OVN = 2

         where Grade_id  = Grad.Grade_id;

            End;

      End loop;

       

      Commit;

       

      End Create_Grade;