Thursday, September 10, 2015

Custom Web ADI (Download/Upload)

Now we will integrate the download and upload ADIs. We will use the same custom table and packaged procedure used separately in download and upload.


Responsibility: Desktop Integration Manager
> Create Integrator

 XXAK: Test Web ADI
XXAKTESTWEBADI

Check the box for ‘Display in Create Document Page’



Add these three functions
Code:
BNE_ADI_DEFINE_MAPPING
BNE_CREATE_DOCUMENT
BNE_ADI_CREATE_DOCUMENT


Interface type here would be ‘API Procedure’
Package Name: xxak_testadi_pkg
Procedure/Function Name: load_record
API Returns : Error Message



Apply
You can click on ‘Update’ and change prompt and other details required


Create Content
Content type would be ‘SQL Query’
Query : SELECT order_number
      ,start_date
      ,end_date
      ,business_area
      ,batch_number
      ,status
  FROM XXAK_WEB_ADI_DOWNLAOD_TBL
Test Query


Apply

Create Uploader
Uploader: From Template
Select check boxes as below

Skip ‘Create Importer’
Submit


Define Layout
Navigation: Desktop Integrator -> Define Layout -> Select the Integrator


Go > Create

Change the Placement to 'Line'


Next

Apply

Create Mapping
Responsibility: Desktop Integrator
        > Define Mapping
  • Mapping between ‘Interface’ and ‘Content’ data
Apply

Add a form function and add to specified responsibility menu

Responsibility: Application Developer
           > Application > Function
Type: SSWA servlet function
HTML Call: BneApplicationService
Parameter: bne:page=BneCreateDoc&bne:integrator=20003:XXAKTESTWEBADI_XINTG&bne:layout=20003:XXAKTESTWEBADI
select integrator_app_id || ':' || integrator_code integrator
     , application_id || ':' || layout_code layouts
  from bne_layouts_b
 where integrator_code like 'XXAK%'
Add this Function to the specified Menu and go to the related responsibility
Create Document








13 comments:

  1. Hi,

    Thanks for the blog.
    It is very helpful.

    Could you please also explain about adding content parameter on similar example

    ReplyDelete
  2. Hi,

    I created web ADI with interface details(package procedure) and content details(select statement from table) . But when I try to define mapping between Interface and content , the page does not allow me to do that . It shows you do not have access to this functionality.

    Also If I add the function BNE_ADI_DEFINE_MAPPING while creating integrator- the Integrator is not at all visible in the drop down while trying to create LAYOUT. Is there something missing? Please can you suggest.

    ReplyDelete
    Replies
    1. Looks like you are missing some functions in your Web ADI responsibility menu.

      Please check, and if missing add below functions to the respective menu.

      GL_INQ_SEARCH
      GL_INQ_FSG_DRL_LAUNCH
      GL_INQ_FSG_DRL_CONTENT
      GL_INQ_FSG_DRL_EFF_RNG
      GL_INQ_FSG_DRL_BAL_INQ

      Make sure you add the exact function, you have same function name with _G.

      Compile the menu and bounce the system and see if it is working.

      Delete
    2. Is there any manual how to properly configure a resposibility to use custom integrators ?

      eg. I need to let AR user to import invoices without giving him/her Desktop Integrator responsibility)

      Delete
    3. Please check the last section of the above article, you just need to add the form function the respective responsibility menu.

      Delete
  3. I wanted to create a query with a parameter to restrict the rows and then upload the changed rows. How can I do this ?

    ReplyDelete
  4. Hello I have created one Interface attached to Custom Integrator. That interface is of Table Type.
    Further created Layout for same But while creating Document and uploading data directly into table, getting error message 'Can not Execute Sql' and it got error out.
    Please help how to figure this out

    ReplyDelete

  5. i am pleased with the post here when i was reading oracle training in chennai

    ReplyDelete
  6. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion HCM .Actually I was looking for the same information on internet for Oracle HCM Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  7. very interesting content, your way of approach like that Attar Packaging boxes pls visit you have get a more ideas what we have do

    ReplyDelete
  8. This is fantastic novel. I am glad to learn this valuable information Luxury Rigid Box manufacturer

    ReplyDelete