PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

how to adjust group by clause in query

edited Jan 31, 2018 4:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

Hi how to prevent query manager from automatically adding the expression - (SUM(  SUM( A.POSTED_TOTAL_AMT))-SUM(  SUM( B.BUDGET_AMOUNT)))"VARIANCE" to the group by clause

SELECT (SUM(  SUM( A.POSTED_TOTAL_AMT))-SUM(  SUM( B.BUDGET_AMOUNT)))"VARIANCE", A.DEPTID, B.DEPTID, SUM(POSTED_TOTAL_AMT), SUM( B.BUDGET_AMOUNT)
  FROM PS_NJ_ACT_EXP_A_VW A, PS_NJ_D_BUD_EXP_VW B
  WHERE ( A.FISCAL_YEAR = :1
     AND A.ACCOUNTING_PERIOD <= :2
     AND A.DEPTID = B.DEPTID
     AND B.FISCAL_YEAR = :1
     AND B.ACCOUNTING_PERIOD <= :2
     AND A.FISCAL_YEAR = B.FISCAL_YEAR
     AND A.ACCOUNTING_PERIOD = B.ACCOUNTING_PERIOD)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center