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

爱被打了一巴掌 2022-01-31 09:31 104阅读 0赞

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!