1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

HR API's

Discussion in 'Oracle HRMS & Payroll' started by rsamlal, Apr 12, 2013.

  1. rsamlal

    rsamlal Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Hi all
    Do you happen to know what HR API's are available and where I can find these?
    regards
    Rsihi
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Rsihi,

    Please run the below query to know the API's available for HRMS..

    Code (Text):

    SQL>select substr(a.OWNER,1,20)
    , substr(a.NAME,1,30)
    , substr(a.TYPE,1,20)
    , substr(u.status,1,10) Stat
    , u.last_ddl_time
    , substr(text,1,80) Description
    from dba_source a, dba_objects u
    WHERE 2=2
    and u.object_name = a.name
    and a.text like '%Header%'
    and a.type = u.object_type
    and a.name like 'HR%API%'
    order by
    a.owner, a.name;
     
    If we run the above query we can see the list of API's available on HRMS. If we change that value from HR to PO then we can see Purchasing API's.

    If you want to know any particular API to update or create or delete HR Record let us know here on that. By that we can help you on the appropriate API.
     
  3. rsamlal

    rsamlal Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Bharat
    many thanks! Do you know how to track the required fields/tables/columns for a specific API?
    Some context: I'm designing an inbound HR interface (from SAP HCM to Oracle HRMS) and want to use the API's.
     
  4. rsamlal

    rsamlal Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Bharat-ji
    I've already found the info on the API with their available parameters. So pls ignore my previous mail. Again, many thanks.
    regards
    Rishi
     
    Bharat likes this.
  5. noman.jahangir

    noman.jahangir Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    100
    Code (SQL):
    SELECT *
    FROM all_objects
    WHERE object_name LIKE 'HR%\_API' escape '\'
    and object_type = '
    PACKAGE'
    union
    select *
    from all_objects
    where object_name like '
    PAY%\_API' escape '\'
    and object_type = '
    PACKAGE'
    union
    select *
    from all_objects
    where object_name like '
    PER%\_API' escape '\'
    and object_type = '
    PACKAGE'