{"id":1001,"date":"2011-04-14T12:26:30","date_gmt":"2011-04-14T12:26:30","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/fast-formula"},"modified":"2011-04-14T12:26:30","modified_gmt":"2011-04-14T12:26:30","slug":"fast-formula","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/fast-formula","title":{"rendered":"HRMS Fast Formula"},"content":{"rendered":"

What is Oracle Fast Formula?<\/span><\/p>\n

Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language.<\/p>\n

You can use Oracle Fast Formula to:<\/span><\/p>\n

1.Calculate your payrolls<\/p>\n

2.Define the rules for PTO accrual plans<\/p>\n

3.Define custom calculations for benefits administration<\/p>\n

4.Define Quick Paint reports<\/p>\n

5..Validate element inputs or user tables<\/p>\n

6.Edit assignment sets<\/p>\n

7.Calculate absence duration<\/p>\n

8.Configure people management templates<\/p>\n

9.Set up business rules and call them from other PL\/SQL applications<\/p>\n

10.Define your Oracle Business Intelligence Systems reports.<\/p>\n

11.Collective agreements<\/p>\n

12.Define employment categories for EEO reports (US only)<\/p>\n

 <\/p>\n

1.Calculate your payrolls:<\/span><\/p>\n

a)You can use predefined payroll formulas. When you receive Oracle Payroll, some formulas are predefined in your system. You cannot make any changes to these formulas, but you can copy them and modify the copies.<\/p>\n

b)All Oracle Payroll users can use Fast Formula to write payroll calculations and skip rules for elements you define yourself to represent earnings and deductions.<\/p>\n

 <\/p>\n

2.PTO Accrual Plans:<\/span><\/p>\n

You can use Oracle Fast Formula to edit the seeded Accrual type formulas, or to write your own. Each accrual plan needs two formulas: one to calculate gross accrual, and the other to return information to the PTO Carry Over process. You can optionally create a third formula if you want to use the Batch Element Entry (BEE) to make absence entries against accrual plans. This formula is called by BEE to check whether an employee is eligible to use accrued PTO.<\/p>\n

 <\/p>\n

3.Define custom calculations for benefits administration:<\/span><\/p>\n

You can use Oracle Fast Formula to augment the system’s benefits administration features. Use formulas to configure your plan design to the requirements of your enterprise. For example, you can write a formula to calculate benefits eligibility for those cases where eligibility determination is most complex.<\/p>\n

 <\/p>\n

4.Define Quick Paint reports:<\/span><\/p>\n

a)A Quick Paint formula can return a text string to display in the Assignment field on the Maintenance window and in the Data Organizer.
\nb)A Quick Paint formula can return message tokens that you can use in a notification message issued from template forms.<\/p>\n

 <\/p>\n

5.Validate element inputs or user tables:<\/span><\/p>\n

a)You can use Oracle Fast Formula to validate user entries into element input values using lookups or maximum and minimum values. However, if you need more complex validation, you can write a formula to check the entry.
\nb)You can also use a formula to validate entries into user tables that you define.<\/p>\n

 <\/p>\n

6.Edit assignment sets:<\/span><\/p>\n

When you define assignment sets in the Assignment Set window, Oracle FastFormula generates a formula to define an assignment set from the criteria entered. However, you may want to change the sequence in which the set criteria are checked for each assignment.<\/p>\n

 <\/p>\n

7. Absence Duration:<\/span><\/p>\n

You can write a formula to calculate the duration of an absence from the start and end dates and times. Your localization team may have created a default formula, but you can override this with your own version.<\/p>\n

 <\/p>\n

8.Configuring People Management Templates:<\/span><\/p>\n

There are several ways you can use formulas to configure the people management templates:
\na) A Template Validation formula can check values entered in a field.
\nb) A Template Information formula can specify information to be displayed from the right mouse menu when a user right-clicks in a field.<\/p>\n

 <\/p>\n

9.Set up business rules and call them from other PL\/SQL applications:<\/span><\/p>\n

You can call formulas from PL\/SQL applications. This enables direct access to data items and makes it possible to develop custom code for localized business rules. More detailed information about calling Fast Formula from PL\/SQL can be found in the technical essay Calling Fast Formula from PL\/SQL.<\/p>\n

 <\/p>\n

10.Define your Oracle Business Intelligence Systems reports:<\/span><\/p>\n

Using formulas you can configure your HRMS BIS reports so that they answer the business questions which are important to your enterprise.<\/p>\n

You can:
\na)Define how workforce should be counted within your enterprise for the Workforce reports.
\nb)Set up information about how you want to record and report on regular and overtime hours for the Hours Worked Analysis report.
\nc)Set up the standard hours for your enterprise for the Absence Analysis report.<\/p>\n

 <\/p>\n

11.Collective agreements:<\/span><\/p>\n

Using formulas you can calculate whether a person is eligible to receive a collective agreement entitlement. This can be used when defining an eligibility profile to be used in conjunction with a collective agreement, instead of selecting criteria elements. You select the formula as a rule when defining the eligibility profile.<\/p>\n

 <\/p>\n

12.Define employment categories for EEO reports (US only):<\/span><\/p>\n

For the EEO4 and EEO5 reports you can use Oracle Fast Formula to create a formula of employment categories. You can define a formula for each business group and the EEO reports will pick the list of employment categories from the formula.<\/p>\n

Note: When you write a formula, you specify for which of these purposes you will use it.<\/p>\n

 <\/p>\n

Steps to define Fast formula:<\/p>\n

Step1: Define Consolidation Set<\/p>\n

Navigation: Payroll > Consolidation<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step2: Define Payment Method<\/p>\n

Navigation: Payroll > payment Methods<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step3: Define Payroll<\/p>\n

Navigation: Payroll > Description<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step4: Creating Elements<\/p>\n

Navigation: Total Compensation > Basic > Element Description<\/p>\n

i)Basic Element:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Click on input values.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

ii) DA Element: (fast formula is assigned to this element)<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Click on input values.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step5 : Link the Elements with the Payroll<\/p>\n

Navigation: Total Compensation > Basic > Link<\/p>\n

i)Basic Element:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

ii) DA Element:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step6: Define Salary Basis<\/p>\n

Navigation: Total Compensation > Basic > Salary Basis<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step7: Define Fast Formula<\/p>\n

Navigation: Total Compensation \uf0e0 Basic \uf0e0 Write Formulas<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Click on the “Show Items” Button and Query for the Database Items related to the element ” Ex1_Basic” and search for the item which is suffixed with “ENTRY_VALUE”.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Click on “Edit ” Button and write the formula Logic and click on “Verify” button to verify the syntax.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step8: Define Formula Result Rules<\/p>\n

Navigation: Total Compensation > Basic > \u00a0Formula Results<\/p>\n

Select the element to which the formula has to be assigned.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step9: Attach all the defined Elements for the employee to whom the payroll has to be run.<\/p>\n

Navigation: People > Enter and Maintain<\/p>\n

Create Employee (or) Query Employee<\/p>\n

\"\"<\/p>\n

Click on Assignments<\/p>\n

\"\"<\/p>\n

Click on Entries<\/p>\n

\"\"<\/p>\n

Click on Entry Values<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Step10: Run the payroll.<\/p>\n

i)Nav: Processes and Reports > Submit Processes and Reports<\/p>\n

Run the Concurrent Program “Payroll Run”.<\/p>\n

ii) Nav: Processes and Reports > View Requests > Find<\/p>\n

iii)Nav: View > Payroll Process Results<\/p>\n

Select the Payroll and click on “Find” Button.<\/p>\n

Select the Payroll(for specific Period) run and Click on “Assignment Process Button”<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

Select the Employee for whom you have run the payroll and click on “SOE Report” to view the Pay Advice Report.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

What is Oracle Fast Formula? Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language. You can use Oracle Fast Formula to: 1.Calculate your payrolls 2.Define the rules for PTO […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,49],"tags":[],"class_list":["post-1001","post","type-post","status-publish","format-standard","hentry","category-articles","category-hrms"],"yoast_head":"\noracle hrms fast formula tutorial<\/title>\n<meta name=\"description\" content=\"Oracle hrms Fast Formula is a simple way to write formulas using simple words and basic mathematical functions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"HRMS Fast Formula\",\"datePublished\":\"2011-04-14T12:26:30+00:00\",\"dateModified\":\"2011-04-14T12:26:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\"},\"wordCount\":1150,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png\",\"articleSection\":[\"Articles\",\"HRMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\",\"name\":\"oracle hrms fast formula tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png\",\"datePublished\":\"2011-04-14T12:26:30+00:00\",\"dateModified\":\"2011-04-14T12:26:30+00:00\",\"description\":\"Oracle hrms Fast Formula is a simple way to write formulas using simple words and basic mathematical functions.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/fast-formula\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/fast-formula#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HRMS Fast Formula\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle hrms fast formula tutorial","description":"Oracle hrms Fast Formula is a simple way to write formulas using simple words and basic mathematical functions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/articles\/fast-formula","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"HRMS Fast Formula","datePublished":"2011-04-14T12:26:30+00:00","dateModified":"2011-04-14T12:26:30+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula"},"wordCount":1150,"commentCount":14,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png","articleSection":["Articles","HRMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/fast-formula#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula","url":"https:\/\/erpschools.com\/erps\/articles\/fast-formula","name":"oracle hrms fast formula tutorial","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png","datePublished":"2011-04-14T12:26:30+00:00","dateModified":"2011-04-14T12:26:30+00:00","description":"Oracle hrms Fast Formula is a simple way to write formulas using simple words and basic mathematical functions.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/fast-formula"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1225_FastFormula114.png"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/fast-formula#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"HRMS Fast Formula"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1001"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1001\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}