Custom BI Publisher ESS Job from Oracle Fusion ERP with Oracle EPM Data Integration (ARCS)

We are integrating a custom BI Publisher ESS Job from Oracle Fusion ERP with Oracle EPM Data Integration (ARCS).

The BI Publisher report has two parameters, both of type DATE:

• GL From Date
• GL To Date

Scenario:

1.When we pass hard coded dates, the integration works successfully.

Parameter List:

2025-12-01,2025-12-31

The ESS job executes successfully, generates the report, and Data Integration proceeds as expected.However, we need to pass the dates dynamically based on the EPM period.

We tried using the following Parameter List:

'$START_PERIODKEY[YYYY-MM]$'||'-01',$START_PERIODKEY[YYYY-MM-DD]$

The Data Integration log shows: