You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why Value set is still calculating in view document of record already submitted

Summary:

Why Value set is still calculating in view document of record already submitted.

Content (please ensure you mask any confidential information):

I have a value set with connect by level to get the result of sum as follow

*FROM Clause

(SELECT ROUND((LEVEL -1)*1,0) AS number_value from dual connect by LEVEL <=200) T

*Value Column Name

NVL(t.number_value,0)

ID Column Name

NVL(t.number_value,0)

WHERE Clause

t.number_value = ( SELECT NVL(SUM(XX.DEI_ATTRIBUTE_NUMBER1 * XX.DEI_ATTRIBUTE3), 0)
FROM
HR_DOCUMENTS_OF_RECORD XX
WHERE 1=1
AND XX.DEI_ATTRIBUTE_CATEGORY like '%OVERTIME_ASSIGNMENT_CODE%'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!