Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle Web ADI Information Query

Posted on December 14th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Often at the time of working with Oracle Web ADIs, we want to know what all components are associated with it like Integrator, Layout, Mapping, Underlying PL/SQL procedure etc.

Also while migrating Web ADIs from one instance to another (in case of Installation upgrades, or from Development Instance to Production Instance), using FNDLOAD, we need to know each associated component of a Web ADI to migrate it completely.

<pre lang="plsql">

SELECT DISTINCT
bit.application_id APP_ID,
bit.user_name INTEGRATOR_NAME,
bit.integrator_code INTEGRATOR_CODE,
blcv.layout_code INTEGRATOR_LAYOUT,
bm.mapping_code INTEGRATOR_MAPPING,
biv.interface_name API,
biv.upload_type TYPE,
bc.content_code
FROM
bne_integrators_tl bit,
bne_layout_cols_v blcv,
bne_layouts_b bl,
bne_interfaces_vl biv,
bne_contents_vl BC,
bne_mappings_vl BM
WHERE
bit.INTEGRATOR_CODE = biv.INTEGRATOR_CODE
AND biv.interface_code = blcv.INTERFACE_CODE
AND bit.integrator_code=bl.integrator_code
AND bit.integrator_code=bc.integrator_code
AND bit.integrator_code=bm.integrator_code
AND UPPER(bit.user_name) LIKE UPPER('<integrator USER name>')
</pre >

The query enables a you to reduce his time spent on analysis of a Web ADI. All that one should know is the name of the Integrator of the Web ADI. Even the end user (Business User) would know the name of the Integrator that they are using.

Related Posts

Posted in Web ADI | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.