How to find the source code of a seeded HRMS formula function


To  look at the source code a formula function i.e. if you want to determine
the logic used to return the value concerned you can do the following

1. Establish the defintion name held in the table FF_FUNCTIONS

For example if you are interested in the function called
CALCULATE_CONTINUOUS_SERVICE

SELECT DEFINITION FROM FF_FUNCTIONS WHERE NAME = ‘CALCULATE_CONTINUOUS_SERVICE’

This will return the package.procedure

In this case it returns
pqp_service_history_calc_pkg.calcualate_continuous_service

2.Establish the file name held on the service for this package

SELECT TEXT FROM USER_SOURCE WHERE NAME = ‘PQP_SERVICE_HISTORY_CALC_PKG’
AND TEXT LIKE ‘%$Header%’

This will return the file name

In this case this is

pqshpcal.pkb

3.Access the package body code from the server and identify the procedure
concerned

In this case you can search code until locate function

calcualate_continuous_service

 

One thought on “How to find the source code of a seeded HRMS formula function

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s