How to find how many and what DFF(Descriptive Flex Field) are enabled in the Oracle APPS R12.1 instance

Execute following script :

SELECT TITLE FROM  FND_DESCRIPTIVE_FLEXS_VL
WHERE FREEZE_FLEX_DEFINITION_FLAG='Y' AND LAST_UPDATED_BY NOT IN (-1,1,2,0,120,121);

How to find all Form Personalization through script in Oracle APPS / How to get Form Personalization thorugh script

SELECT FORM_ID, FORM_NAME, USER_FORM_NAME, DESCRIPTION
FROM
FND_FORM_VL
WHERE FORM_NAME IN
(SELECT FORM_NAME FROM FND_FORM_CUSTOM_RULES GROUP BY FORM_NAME)

Oracle APPS R12.1.3 Rapid Clone Application and Database

Pre clone Activity

Database Tier

$ su – <dbuser>

$ cd <db script home> (ex:/u01/orcln/crp/db/tech_st/11.1.0/appsutil/scripts/)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclonr.pl dbTier

Prompt Pwd: apps

$ exit

Application Tier

$ su– <application user>testcrp

$ cd <application script home> (ex: /u01/orcln/crp/apps/inst/apps/TEST10_vis/admin/scripts)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclone.pl appsTier

$ exit

Stop Instance

and ensure all process are stop

Login as root

copy all folder(apps,db,inst) to destination

$ cp –R <source>(/u01/orcln/crp/*) <destination>( /b01/UAT/)

After completion of copy change permission and ownership:-

$ chown – R orauat:dba db
$ chown – R appluat:dba apps
$ chown – R appluat:dba inst

$ chmod –R 777 db

$chmod –R 777 apps

$chmod –R 777 inst

Post Clone Activity database

$ su – <new db user> orauat
$ cd <clone/bin> (ex:/b01/UAT/db/tech_st/11.1.0/appsutil/clone/bin)
$ perl adcfgclone.pl dbTier
Prompt Pwd: apps

Target system host name : <host name> (test)

RAC(Y/N): N
Target system Database SID: <SID> (UAT)
Target system: /b01/UAT/db/tech_st/11.1.0
Target system utl_file_dir Directody list : /usr/tmp
DATA_TOP: 1
DATA_TOP_Directory: /b01/UAT/db/apps_st/data
ORACLE_HOME Directory: /b01/UAT/db/tech_st/11.1.0
Do you want to preserve display : y
Target system port pool : 6
$ exit

Checking for database connection (database up or not)

Post Clone Activity Application

$ su – <new application user>(appluat)
$ cd /b01/UAT/apps/apps_st/comn/clone/bin
$ perl adcfgclone.pl appsTier
Prompt Pwd: apps
Host name : test
SID : <sid> (UAT)
Database server node : vis
System database domain name : kross.com
System base directory : - /b01/UAT/apps/apps_st/appl
System tool oracle_home: - /b01/UAT/apps/tech_st/10.1.2
System web oracle_home :- /b01/UAT/apps/tech_st/10.1.3
System appl_top:- /b01/UAT/apps/apps_st/appl
System common_top:- /b01/UAT/apps/apps_st/comn
System instance home:- /b01/UAT/apps/inst
<accept other default value by pressing enter>

Preserve display: y

Port pool : 6
Appltmp : - 1( /usr/tmp)
Do you want to startup application services: y

Stop and start new instance

Run Autoconfig on Database

Run Autoconfig on Application

Stop and start New instance

Oracle APPS ISO Internal Location details and deletion from backend.

SELECT * FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

 If it returns any row, it means that, indeed, an Internal location is Already assigned to another Ship-to Address 

For deletion of internal location association

Please run following datafix:

Take a backup of table :- FROM PO_LOCATION_ASSOCIATIONS_ALL

 DELETE FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

Oracle APPS PO Output for Communication Completed with Error

ERROR:
m_Languages :en
m_Territories :US
genDoc() : Exceptionjava.lang.Exception: Error while generating PDF :null
java.lang.Exception: Error while generating PDF :null
rolling back the complete program

Solution :- . Query profile "XDO: Numeric Characters"
Set at site level one of the possible values for this profile: - 10.000,00