SOA IT SOA IT Introduction to Fast Formula Formula Creation and Components Formula Syntax Sample Fast Formula Agenda SOA IT OracleFastFormulatoolwriteformulasusingEnglishwordsandbasicmathematicalfunct ID: 959488
Download Pdf The PPT/PDF document "Fast Formula in Oracle HCM Cloud" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
SOA IT Fast Formula in Oracle HCM Cloud SOA IT Introduction to Fast Formula Formula Creation and Components Formula Syntax Sample Fast Formula Agenda SOA IT OracleFastFormulatoolwriteformulasusingEnglishwordsandbasicmathematicalfunctionsYoucanwritegen
ericexpressionsforanycalculationcomparisonyoumaywantrepeatwithdifferentvalues What is Fast Formulas SOA IT Uses of Fast Formula FastFormulascanbeusedacrossvariousFusionHCMproductsPerformPayrollCalculationsDefinerulesforpaidtimeoff(PTO)accrualsCalcula
teabsencedurationDefinecustomcalculationsforbenefitsadministrationEditrulesforobjectgrouppopulationforelementspeopleValidateElementInputValuesUserDefinedTables ValidationandExtracts SOA IT DifferentformulatypesareusedacrossvariouspartsFusionapplicat
ionsPayrollBenefitsHumanResourcesExtractsCompensationManagementAbsenceManagementTimeandLaborUses of Fast Formula SOA IT Each formula must have a typewhich determines: How the formula can be used What contexts are
automatically available to the formula Which rules about the inputs and outputs apply Fast Formula Types SOA IT Formula Types•There are more than 120 formula typesavailable in Fusion HCM: SOA IT Formula Creation MethodsPredefinedDelivered
withOracleFusionSpecificlocalizations(forexampletaxcalculation)CannotandshouldnotmodifiedUserDefinedUserscreatetheirownfastformulas(forexampleAbsenceDuration)GeneratedUsersetupandsystemgeneratedfromlegislativetemplates(forexampleExtractgeneratesformul
asforblocksanditems,elementtemplatesgeneratefastformulaforandhiddenelements) SOA IT Formula Levels FastformulascanbedefinedgloballegislationlevelGlobalCanbeusedanylegislationTheseformulasdonothavelegislationdatagroupassignedthem(CALC_ARREARS)Legislati
onformulaapplicableonlyonelegislationhaslegislationdatagroupassigned(US_TAX_MEDICARE) SOA IT PayrollProcessingfastformulasareusedCalculateelementrunresultsProratepayrollresultsPerformlegislativechecksduringthepayrollrunSpecifyrulesforskippingelementdu
ringpayrollprocessingUsage of Fast Formula in Fusion HCM SOA IT Usage of Fast Formula in Fusion HCMBenefitsAdministrationformulausagesCreaterules,forexampleeligibilitydeterminationPostelectioneditsServicecalculationCoverageamountlimitsCompensationMana
gementformulausagesSpecifycompensationworksheetdefaultsProcessonlyspecificemployeesCreateuniquehierarchyforcompensation SOA IT Usage of Fast Formula in Fusion HCMAbsenceManagementformulasareusedDetermineAccrualtermsCalculatehowmuchtimeisaccrued,andhow
muchtimecancarriedoverthenextaccrualtermDetermineVestingcriteriaOracleTimeandLaborTransformincomingdatafromthirdpartytimekeepingsystemforpayrollbatchloaderErrorWarningvalidationtimeentriesGenerateprocessresultsfromemployeereportedentries SOA IT Usage
of Fast Formula in Fusion HCMValidationformula usages Check that element entry values are valid for the element Check element entries to a user defined tables Extract HCM data for archiving and reporting SOA IT AgendaIntroduction to Fast Formula Form
ulaCreation and Components Formula Syntax Sample Fast Formula SOA IT Creating Fast Formulas in Fusion HCMNavigationPayrollCalculationManageFastFormulasthroughManageFastFormulastaskthroughSetupandMaintenanceworkarea SOA IT CreateformulawithappropriateT
ype CaseStudyFusionPayrollHowCreateand ModifyFastFormula( Creating Fast Formulas in Fusion HCM SOA IT Formula Structure Each formula may have five sections: SOA IT Components in a sample Formula SOA IT Formula Inputs and Outputs Formulas can take in
put from the window, database, or a process such as a payroll run and can return values or messages. SOA IT Three Types of Inputs InputStatementsValuesarepassedruntimeContentsinputsstatementdependsformulatypeDatabaseItemsValuesfromdatabaseBrowselistd
atabaseitemsfromFormulawindowAddDatabaseItemspageFastFormulaAssistantGlobalValuesUsedforinformationthatchangesinfrequently,oftenreferencedCanloadedviaBatchLoader SOA IT List of Database Items There are more than 10,000 database items in the Fusion HCM
List of DBIs and user Entities (UEs) for are available in Note 1565118.1 for release 5 Note 1546399.1 for release 7 and above DBIs are used in various extracts, archives and reports across Fusion HCM SOA IT AgendaIntroduction to Fast Formula Formula
Creation and Components Formula Syntax Sample Fast Formula SOA IT Documentation on Fast Formulas OracleOnlineDocumentationOracleFusionApplicationsGuidehttp//docsoraclecom/cd/E38454/doc111736894pdf(Release FusionPayrollFFFrequentlyAskedQuestions(FAQ
)(NoteFusionPayrollTroubleshootingGuide(NoteCaseStudyFusionFastFormulaHowCreateFastFormulaForElementEntryInputValueValidation(NoteBenefitsFastFormulaReferenceGuideforOracleFusionBenefits(Note SOA IT Documentation on Fast FormulasLoadingDatausingPayrol
lBatchLoaderTechnicalEssay(NoteHowEnableLoggingforOracleFusionGlobalPayroll(NoteHowCreateNewGlobalValuesUsedFF(NoteExtractsDatabaseItems(DBIs)andUserEntities(UEs)(NoteDatabaseItemsforExtractsandFormulasinOracleFusionHCM(Note1565118 HCM Communities htt
ps://community.oracle.com/community/support/fusion_applic ations/human_capital_management_%28hcm%29 SOA IT Fast Formula SyntaxVariableInputvariablesappearINPUTstatementsandbringvalueintoformulaOutputvariablesappearRETURNstatementsandreturnvaluesfro
mformulavariablecanbebothinputandoutputLocalvariablecanbeusedinsidetheformulaGlobalValuesGlobalValuesareusedforinformationthatchangesinfrequently,butoftenreferencedDocumentationHowCreateNewGlobalValuesBeUsed(Note SOA IT Fast Formula SyntaxContextsCont
extinformationthatalwaysavailableeachformulatyperunContextsareavailableforcertainformulatypesExamplescontextsEFFECTIVE_DATEforeffectivedateformulaisexecutingPAYROLL_IDforrunningpayrollPERSON_IDidentifyingpersonforwhomformulaisexecutingContextvaluesact
SQLbindvalueswhendatabaseitemvaluesarefetchedfromthedatabaseTheycanalsobepassedintoformulafunctioncallsRelated methodsfor the context are:GET_CONTEXT : To find the value from the contextCONTEXT_IS_SET: To find whether a context is setSET_CONTEXTS: to
set one or more contexts SOA IT Fast Formula SyntaxArrayprocessingLoopingWHILElooptypesupportedWorkingStorageAreaTheworkingstorageareaismechanismforstoringglobalvaluesacrossformulasThevaluesareaccessednameThenamesarecaseindependentTherearefourworking
storageareacallmethodsWSA_EXISTSWSA_DELETEWSA_SET WSA_GET SOA IT Fast Formula SyntaxFunctionsFastFormulaFulllistfunctionsFusionHCMisavailableinFastFormulaGuideTextfunctionsmanipulatethedataGREATEST,INSTR,LEAST,LENGTH,LOWER,LPAD,LTRIM,REPLACE,RPAD,RT
RIM,SUBSTR,TRIM,UPPERNumericformulafunctionsABS,FLOOR,GREATEST,LEAST,MOD,POWER,ROUND,ROUNDUP,TRUNCDateformulafunctionsADD_DAYS,ADD_MONTHS,ADD_YEARS,DAYS_BETWEEN,GREATEST,LAST_DAY,LEAST,MONTHS_BETWEEN,NEW_TIME,NEXT_DAY,ROUND,TRUNC SOA IT Fast Formula S
yntaxCallingFormulafromFormulaformulacanbecalledfromanotherformulaTherearemethodsavailableIS_EXECUTE(formulaname)EXECUTE(formulaname)SET_INPUT(input[,value])GET_OUTPUT(output,defaultvalue)Example CaseStudyFusionAbsenceManagementUnableAccessReligion Re
latedDBIInCORE_ABSENCE_DURATIONFastFormula(DocID1670627 SOA IT AgendaIntroduction to Fast Formula Formula Creation and Components Formula Syntax Sample Fast Formula SOA IT Sample Fast Formula/*********************************************************
*********************FORMULANAMEAUF_ABSENCE_DURATIONFORMULATYPEGlobalAbsenceTypedurationFormulaDESCRIPTIONThisformulareturnsdaysbetweenabsenceChangeHistoryNameDateVersionComments-------------------------------------------------------------------------
------OracleNovDRAFTInitialVersion*******************************************************************************/DEFAULTFORIV_START_DATE(date)DEFAULTFORIV_END_DATE(date)INPUTSAREIV_START_DATE(date),IV_END_DATE(date)/*Durationto_numto_char(DAYS_BETWEE
N(IV_END_DATEIV_START_DATE)))+DurationDAYS_BETWEEN(ADD_DAYS(IV_END_DATE,IV_START_DATE)RETURNDuration Oracle FastFormulaUser’s Guide: https://docs.oracle.com/cd/E18727_01/doc.121/e14567/T1774T1776.htm SOA IT Thank You Sourav PalEmailsourav.pal@soa