Skip to main content

Search all views and Materialized Views by part of text - Oracle Apps Views

Views:


 Step1: Create a Temporary Table based on ALL_VIEWS View.

 create table search_all_views as
select  av.owner, av.view_name, to_lob(text) as text_clob
from    ALL_VIEWS av;

 Step2: Search based on Part of text based on Temporary table created in Step1. 

 select * from search_all_views where text_clob like '%Enter Text Here%'

 Step3) Drop the Temporary Table created in Step1.

 drop table search_all_views;


Materialized Views:

Step1: Create a Temporary Table based on ALL_MVIEWS View.

 create table search_all_mviews as
select  av.owner, av.mview_name, to_lob(query) as text_clob
from    ALL_MVIEWS av;

 Step2: Search based on Part of text based on Temporary table created in Step1. 
select * from search_all_mviews where text_clob like '%xwii_osp_util_pk.get_osp_name_locator%'

 Step3) Drop the Temporary Table created in Step1.
drop table search_all_mviews

Comments

Post a Comment

Popular posts from this blog

Xdoxslt XML Publisher RTF Important Syntax’s     1.        To convert CASE of a tag to UPPER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     2.        To convert CASE of a tag to LOWER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     3.        Syntax for CONTAIN      contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT MEMO’)     4.        Syntax for NOT CONTAIN      not(contains(xdoxslt:convert_case(.//REFERENCE_ID,'UPPER'),'WSC'))     5.        CHOOSE-WHEN-OTHERWISE Syntax     <?choose:?><?when: contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT       MEMO’)?><?’Interco Credit Memo’?><?end when?><?otherwis...
Post a Comment
Read more

Customize New Oracle Apps Form (11i and 12i)

Create and Register of a Custom Form in Oracle Applications(11i and R12) Steps to Create a new form in oracle Apps R12   1. Check the Form builder version is compatible with your application server or not. 2. Download all the necessary .FMb and .PLL files from the server     FMB- TEMPLATE.fmb and APPSTAND.fmb files Server location FMB -$AU_TOP/forms/US Server location PLL - $AU_TOP/resource (Try to download all PLL files) First try to download below PLL files see if it works .If it does work then you don't need to download all the PLL files APPCORE.pll                   APPCORE2.pll              APPDAYPK.pll APPFLDR.pll                   CUSTOM.pll    ...
Post a Comment
Read more

Enable/disable a trace to a Concurrent Program - Oracle Apps Reports Trace

How do you enable/disable a trace to a Concurrent Program? 1. Connect to Oracle Applications 2. Navigate to System Administrator->Concurrent->Program->Define 3. Query the concurrent program on which you want to enable trace. 4. Check the enable trace check box bottom of the screen, Save it. 5. Ask the developer to submit the request, Once the request got submitted and completed normal. 6. Get the spid as select oracle_process_id from apps.fnd_concurrent_requests where request_id=456624. 7. You will get a spid like 12340. 8. Goto Udump and ls -ltr *12344*. 9 . You will get trace file
Post a Comment
Read more