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
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
Hi,
ReplyDeleteThanks for the blog.
It is very helpful.
Could you please also explain about adding content parameter on similar example
yes please that would be really helpful
DeleteHi,
ReplyDeleteI 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.
Looks like you are missing some functions in your Web ADI responsibility menu.
DeletePlease 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.
Is there any manual how to properly configure a resposibility to use custom integrators ?
Deleteeg. I need to let AR user to import invoices without giving him/her Desktop Integrator responsibility)
Please check the last section of the above article, you just need to add the form function the respective responsibility menu.
DeleteI wanted to create a query with a parameter to restrict the rows and then upload the changed rows. How can I do this ?
ReplyDeleteHello I have created one Interface attached to Custom Integrator. That interface is of Table Type.
ReplyDeleteFurther 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
Thanks for sharing this amazing blog..
ReplyDeletecustom web application development
custom website development
ReplyDeletei am pleased with the post here when i was reading oracle training in chennai
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.
ReplyDeletevery interesting content, your way of approach like that Attar Packaging boxes pls visit you have get a more ideas what we have do
ReplyDeleteThis is fantastic novel. I am glad to learn this valuable information Luxury Rigid Box manufacturer
ReplyDelete