5 Replies Latest reply: Jul 31, 2013 9:59 AM by Vigneswar Battu RSS

    OTL setup

    887911

      Dear All,

      I am doing setup for OTL. I am defining new FF, but i cannot see OTL type formula in LOV of fomula Type.

      Also I cannot see any fast Formula in Fast Formula LOV in time entery rule form..

       

      How I can enable FF formula type for OTL... I have register licence  for OTL in Licence manager by SYSADMIN.. please help me what I am missing ???

        • 1. Re: OTL setup
          Vigneswar Battu

          Where are you not able to see the formulas ?

          What responsibility are you using ?

           

          Did you go through the different formula types available for OTL -

          ttp://docs.oracle.com/cd/E18727_01/doc.121/e13521/T83865T412733.htm

           

          Cheers,

          Vignesh

          • 2. Re: OTL setup
            887911

            Thank Vignesh for reply,

             

            Where are you not able to see the formulas ?

            Ans: I cannot see the Formulas on Write Formula Form. like i query seeded formula HXC_PERIOD_MAXIMUM but not found.

            also I cannot see the Seeded formula when defining the Time Entry rules.


            What responsibility are you using ?

            Ans: using Global Super HRMS Manager to write new FF. and using Global OTL Application Developer to define entry rules.


            I have enable the Licence for OTL from application manager in system administrator  resp.


            Also when I run the query

            SELECT  *

              FROM ff_formula_types ft

              where ft.formula_type_name like 'OTL%' --'OTL Time Entry Rules'

            its do not return any row...

            So there is no OTL formula type in  ff_formula_types.

             

            Do I need to apply any patches after I enable the Licence ??

            can you guide me with the steps to enable the OTL FF??

             

            we are on Oracle Applications : 11.5.10.2

             

            Waiting for reply....

             



            • 3. Re: OTL setup
              Vigneswar Battu

              Did you check these ?



              • 4. Re: OTL setup
                887911

                Thanks Vignesh for reply,


                I have checked Oracle 11i Time and Labor (OTL) Mandatory Patch List (Doc ID 214886.1)

                 

                Do i need to apply the patch listed in above note 214886.1 ??

                 

                as I see  HR family pack info 414631.1

                i run the SQL listed in note  414631.1 it gives me below ....

                 

                SQL>

                SQL> COLUMN ID FORMAT a4

                SQL> COLUMN APPPLICATION FORMAT a40

                SQL> COLUMN STATUS FORMAT a15

                SQL> COLUMN "PATCH LEVEL" FORMAT a11

                SQL> SELECT to_char(V.APPLICATION_ID) "ID"

                  2  ,V.APPLICATION_NAME "APPPLICATION"

                  3  ,L.MEANING "STATUS"

                  4  ,DECODE(I.PATCH_LEVEL, NULL, '11i.' || v.APPLICATION_SHORT_NAME || '.?', I.PATCH_LEVEL) "PATCH LEVEL"

                  5  FROM FND_APPLICATION_ALL_VIEW V, FND_PRODUCT_INSTALLATIONS I, FND_LOOKUPS L

                  6  WHERE (V.APPLICATION_ID = I.APPLICATION_ID)

                  7  AND (V.APPLICATION_ID IN

                  8  ('0', '50', '178', '275', '453', '800', '801', '802', '803',

                  9  '804', '805', '808', '809', '810', '8301', '8302', '8303'))

                10  AND (L.LOOKUP_TYPE = 'FND_PRODUCT_STATUS')

                11  AND (L.LOOKUP_CODE = I.Status )

                12  ORDER BY 1

                13  /

                 

                ID   APPPLICATION                             STATUS          PATCH LEVEL

                ---- ---------------------------------------- --------------- -----------

                0    Application Object Library               Installed       11i.FND.H

                178  Self-Service Web Applications            Installed       11i.ICX.I

                275  Projects                                 Installed       11i.PA.L

                453  Human Resources Intelligence             Installed       11i.HRI.F

                50   Applications DBA                         Shared          11i.AD.I.5

                800  Human Resources                          Installed       11i.PER.P.2

                801  Payroll                                  Installed       11i.PAY.O.2

                802  FastFormula                              Shared          11i.FF.K.2

                803  DateTrack                                Shared          11i.DT.J.2

                804  SSP                                      Installed       11i.SSP.L.2

                805  Advanced Benefits                        Installed       11i.BEN.O.2

                808  Time and Labor                           Installed       11i.HXT.H

                809  Time and Labor Engine                    Installed       11i.HXC.C

                810  Learning Management                      Shared          11i.OTA.J.1

                8301 US Federal Human Resources               Installed       11i.GHR.L.2

                8302 Public Sector HR                         Installed       11i.PQH.L.2

                8303 Public Sector Payroll                    Installed       11i.PQP.L.2

                 

                17 rows selected

                 

                SQL>

                SQL> SELECT 'HR_PF.' ||

                  2  DECODE (BUG_NUMBER,'2115771'  ,'A(2115771)',

                  3                     '2268451'  ,'B(2268451)',

                  4                     '2502761'  ,'C(2502761)',

                  5                     '2632500'  ,'D(2632500)',

                  6                     '2803988'  ,'E(2803988)',

                  7                     '2968701'  ,'F(2968701)',

                  8                     '3116666'  ,'G(3116666)',

                  9                     '3233333'  ,'H(3233333)',

                10                     '3127777'  ,'I(3127777)',

                11                     '3333633'  ,'J(3333633)',

                12                     '3500000'  ,'K(3500000)',

                13                     '5055050'  ,'K RUP1(5055050)',

                14                     '5337777'  ,'K RUP2(5337777)',

                15                     '6699770'  ,'K RUP3(6699770)',

                16                     '7666111'  ,'K RUP4(7666111)',

                17                     '9062727'  ,'K RUP5(9062727)',

                18                     '10015566' ,'K RUP6(10015566)',

                19                     '12807777', 'K RUP7(12807777)',

                20                     '14488556', 'K RUP8(14488556)') ||

                21  ' patchset is installed ' "HR Family Pack",

                22  to_char(last_update_date,'DD-MON-YYYY HH24:MI:SS') "DATE APPLIED"

                23  FROM AD_BUGS

                24  WHERE BUG_NUMBER in ('2115771','2268451','2502761','2632500','2803988',

                25  '2968701','3116666','3233333','3127777','3333633','3500000', '5055050',

                26  '5337777','6699770','7666111','9062727','10015566','12807777','14488556')

                27  ORDER BY to_number(BUG_NUMBER) DESC

                28  /

                 

                HR Family Pack                                DATE APPLIED

                --------------------------------------------- --------------------------

                HR_PF.K RUP2(5337777) patchset is installed   04-JUL-2007 00:58:39

                HR_PF.K RUP1(5055050) patchset is installed   04-JUL-2007 01:07:25

                HR_PF.K(3500000) patchset is installed        02-JUL-2007 04:40:12

                HR_PF.I(3127777) patchset is installed        29-OCT-2004 00:30:15

                HR_PF.E(2803988) patchset is installed        26-JUN-2003 01:54:17

                HR_PF.C(2502761) patchset is installed        25-OCT-2002 14:55:37

                HR_PF.A(2115771) patchset is installed        30-MAY-2002 18:13:44

                 

                So do I need to apply the patches listed in note  214886.1 under section  HXT.11i Rollup 2 ???

                • 5. Re: OTL setup
                  Vigneswar Battu

                  Sorry mate.. We're on r12. So cannot check the patches at our end.

                  But if you're not seeing the seeded formulas,esp from the back-end, then definitely some patches are missing.

                   

                  Try applying all the patches mentioned in the note.

                  Else SR is the only way, I'm afraid.