Is it possible to generate csv file with column labels of child records even when they don't exist? — Cloud Customer Connect
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 with Redwood: Oracle Cloud SCM and Purchasing

Is it possible to generate csv file with column labels of child records even when they don't exist?

Summary:

Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist.

Example:

Data Model queries:

Data Set Q1 (Parent):

SELECT invoice_id, invoice_num, invoice_amount, invoice_date FROM ap_invoices_all

Data Set Q2 (Child):

SELECT invoice_id, line_number, amount FROM ap_invoice_lines_all

Data Sets Q1 and Q2 are linked by invoice_id.

If records exist in Q2 for at least one record in Q1, then the CSV file will be generated with all columns, like this:

INVOICE_ID, INVOICE_NUM, INVOICE_AMOUNT, INVOICE_DATE, INVOICE_ID, LINE_NUMBER, AMOUNT

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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