Account Analysis Report - How to Pass Account Filter (P_FLEX_FIELD_RANGE_FILTER_ID)

Summary:

We are working with the Account Analysis Report in Oracle Fusion (ESS Job). When we apply an Account filter (Natural Account segment) in the report submission UI, the system generates a new sequence ID each time, which appears in the XML output as P_FLEX_FIELD_RANGE_FILTER_ID tag

Observations:

• Every time the report is re-submitted freshly with any account filter, a new sequence ID is generated.

• This value is then passed as argument 56 (P_FLEX_FIELD_RANGE_FILTER_ID) to the ESS job.

The filter definition seems to be stored internally (possibly in a flex filter table), and the ESS job references this ID instead of the actual segment values.