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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Empty Reports on BIP Result files with DATA_DS

edited May 31, 2021 9:27AM in Reporting and Analytics for HCM 7 comments

Summary

DATA_DS file removal

Content

Hello.

I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day.
When the report has no results, a file is created and sent to SFTP containing "DATA_DS" in its content.

This behaviour causes needles failures on the receiving side because it expects a structured format.

Is there a way to avoid creating a file if the query results in no records like on OTBI? I heard there's a workaround using Bursting but I have no idea how to set it.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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