SQL Language (MOSC)

MOSC Banner

error while compiling the invalid objects

edited Sep 11, 2014 5:02AM in SQL Language (MOSC) 1 commentAnswered

HI ALL

when i'm comiling the invalid objects in the database i'm getting the following error:


Failed to compile: ORA-00979: not a GROUP BY expression

invalid object: APPS.CST_LAYER_ACTUAL_COST_DTLS_V


object query:

SELECT CLACD.TRANSACTION_ID, CLACD.ORGANIZATION_ID, CLACD.LAYER_ID, CLACD.INV_LAYER_ID, CLACD.LAYER_QUANTITY, CLACD.TRANSACTION_SOURCE_TYPE_NAME, CLACD.TRANSACTION_SOURCE_TYPE_ID, CLACD.MATERIAL_COST, CLACD.MATERIAL_OVERHEAD_COST, CLACD.RESOURCE_COST, CLACD.OUTSIDE_PROCESSING_COST, CLACD.OVERHEAD_COST, CLACD.TOTAL_UNIT_COST, CLACD.TRANSACTION_SOURCE_ID, CLACD.TRANSACTION_SOURCE_NAME FROM ( SELECT MCLACD.TRANSACTION_ID , MCLACD.ORGANIZATION_ID , MCLACD.LAYER_ID , MCLACD.INV_LAYER_ID , MCLACD.LAYER_QUANTITY , MTST.TRANSACTION_SOURCE_TYPE_NAME , CIL.TRANSACTION_SOURCE_TYPE_ID , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 1 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) MATERIAL_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 2 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) MATERIAL_OVERHEAD_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 3 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) RESOURCE_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 4 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) OUTSIDE_PROCESSING_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 5 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) OVERHEAD_COST , SUM(NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0)) TOTAL_UNIT_COST , CIL.TRANSACTION_SOURCE_ID , CIL.TRANSACTION_SOURCE TRANSACTION_SOURCE_NAME , MMT.TRANSACTION_ACTION_ID FROM

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