none
Mapping Oracle EBS Adapter Functions to Oracle EBS Screens or Views RRS feed

  • Question

  • I am trying to use the EBS adapter to query data from an EBS instance.

    There is one screen in EBS in particular, that I am trying to find: the iProcurement Worklist page which shows the All Notifications view, listing all the PO Requisitions that require that users approval.

    However, finding the right view for this screen, has become quite difficult.

    When I use the "Add Adapter Service Reference" wizard in the Visual Studio, the BizTalk Adapter for Oracle EBS shows me a list of the exposed functions available to me.
    Under Applications, I can see a long list of different applications, including Purchasing, under which I see three sections, Interface Tables, Interface Views, and Concurrent Programs. Under Interface Views, I see things like PO_NOTIFICATIONS.

    Now, I am trying to figure out how to map the items shown in this wizard to the screens in the EBS interface.

    If anyone can help me figure out which item in the wizard I need to use to get the All Notifications data, I would really appreciate the help. Thanks in advance!
    Monday, July 21, 2008 5:41 PM

Answers

  • Hi!

    EBS does not expose any API to access the forms programatically, and hence the adapter is forced to expose the underlying interface tables, PL/SQL APIs and so on as they are defined in the database. That is also the reason why these artifacts are not grouped by forms. You might get more information on what underlying artifacts a particular form uses from the EBS documentation. 

     

    Thanks,

    Manas.

    Tuesday, July 22, 2008 5:19 AM

All replies

  • Hi!

    EBS does not expose any API to access the forms programatically, and hence the adapter is forced to expose the underlying interface tables, PL/SQL APIs and so on as they are defined in the database. That is also the reason why these artifacts are not grouped by forms. You might get more information on what underlying artifacts a particular form uses from the EBS documentation. 

     

    Thanks,

    Manas.

    Tuesday, July 22, 2008 5:19 AM
  • Basically, the EBS adapter surfaces interface tables/views, concurrent programs and PL/SQL APIs that can be used to access various Oracle apps applications. These artifacts are placed under the respective application node in the browse tree. So, iProcurement related artifacts could be under the “Purchasing” application which should be visible under the “Applications” node in the tree. Note that in EBS 11.5.10 systems, for lack of metadata in the Oracle database, one may not be able to view the PL/SQL APIs under the respective application node. The PL/SQL APIs in this case would be surfaced under the Database à APPS à PL-SQL APIs node. We are working on how we could make the metadata richer by also showing product family names, but that would be governed by the availability of metadata in the Oracle database.

     

    To answer your specific question about ‘iProcurement All Notifications”, you may need the help of an Oracle EBS technical consultant who could point to the tables/concurrent programs/PL-SQL APIs that would need to be used. Oracle also provides online functional documentation (and technical documentation) on each of the applications that can be used to understand what artifacts to use.

     

    Friday, August 1, 2008 4:59 AM