How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs:

ERROR:

You must enter an Application Number.

Solution:

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS

Changing Employee number generation from Manual to automatic without affecting current employee numbers unchanged. 

Attach concurrent program : "Change Person Numbering to Automatic" to your responsibility.

And run the program with parameter as Employee.

This will automatically change Business Group Info value of Employee Generation from Manual to automatic, So new employee will be given there employee number automatically.

Technically this program creates an entry at per_number_generation_controls with BG and next value.

Oracle Apps R12 FND_GLOBAL and FND_PROFILE and Import List of System Global values

 

Oracle Apps R12 FND_GLOBAL and FND_PROFILE and Import List of System Global values

We can find values of System global values using FND_PROFILE and FND_GLOBAL

FND_PROFILE

To manipulate values stored in client and server user profile caches.

Any changes you make to profile option values using these routines affect only the run-time environment. 

The effect of these settings end when the program ends, 

because the database session (which holds the profile cache) is terminated.

fnd_profile.value('PROFILEOPTION')

fnd_profile.value('MFG_ORGANIZATION_ID')

fnd_profile.value('ORG_ID')

fnd_profile.value('LOGIN_ID')

fnd_profile.value('USER_ID')

fnd_profile.value('USERNAME')

fnd_profile.value('CONCURRENT_REQUEST_ID')

fnd_profile.value('GL_SET_OF_BKS_ID')

fnd_profile.value('SO_ORGANIZATION_ID')

fnd_profile.value('APPL_SHRT_NAME')

fnd_profile.value('RESP_NAME')

fnd_profile.value('RESP_ID')

fnd_profile.value('PER_BUSINESS_GROUP_ID')

fnd_profile.value('GL_SET_OF_BKS_ID')

fnd_profile.value('CURRENT_ORG_CONTEXT')

FND_GLOBAL

The server-side package FND_GLOBAL returns the values of system globals, 

such as the login/signon or “session” type of values. 

You should not use FND_GLOBAL routines in your forms (that is on the client side). 

On the client side, most of the procedures in the FND_GLOBAL package are replaced 

by a user profile option with the same (or a similar) name. 

You should use FND_PROFILE routines in your forms instead.

fnd_global.USER_ID 

fnd_global.USER_NAME 

fnd_global.RESP_ID 

fnd_global.RESP_NAME 

fnd_global.APPLICATION_NAME 

fnd_global.APPLICATION_SHORT_NAME 

fnd_global.RESP_APPL_ID 

fnd_global.BASE_LANGUAGE 

fnd_global.CONC_LOGIN_ID 

fnd_global.CONC_PRIORITY_REQUEST 

fnd_global.CONC_PROCESS_ID 

fnd_global.CONC_PROGRAM_ID 

fnd_global.CONC_QUEUE_ID 

fnd_global.CONC_REQUEST_ID 

fnd_global.CURRENT_LANGUAGE 

fnd_global.CUSTOMER_ID 

fnd_global.EMPLOYEE_ID 

fnd_global.FORM_APPL_ID 

fnd_global.FORM_ID 

fnd_global.GET_SESSION_CONTEXT 

fnd_global.LANGUAGE_COUNT 

fnd_global.LOGIN_ID 

fnd_global.NEWLINE 

fnd_global.NLS_DATE_FORMAT 

fnd_global.NLS_DATE_LANGUAGE 

fnd_global.NLS_LANGUAGE 

fnd_global.NLS_NUMERIC_CHARACTERS 

fnd_global.NLS_SORT 

fnd_global.NLS_TERRITORY 

fnd_global.ORG_ID 

fnd_global.ORG_NAME 

fnd_global.PARTY_ID 

fnd_global.PER_BUSINESS_GROUP_ID 

fnd_global.PER_SECURITY_PROFILE_ID 

fnd_global.PROG_APPL_ID 

fnd_global.QUEUE_APPL_ID 

fnd_global.RT_TEST_ID 

fnd_global.SECURITY_GROUP_ID 

fnd_global.SERVER_ID 

fnd_global.SESSION_ID 

fnd_global.SUPPLIER_ID 

fnd_global.TAB

Where do we use FND_GLOBAL and FND_PROFILE?

We can use them any where in PL/SQL to get values dynamically as per the session. 

In Forms we can use only FND_GLOBAL not FND_PROFILE.

Initializing the Environment

   l_user_id       := fnd_global.user_id;

   l_resp_id       := fnd_global.resp_id;  

   l_resp_appl_id  := fnd_global.resp_appl_id;   

 

   fnd_global.APPS_INITIALIZE(l_user_id,l_resp_id, l_resp_appl_id);

   

Validate Invalid Objects in Oracle Database

 Validate Invalid Objects in Oracle Database

A) Find Invalid Objects:

1.To Find the number of invalid objects

select count(*) from dba_objects where status='INVALID';

select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;

2.To identify the object name and their types and owner:

select owner, object_name,object_type from dba_objects where status ='INVALID';

B) Try Manual method of validation:

Alter procedure <owner>.<procedure_name> compile;

Alter function <owner>.<function_name> compile;

Alter view <owner>.<view_name> compile;

Alter package <owner>.<package_name> compile;

Alter package <owner>.<package_name> compile body;

Alter materialized view <owner>.<Package_name> Compile;

In case you have lots of invalid objects, you can generate scripts that will generate the sqls for compiling the invalid objects :

In sqlplus connect as sys:

set heading off

spool compileinvalid.sql

select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects where status='INVALID';

spool off

Then run compileinvalid.sql in sqlplus prompt as sys user.

To compile invalid package body use:

alter package <package_name> compile body;

Another SQL Script: To Recompile Invalid Objects

set heading off

 set pagesize 0

 set linesize 79

 set verify off

 set echo off

 spool comp_all.sql

 select

     decode( OBJECT_TYPE, 'PACKAGE BODY',

     'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',

     'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )

 from

     dba_objects a,

     sys.order_object_by_dependency b

 where

     A.OBJECT_ID = B.OBJECT_ID(+) and

     STATUS = 'INVALID' and

     OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE',

                       'TRIGGER', 'VIEW' )

 order by

     DLEVEL DESC,

     OBJECT_TYPE,

     OBJECT_NAME;

 spool off

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%' )