Tuesday, April 14, 2009

How to Get the Forms,PLL,LDT,Reports,Database Object Versions from the backend

How to get the version of below objects from backend

a) Forms
b) Reports
c) Library files
d) LDT
e) SQL files
f) Packages



a) Form

When considering forms one needs to get the version from $JA_TOP and $AU_TOP as well.

Navigate to cd $JA_TOP/forms/US
Execute command --- > strings -a | grep '$Header'

Example
strings -a JAINPORE.fmx | grep '$Header'

Navigate to cd $AU_TOP/forms/US
Execute command --- > strings -a | grep '$Header'

Example
strings -a JAINPORE.fmb | grep '$Header'


b) Reports

Navigate to cd $JA_TOP/reports/US
Execute command --- > strings -a | grep '$Header'

Example
strings -a JAINARDR.rdf | grep '$Header'

c) Library files

Navigate to cd $AU_TOP/resource
Execute command --- > strings -a | grep '$Header'

Example
strings -a CUSTOM.pll | grep '$Header'

d) LDT

Navigate to cd $JA_TOP/patch/115/import/US
Execute command --- > strings -a | grep '$Header'

Example
strings -a jai115cp_F.ldt | grep '$Header'

e) SQL files

Navigate to cd $JA_TOP/patch/115/sql
Execute command --- > strings -a | grep '$Header'

Example
strings -a ja_in_mass_tax_changes_p.sql | grep '$Header'

f) Packages

Navigate to cd $JA_TOP/patch/115/sql
Execute command --- > strings -a | grep '$Header' (Package Specification)
Execute command --- > strings -a | grep '$Header' (Package Body)

Example
strings -a jai_encum_prc.pls | grep '$Header'
strings -a jai_encum_prc.plb | grep '$Header'

No comments: