About Me

Dubai, United Arab Emirates
My name is Muhammad Faizan Karim and my aim is to spread the knowledge to everyone who want to learn oracle HRMS. I will try to write the video blogs for beginners so they can understand e-business suits from HRMS perspective, and if you have any difficulty in oracle applications HRMS , please feel free to contact with me at this email : faizan.kareem.ocp@gmail.com
Powered by Blogger.
Thursday, November 20, 2014

Oracle HRMS Extract Fast Formula Text from ff_formulas_f table

3:25 AM | Posted by | Edit Post
Extract Fast Formula Text from ff_formulas_f table

Not sure if anyone came across this but I was struggling to extract all Payroll Fast Formulas and keep repository for config management. There is very simple way of extracting all formulas using TOAD (11.6.0.43).

    1)    Select formula_name ,formula_text from ff_formulas_f where formula_name like '%PRORA%'
    2)   This will retrun rows with formula name and formula text.
    3)   Right Click on Formula_Text field and select option Export Blobs.
    4)   Select Formula_Text in Export this column.
    5)   Select export path.
    6)   Select second option Export to Files name for the value in this column.
    7)   In this select Formula Name. You can choose file extension.
Hope this helps.

0 comments:

Post a Comment
Subscribe to: Post Comments (Atom)

Designed by Muhammad Faizan.