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

How to burst and deliver a single CSV file to SFTP when no column has a common value for all records

in Reporting and Analytics for ERP

Hi team,

I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to:

  • Generate one CSV file
  • Containing all records
  • Deliver the file to SFTP location
  • Using BI Publisher Bursting

Key Constraints:

  • The data does not contain any column with the same value across all rows
  • We do not want to add a dummy or constant column (e.g. 1, ALL) to the main data, because that column appears in the CSV output
  • When a hard-coded value (like 'ALL') or DUAL is used directly as the bursting KEY, the job fails with:

java.lang.StringIndexOutOfBoundsException

Requirement:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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