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

Define Rollup - ERROR: JBO-29147: Unexpected token 'SYSDATE'

in Sales 9 comments

Summary:

RELATED OBJECT FILTER from Oracle Document (Move_from_Classic_Aggregates_to_Rollups_1.2.pdf)


ActivityTypeCode='CALL' AND((ActivityFunctionCode='TASK' AND StatusCode='COMPLETE') OR(ActivityFunctionCode='APPOINTMENT' AND ActivityEndDate < SYSDATE) OR (ActivityFunctionCode='CALLREPORT' AND ParentActivityId IS NULL)) AND AccountId = ?

There's an Error when applying this filter to a new custom roll up:

JBO-29147: Unexpected token 'SYSDATE'. JBO-29147: Unexpected token '?1".

Is there a need to update the Related Object Filter vs. what's inside the Oracle Document?


Oracle Fusion Cloud Applications24A (11.13.24.01.0)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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