1 Reply Latest reply on Mar 4, 2017 12:32 PM by Srini Chavali-Oracle

    PERIOD_FROM and PERIOD_TO value sets in Account Analysis

    Rajesh123

      Hi All,

       

      I am using below PERIOD_FROM and PERIOD_TO in Account Analysis custom report.

      values set queries

       

      PERIOD_FROM

      WHERE

        gl.ledger_id = :$FLEX$.XLA_SRS_JELINES_LEDGERS

        AND  gl.period_set_name = glp.period_set_name

        AND gl.accounted_period_type = glp.period_type

        AND glp.adjustment_period_flag = 'N'

        ORDER BY

        glp.Period_year DESC, glp.period_num DESC

       

      PERIOD_TO

      glp.adjustment_period_flag = 'N'

      AND gl.ledger_id = :$FLEX$.xla_srs_jelines_ledgers

      AND gl.period_set_name = glp.period_set_name

      AND gl.accounted_period_type = glp.period_type

      AND

      glp.period_year =

      (

             SELECT glp2.period_year

             FROM   gl_periods glp2

             WHERE  glp2.period_set_name = glp.period_set_name

                    AND glp2.period_type = glp.period_type

                    AND glp2.period_name = :$FLEX$.xla_srs_jelines_period_from

      )

      AND

      glp.period_num >=

      (

             SELECT glp2.period_num

             FROM   gl_periods glp2

             WHERE  glp2.period_set_name = glp.period_set_name

                    AND glp2.period_type = glp.period_type

                    AND glp2.period_name = :$FLEX$.xla_srs_jelines_period_from

      ) ORDER BY glp.period_year DESC, glp.period_num DESC

       

      1) Why is the Period From/To limited to a single year?  I’d like the ability to input “NOV-16” through “FEB-17” and this isn’t allowed.

       

      can u please help me on this?

       

      Apps R12.1.3