How to Load a .csv file into Oracle Custom Forms via Push Button - EBS R12. How to upload file using Oracle Form

Here we create a form and add the button (File Location) and when the button is pressed, you will select a file such as ''Danish_Attandance.csv'' from your PC. When the file has been uploaded to the table, you can view the data in the following block by clicking the button (View).

Step 1:

First Make the CSV file for Upload in the Custom Form.

 

 

Step 2:

Make CTL File for Upload the Csv file data into the Table.

 

 

 

Step 3:

Create Custom Table (XX_TIME_ATTENDANCE_DATA_LOAD) for Store the Csv File Data.

 

 

 

CREATE SEQUENCE RKCM_UPLOAD_S

  MINVALUE 1

  MAXVALUE 999999999999999999999999999

  START WITH 1

  INCREMENT BY 1

  CACHE 20;

  

 Step 4:

Copy the XXCUS_PAY_EMP_ATTAN_CTL.ctl file to the <bin> folder of the Custom_Top.

 

/a01/appltest/RMCTEST/fs1/EBSapps/appl/xxrmc/12.0.0/bin

 

 

 Step 5:

Make a Concurrent Program to Upload the CSV Data to STG Table.

Navigation >> Application Developer >> Concurrent >> Executable

 

 

XXCUS_PAY_EMP_ATTAN_CTL

Navigation >> Application Developer >> Concurrent >> Program

 

 

  

Step 5:

Make a custom form to upload csv File from oracle Custom forms and then show the data into the Block.

 

 

 Full Screen:

 

 

 

In File_Location Button : Here we call the Bowser to Select the Csv file from the PC (Our Location Machine).

 

We have create a Program Units Procedure “file_attached”

 

 

 

 

 

 

 

 

 

Here Point 1 :

Here we are set the Path of the Csv File.

 

 

Here Point 2 :

Here we are call the Database Procedure (WRITE_BLOB_TO_FILE_DH.prc) to Write Blob file to the Server Path. (Means Populate the CSV file to the Oracle Server at the respective Path)

 

 

/a01/oratest/RMCTEST/12.1.0/appsutil/outbound/RMCTEST_dev5

 

 

 

 If the Above Procedure getting error

ORA-29280: invalid directory path using directory in SQL 

 

Run the Script :

 

SELECT *

  FROM V$PARAMETER

  WHERE NAME = 'utl_file_dir'

 

Take the Value as a Path upto (,) of any Path to store the BLOB File in the Server.

 

  

Here Point 3 :

Here we call the Concurrent Program of the CTL File to Store the Data From CSV to STG Table.

 

Step 6:

After Click on the Upload Button a concurrent program is submitted and a Request ID is generated.

If the Program RUN successfully then Data is inserted into the Table “XXCUS_PAY_ATTAN_DOC_UPLOAD”.

 When we Click on the View Button the Stored Data is Shown into the Bellow Block.

 

 

GO_BLOCK ('XX_TIME_ATTENDANCE_DATA_LOAD');

clear_block(no_commit);

EXECUTE_QUERY;

 

 Create the BLOCK USING Wizard “XXCUS_PAY_ATTAN_DOC_UPLOAD “

 

 

Save the Form.

Place it to the AU_TOP and Then Compile the form.

 

Register the Form and Attached to the Menu.

Step 7:

 

When we open the Employee Attendance Upload Form

  

 

 

 

 

 

When we click on the File Location Button. Then One popup is open

 

 

In the java HTML Page to Upload the File.

 

Here Point 1 : Click on the Browse Button to select the File from the Local Machine (PC or Laptop).

 

Here Point 2 : Then Click on the Submit Button to Save the File.

 

 

 

After Submit the message is coming and CLOSED the “GFM Upload” Tab.

Go the Custom Form and Click on the Yes Button.

 

 

File name is shown in the Text Box (Which CSV file we want to upload into the Below Block)

 

 

When we click on the Upload Button Then a concurrent program is fire and give the popup with Request Id.

 

 

 https://docs.google.com/document/d/15K3e2s0gbz2L9pjnRMCqHok_UBaATIW9/edit?usp=drive_web&ouid=110206717487512832707&rtpof=true

If the Program is Run Successfully then click on the View Button to See the Data in the below Block.

 

 

 https://docs.google.com/document/d/15K3e2s0gbz2L9pjnRMCqHok_UBaATIW9/edit

 

Thanks You

 

How to make a form read only in oracle forms Using Form Function Registration in EBS R12

 

How to make a form read only in oracle forms Using Form Function Registration in EBS R12

In this post, we will be discussing about, how to make a form read only in oracle forms using Form Function. To make a form read only is very easy process in oracle apps. We just need to know that oracle form name, which we want to make read only. Then we can make the form ready only after doing some small change in the form registrations. We need to go to the Oracle Form registration, to make any form read only. Here below is the complete detail about how to make a form read only in oracle forms.

 

Step by Step to make a form read only in oracle forms

 

Step1: - For Example in Our Case, We want to make the Oracle CUSTOM Form (Employee Master) a read only for some users.

 Go to that Form as below.

How to make a form read only in oracle forms

 Go to Help => About Oracle Applications for find the form Name

 

  

Step 2) Now We need to go to the Application Developer > Application> Function

and query for this Custom form (XXCUS_PAY_EMPLOYEE_MASTER) and find out the form function associate with enter XXCUS_PAY_EMPLOYEE_MASTER form.

How to make a form read only in oracle forms

 

Step 3) Now we need to Create a new form function name for this same Form Name (XXCUS_PAY_EMPLOYEE_MASTER_V) having logically similar name as that of original function and in the form, tab make QUERY_ONLY=YES

This New Form Function Name we have given ‘XXCUS_PAY_EMPLOYEE_MASTER_V’.

 

How to make a form read only in oracle forms

 

In Form Function > Click on the Form Tab and Then Choose the Function (XXCUS_PAY_EMPLOYEE_MASTER_V)

And then choose the Form Tab (XXCUS_PAY_EMPLOYEE_MASTER) Main form which we want to make View Only

And Parameter Tab write the query (QUERY_ONLY=YES)

 

Step4:- Now, We need to go the Responsibility Menu under which we want to Attach this new function.

 

Wright the Prompt : Texmaco Element Master View Only and Choose  the Function (XXCUS_PAY_EMPLOYEE_MASTER_V)

And Description (Texmaco Element Master View Only)

 

Step5:- As below , Now our Employee Master form is showing read only.

 

 

How to Update the Oracle Application Site Name Or Instance Clone Name Using Profile Option In R12 EBS

 How to Update the Oracle Application Site Name Or Instance Clone Name Using Profile Option In R12 EBS

Go to the System Administrator --> Profile --> System-->

Then Search the : %Site%  in the Profile Option

and Then Change the Site Name : Texmaco Payroll.

Save.

 

Oracle Apps Script for Download the Details of Custom Objects from Oracle DataBase and Application Server Like fmb, rdf, Xml, rtf, OAF, ldt script for cp etc

Oracle Apps Script for Download the Details of Custom Objects from Oracle Database and Application Server Like fmb, rdf, Xml, rtf, OAF, ldt script for cp etc 

-----------------------------------------------------

-- FOR ALL OBJECT_NAME - (CUSTOM DEVELOPMENT OBJECTS)

-----------------------------------------------------

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXRMC%')

  -- AND TRUNC(LAST_DDL_TIME) > '05-May-21'   

  -- AND TRUNC(CREATED) >= '05-May-21'   

  --AND OWNER <> 'PWCSS'

  AND OBJECT_TYPE <> 'SYNONYM'  

 UNION ALL  

SELECT  OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXCUS%')

  -- AND TRUNC(LAST_DDL_TIME) > '05-May-21'

  --AND OWNER <> 'PWCSS'

  AND OBJECT_TYPE <> 'SYNONYM'  

UNION ALL

SELECT  OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXTEX%')

  -- AND TRUNC(LAST_DDL_TIME) > '05-May-21'

  --AND OWNER <> 'PWCSS'

  AND OBJECT_TYPE <> 'SYNONYM' 

UNION ALL

SELECT  OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND UPPER(AB.OBJECT_NAME) LIKE UPPER('RMC%')

  -- AND TRUNC(LAST_DDL_TIME) > '05-May-21'

  --AND OWNER <> 'PWCSS'

  AND OBJECT_TYPE <> 'SYNONYM'

UNION ALL

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XX_%')

  -- AND TRUNC(LAST_DDL_TIME) > '05-May-21'   

  -- AND TRUNC(CREATED) >= '05-May-21'   

  --AND OWNER <> 'PWCSS'

  AND OBJECT_TYPE <> 'SYNONYM'     

ORDER BY OBJECT_TYPE,OBJECT_NAME

  

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM SEQUENCE)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'SEQUENCE'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='APPS'

--AND STATUS = 'INVALID'

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM TABLE)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'TABLE'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='APPS'

--AND STATUS = 'INVALID'

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM INDEX)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'INDEX'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND STATUS = 'VALID'

--AND STATUS = 'INVALID'

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM VIEW)

-----------------------------------------------------

SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'VIEW'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='PWCSS'

--AND STATUS = 'INVALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM TRIGGER)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'TRIGGER'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='PWCSS'

--AND STATUS = 'VALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM FUNCTION)

-----------------------------------------------------

SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'FUNCTION'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='PWCSS'

--AND STATUS = 'VALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM PROCEDURE)

-----------------------------------------------------

SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'PROCEDURE'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='APPS'

--AND STATUS = 'VALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM PACKAGE)

-----------------------------------------------------

SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'PACKAGE'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='PWCSS'

--AND STATUS = 'INVALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM PACKAGE BODY)

-----------------------------------------------------

SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'PACKAGE BODY'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND AB.OWNER ='PWCSS'

--AND STATUS = 'INVALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM NOT EQUAL TO SYNONYM)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE 1=1

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

   AND OBJECT_TYPE <>'SYNONYM'

--AND AB.OWNER ='APPS'

--AND STATUS = 'VALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM SYNONYM)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'SYNONYM'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND STATUS = 'INVALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT_TYPE - (CUSTOM TYPE)

-----------------------------------------------------

SELECT AB.* 

  FROM ALL_OBJECTS AB

 WHERE AB.OBJECT_TYPE = 'TYPE'

   AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%' 

    OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%' 

OR AB.OBJECT_NAME LIKE 'XX%')

--AND STATUS = 'INVALID'

--ORDER BY AB.OBJECT_NAME

-----------------------------------------------------

-- FOR OBJECT LDT SCRIPT - (How to make ldt?)

-----------------------------------------------------

-----------------------------------------------------

-- FOR CONCURRENT PROGRAM (CP) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/Fire#321 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PWCSS_BBU_TRANSFER_CP.ldt PROGRAM APPLICATION_SHORT_NAME='PWCSS' CONCURRENT_PROGRAM_NAME='PWCSS_BBU_TRANSFER'

-----------------------------------------------------

-- FOR DATA DEFINITION (DD) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/Fire#321 0 Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct PWCSS004_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='PWCSS' DATA_SOURCE_CODE='PWCSS004' TMPL_APP_SHORT_NAME='PWCSS' TEMPLATE_CODE='PWCSS004'

-----------------------------------------------------

-- FOR FUNCTION (FUNC) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PWCSS001_FUNC.ldt FUNCTION FUNCTION_NAME="PWCSS001"

-----------------------------------------------------

-- FOR LOOKUP (LKUP) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct PWCSS_WIP_SUPPLY_SALES_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='PWCSS' LOOKUP_TYPE='PWCSS_WIP_SUPPLY_SALES'

-----------------------------------------------------

-- FOR MENU (MENU) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/ebsuat4#app O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PWCSS_SITE_SOLUTION_SU_MENU.ldt MENU MENU_NAME='PWCSS_SITE_SOLUTION_SU'

-----------------------------------------------------

-- FOR RESPONSIBILTY (RESP) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct POLYCAB_SITE_SOLN_SU_RESP.ldt FND_RESPONSIBILITY RESP_KEY='POLYCAB_SITE_SOLN_SU'

-----------------------------------------------------

-- FOR RTF (RTF) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD Fire#321 -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.7.4.210)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ebs_EBSDEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXPLY_POCM -APPS_SHORT_NAME XXPLY -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

-----------------------------------------------------

-- FOR VALUESET (VS) LDT SCRIPT - DOWNLOAD

-----------------------------------------------------

$FND_TOP/bin/FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXPOL_WO_NUM_SERVICE_VS_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME='XXPOL_WO_NUM_SERVICE_VS'

--=================================================================================--

--======================== SAMPLE HOW TO SAVE FILE ================================--

--=================================================================================--

--

-- PWCSS_SHIP_EXPORT_HDR_ID_S  (Sequence) 

--

CREATE SEQUENCE PWCSS.PWCSS_SHIP_EXPORT_HDR_ID_S

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 0

  NOCYCLE

  NOCACHE

  NOORDER

/

--

-- PWCSS_SHIP_EXPORT_HDR_ID_S  (Synonym) 

--

CREATE OR REPLACE SYNONYM APPS.PWCSS_SHIP_EXPORT_HDR_ID_S FOR PWCSS.PWCSS_SHIP_EXPORT_HDR_ID_S

/

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CONCURRENT PROGRAM ===================--

--=================================================================================--

SELECT A.CONCURRENT_PROGRAM_NAME,B.USER_CONCURRENT_PROGRAM_NAME 

  FROM fnd_concurrent_programs A, 

       fnd_concurrent_programs_tl B

 WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID

   AND(CONCURRENT_PROGRAM_NAME LIKE 'XXRMC%' OR CONCURRENT_PROGRAM_NAME LIKE 'XXCUS%' 

    OR CONCURRENT_PROGRAM_NAME LIKE 'XXTEX%' OR CONCURRENT_PROGRAM_NAME LIKE 'RMC%');

------------------

SELECT 

    fcpt.user_concurrent_program_name,

    fcpt.description,

    fcp.concurrent_program_name,

    fe.executable_name,

    (

        SELECT

            meaning

        FROM

            fnd_lookup_values

        WHERE

                1 = 1

            AND lookup_type = 'CP_EXECUTION_METHOD_CODE'

            AND lookup_code = fe.execution_method_code

    )            execution_method,

    fe.execution_file_name,

    xddt.data_source_code,

    xddt.data_source_name,

    (

        SELECT

            file_name

        FROM

            xdo_lobs

        WHERE

                lob_code = xddt.data_source_code

            AND lob_type = 'DATA_TEMPLATE'

            AND xdo_file_type = 'XML-DATA-TEMPLATE'

            AND ROWNUM = 1

    )            data_template,

    xtb.template_code,

    xtt.template_name,

    xtb.template_type_code,

    xtb.default_output_type,

    xl.file_name rtf_template

FROM

    fnd_executables            fe,

    fnd_concurrent_programs    fcp,

    fnd_concurrent_programs_tl fcpt,

    xdo_ds_definitions_tl      xddt,

    xdo_templates_b            xtb,

    xdo_templates_tl           xtt,

    xdo_lobs                   xl

WHERE

        1 = 1

    AND xl.lob_code (+) = xtb.template_code

    AND xl.lob_type (+) IN ( 'TEMPLATE_SOURCE', 'TEMPLATE' )

    AND xl.xdo_file_type (+) IN ( 'RTF', 'XLS' )

    AND xtt.template_code (+) = xtb.template_code

    AND xtb.data_source_code (+) = xddt.data_source_code

    AND xddt.data_source_code (+) = fcp.concurrent_program_name

    AND fe.executable_id = fcp.executable_id

    AND fcp.concurrent_program_id = fcpt.concurrent_program_id

    AND(fe.executable_name LIKE 'XXRMC%' OR fe.executable_name LIKE 'XXCUS%' 

     OR fe.executable_name LIKE 'XXTEX%' OR fe.executable_name LIKE 'RMC%');

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF MENU =================================--

--=================================================================================--

SELECT *

  FROM FND_MENUS

 WHERE (MENU_NAME LIKE 'XXRMC%' OR MENU_NAME LIKE 'XXCUS%' 

    OR  MENU_NAME LIKE 'XXTEX%' OR MENU_NAME LIKE 'RMC%' OR MENU_NAME LIKE 'XX%')

ORDER BY MENU_NAME;

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF RESPONSIBILITY =======================--

--=================================================================================--

SELECT *

  FROM FND_RESPONSIBILITY_VL

 WHERE(RESPONSIBILITY_KEY LIKE 'XXRMC%' OR RESPONSIBILITY_KEY LIKE 'XXCUS%' 

    OR RESPONSIBILITY_KEY LIKE 'TEX%' OR RESPONSIBILITY_KEY LIKE 'RMC%' 

OR RESPONSIBILITY_KEY LIKE 'XX%');

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF FND_LOOKUP_TYPES======================--

--=================================================================================--

SELECT *

  FROM FND_LOOKUP_TYPES

 WHERE(LOOKUP_TYPE LIKE 'XXRMC%' OR LOOKUP_TYPE LIKE 'XXCUS%' 

    OR LOOKUP_TYPE LIKE 'XXTEX%' OR LOOKUP_TYPE LIKE 'TEX%' 

OR LOOKUP_TYPE LIKE 'RMC%' OR LOOKUP_TYPE LIKE 'XX%');

-----------------

SELECT * 

  FROM FND_FLEX_VALUE_SETS

 WHERE (FLEX_VALUE_SET_NAME LIKE 'XXRMC%' OR FLEX_VALUE_SET_NAME LIKE 'XXCUS%' 

    OR  FLEX_VALUE_SET_NAME LIKE 'XXTEX%' OR FLEX_VALUE_SET_NAME LIKE 'RMC%' 

OR FLEX_VALUE_SET_NAME LIKE 'XX%')

-----------------

SELECT A2.LOOKUP_TYPE,

       A2.MEANING "LOOKUP TYPE MEANING",

       A2.DESCRIPTION "LOOKUP TYPE DESCRIPTION",

       A1.LOOKUP_CODE,

       A1.MEANING "LOOKUP VALUE MEANING",

       A1.DESCRIPTION "LOOKUP VALUE DESCRIPTION"

  FROM APPS.FND_LOOKUP_VALUES A1,APPS.FND_LOOKUP_TYPES_VL A2

 WHERE (A1.LOOKUP_TYPE LIKE 'XXRMC%' OR A1.LOOKUP_TYPE LIKE 'XXCUS%' 

    OR  A1.LOOKUP_TYPE LIKE 'XXTEX%' OR A1.LOOKUP_TYPE LIKE 'TEX%' 

OR  A1.LOOKUP_TYPE LIKE 'RMC%' OR A1.LOOKUP_TYPE LIKE 'XX%')

   AND A1.LOOKUP_TYPE=A2.LOOKUP_TYPE

   AND A1.LOOKUP_TYPE <> 'RMC BANK WITH NMAM CODE'

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF Data Source Name =====================--

--=================================================================================--

  SELECT xddt.data_source_name "Data Source Name",

         xddb.data_source_code "Code",

         fat.application_name "Application Name"

    FROM xdo_ds_definitions_b xddb,

         xdo_ds_definitions_tl xddt,

         fnd_application fa,

         fnd_application_tl fat

   WHERE ( XDDB.DATA_SOURCE_CODE LIKE 'XX%' OR XDDB.DATA_SOURCE_CODE LIKE 'XXRMC%' OR

           XDDB.DATA_SOURCE_CODE LIKE 'XXCUS%' OR  XDDB.DATA_SOURCE_CODE LIKE 'XXTEX%' 

   OR XDDB.DATA_SOURCE_CODE LIKE 'RMC%')

AND xddt.data_source_code = xddb.data_source_code

AND xddt.LANGUAGE = 'US'

AND fa.application_short_name = xddb.application_short_name

AND fat.application_id = fa.application_id

AND fat.LANGUAGE = 'US';

         

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF Data Source Name RTF =================--

--=================================================================================--        

               

SELECT * 

  FROM XDO_TEMPLATES_TL 

 WHERE (TEMPLATE_CODE LIKE 'XX%' OR TEMPLATE_CODE LIKE 'XXRMC%' 

    OR  TEMPLATE_CODE LIKE 'XXCUS%' OR  TEMPLATE_CODE LIKE 'XXTEX%' 

OR TEMPLATE_CODE LIKE 'RMC%');

        

SELECT * FROM  XDO_TEMPLATES_B ;

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM FORM FUNCTION =================--

--=================================================================================-- 

SELECT *

  FROM FND_FORM_FUNCTIONS_VL

 WHERE (FUNCTION_NAME LIKE 'XXRMC%' OR FUNCTION_NAME LIKE 'XXCUS%' 

    OR  FUNCTION_NAME LIKE 'XXTEX%' OR FUNCTION_NAME LIKE 'RMC%' 

OR  FUNCTION_NAME LIKE 'XX%')

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM Workflow (WF) =================--

--=================================================================================-- 

SELECT WF.MESSAGE_TYPE WF_CODE,  WF.DISPLAY_NAME WF_NAME , WF.DESCRIPTION  WF_DESCRIPTION, WF.MESSAGE_NAME

  FROM WF_NOTIFICATIONS WF, 

       WF_NOTIFICATION_ATTRIBUTES WFA, 

   WF_ITEM_TYPES_TL WF

 WHERE WF.NOTIFICATION_ID =WFA.NOTIFICATION_ID 

   AND (WFA.TEXT_VALUE LIKE '%XX%' OR WF.NAME LIKE 'XX%' OR WFA.NAME LIKE '%XX%'  ) 

   AND  WF.MESSAGE_TYPE NOT IN  ('WFERROR','UMXLHELP', 'POERROR')

   AND  WF.MESSAGE_TYPE = WF.NAME

GROUP BY  WF.DISPLAY_NAME, WF.DESCRIPTION , WF.MESSAGE_TYPE , WF.MESSAGE_NAME

ORDER BY 1

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM FORM PERSONALIZATION===========--

--=================================================================================-- 

SELECT A.SEQUENCE, 

       A.FUNCTION_NAME, 

   A.FORM_NAME, 

   A.ENABLED,

       C.USER_FORM_NAME, 

   D.APPLICATION_NAME, 

   A.DESCRIPTION,

   DECODE (A.RULE_TYPE,

           'F', 'Form',

               'A', 'Function',

               'Other'

               ) "Level",

       a.trigger_event, 

   a.trigger_object,

       a.condition, 

       DECODE (a.fire_in_enter_query,

               'Y', 'Both',

               'N', 'Not in Enter-Query Mode',

               'O', 'Only in Enter-Query Mode',

               'Other'

              ) "Processing Mode",

       ca.SEQUENCE, 

       DECODE (ca.ACTION_TYPE,

           'S', 'Menu', 

   'P', 'Property',

   'B', 'Builtin',

   'M', 'Message', 

   ca.ACTION_TYPE ) Type,

       ca.ARGUMENT_TYPE, 

       ca.ENABLED, ca.OBJECT_TYPE, ca.FOLDER_PROMPT_BLOCK, ca.MESSAGE_TYPE, ca.MESSAGE_TEXT,

       ca.SUMMARY, ca.BUILTIN_TYPE, ca.BUILTIN_ARGUMENTS ,

       ca.RULE_ID, ca.PROPERTY_NAME,ca.PROPERTY_VALUE,ca.TARGET_OBJECT, 

   ca.MENU_ENTRY, ca.MENU_LABEL, ca.MENU_SEPERATOR, ca.MENU_ENABLED_IN,

   ca.MENU_ACTION, ca.MENU_ARGUMENT_LONG

  FROM fnd_form_custom_rules a,

       fnd_form b,

       fnd_form_tl c,

       fnd_application_tl d,

       fnd_form_custom_actions ca

 WHERE a.form_name = b.form_name

   AND b.form_id = c.form_id

   AND b.application_id = d.application_id

--AND a.description like 'SINP - Terms and Conditions menu'

   AND a.enabled = 'Y'

   AND a.ID = ca.rule_id

ORDER BY a.function_name, a.SEQUENCE, ca.SEQUENCE

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM OAF_FMB FORM ==================--

--=================================================================================-- 

SELECT F.FORM_NAME,

       B.FUNCTION_NAME,

       B.APPLICATION_ID,

       DECODE (B.TYPE, 'FORM', 'FMB FORM', 'JSP', 'OAF PAGE',B.TYPE ) FORM_TYPE ,

       T.USER_FUNCTION_NAME,

       T.DESCRIPTION,

       B.WEB_HTML_CALL

  FROM FND_FORM_FUNCTIONS_TL T,

       FND_FORM_FUNCTIONS    B,

       FND_FORM F

 WHERE B.FUNCTION_ID = T.FUNCTION_ID

   AND B.FORM_ID = F.FORM_ID (+)

   AND (B.FUNCTION_NAME LIKE 'XX%' OR  B.FUNCTION_NAME LIKE '%XXCUS%') 

ORDER BY 3;

        

     

--=================================================================================--

--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM OAF PAGE QUERY ================--

--=================================================================================-- 

SELECT JDR_MDS_INTERNAL.GETDOCUMENTNAME(JP.PATH_DOCID) DOCUMENT_PATH,

       JA.ATT_VALUE  PERSONALIZATION_PATH,

       JP.PATH_NAME                                    DOCUMENT_NAME,

       ATT_NAME                                        CUSTOMIZE_CLASS_TYPE,

       COMP_ID                                         COLUMNCONTROLLER_NAME,

       JC.COMP_ELEMENT                                 COLUMN_TYPE

  FROM JDR_PATHS      JP,

       JDR_ATTRIBUTES JA,

       JDR_COMPONENTS JC

 WHERE JP.PATH_DOCID = JA.ATT_COMP_DOCID

   AND JP.PATH_DOCID = JC.COMP_DOCID

   AND ATT_NAME IN ( 'customizes', 'controllerClass' )

   AND ( JC.COMP_ID LIKE 'XX%' OR JC.COMP_ID LIKE '%XXCUS%' )