OracleAppsDNA

Information about Oracle APIs and How to find APIs of Oracle Modules?

Generally developers will be in need of APIs to add/modify data on existing tables but its a bit difficult task to find out APIs

What is an API?

An application programming interface (API) is a source code based specification intended to be used as an interface by software components to communicate with each other. Even ever a data is entered on an Oracle Form, the data will be picked up by the corresponding APIs, validated and inserted into respective predefined tables by taking processing constraints into consideration.

Types of Oracle APIs

For more information on type of APIs click here

How to find APIs?

Its difficult for a developer to find out APIs from DBA_OBJECTS table, so Oracle Corp. has come up with a web portal named Oracle Integration Repository (iRep) to access all public APIs.

Oracle® Integration Repository

Oracle Integration Repository is a compilation of information about the numerous interface endpoints exposed by Oracle applications. The full list of public APIs and the purpose of each API is available in the integration repository. It provides a complete catalog of Oracle E-Business Suite’s business interfaces, and a comprehensive view of the interface mechanisms available. You can use this tool to easily discover and deploy the appropriate business interface from the catalog for integration with any system, application, or business partner.

Website URL: http://www.irep.oracle.com/

Release 12 Integration Repository

In Oracle EBS R12, Integration Repository is bundled as a part of EBS suite as a responsibility “Integrated SOA Gateway”.

Where are these APIs Stored?

Each API is placed in a file with extension as ‘pls'(pl/sql source code file). These pls files are stored in Unix box in the following path

$APPLICATION_TOP/patch/115/sql/

Query to find APIs

You can use the below query to find out the APIs to some extent

 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 'PA_%API%'
ORDER BY a.owner,
  a.name;

Here PA is application short name of Project Accounting application

Exit mobile version