Tuesday, April 11, 2017

Difference between Open Interface and API in Oracle Apps


Open Interfaces-
  • In EBS one Open Interface may run many API calls.
  • Open Interface run asynchronously.
  • The good is that if there is failure of record, they remain in the table until either fixed or purged.
  • They automate the interface into the APIs.
  • This requires less work and less code as few SQL DML would simply .
APIs-
  • When there is no corresponding Open Interface.
  • Normally all Oracle APIs run synchronously, and provide immediate responses, therefore machism to be provided to handle such situation.
  • That requires custom error handling routine.
  • This may requires lot more effort as these need fine grain control approach.

2 comments:

  1. Hi,
    interviewer asked me when to use API and when to use open interface? if both does the same work

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete