My Oracle Support Banner

LOV Dropdown Does Not Copy Down To Rows In FOR Loop In Excel Template (Doc ID 2792269.1)

Last updated on AUGUST 30, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.

Goal

Why does the LOV List not copy down to rows in FOR loop in Excel template?
Create a BIP excel report and use XML as data source for it.
Have a section in the report which lists LOV values for a particular field (say: Reason Codes from REASON_CD table, and this section is used as source for LIST option on one of the columns in data lines section (within FOR loop) 
Reason code lookup works on the first data line only where data validation was setup, but when report is run and more data lines are generated, the list is not available on subsequent rows for showing the drop down list.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.