2015113022PM-How to make a local database upto the latest FA datamodels and packages

NOTICE: You should know what you are doing before you run the following commands. Otherwise, all previously applied backend FA data models and packages would be wiped out with the unwanted latest datamodel/code from ADE.
1) You will need to make sure you are in ADE view before you run the scripts.
2) Create the following two scripts in your local directory.

Here are the scripts to create a full manifest file for the latest FA datamodels and packages from ADE:

====================
prefix=`echo "$SRCHOME"/`
find $SRCHOME/fusionapps/ic/components/ -name "*.sequence" > $HOME/latest_datamodels_temp.txt
find $SRCHOME/fusionapps/ic/components/ -name "*.table" >> $HOME/latest_datamodels_temp.txt
find $SRCHOME/fusionapps/ic/components/ -name "*.view" >> $HOME/latest_datamodels_temp.txt
find $SRCHOME/fusionapps/ic/ -name "*SD.xml" > $HOME/latest_sd_temp.txt
find $SRCHOME/fusionapps/ic/ -iname "*.pkh" > $HOME/latest_packages_temp.txt
find $SRCHOME/fusionapps/ic/ -iname "*.pkb" >> $HOME/latest_packages_temp.txt

sed 's:'$prefix'::' < $HOME/latest_datamodels_temp.txt > $HOME/latest_datamodels.manifest
rm $HOME/latest_datamodels_temp.txt

sed 's:'$prefix'::' < $HOME/latest_sd_temp.txt > $HOME/latest_sd.manifest
rm $HOME/latest_sd_temp.txt

sed 's:'$prefix'::' < $HOME/latest_packages_temp.txt > $HOME/latest_packages.manifest
rm $HOME/latest_packages_temp.txt

=====================

3) Apply FPR using the newly created manifest files:

latest_packages.manifest and latest_datamodels.manifest

Example:

fpr -envsid ahl_dit -requestmode applyfiles -source FUSIONAPPS_11.1.11.0.0IC_LINUX.X64_151113.1400 -m $HOME/latest_datamodels.manifest
fpr -envsid ahl_dit -requestmode applyfiles -source FUSIONAPPS_11.1.11.0.0IC_LINUX.X64_151113.1400 -m $HOME/latest_sd.manifest
fpr -envsid ahl_dit -requestmode applyfiles -source FUSIONAPPS_11.1.11.0.0IC_LINUX.X64_151113.1400 -m $HOME/latest_packages.manifest

Check your FPR requests in http://fre.us.oracle.com:7777/cgi-bin/fprScheduler?scope=env&req=home

and ensure that they are completed successfully.


4) Also - Make sure to run the following script to verify that all plsql packages are VALID.

select object_name, status
,object_type
,to_char(last_ddl_time,'DD-MON-YYYY HH24:MI:SS') last_ddl_time
from dba_objects
where owner='FUSION'
and (object_name like 'FA%'
or object_name like 'UT_FA%')
and status = 'INVALID'
/

If there's no returned row, that means 'No Invalid objects found' and you are good to GO!