VO over pipelined function does not display data in the iterator

Inspired by my colleague and ADF guru @Valeri Borisov

The Problem

Few days ago I’ve found the next problem:

1. I had View Object based on pipelined function:
2. When I drag the VO on the page, I’ve received “No data to display”.
3. In the VO I could see rows but no rows in the Iterator.
4. Where is the problem?

The problem was that when I try to run the Application Module this specific pipelined VO did not return any results in table view but results exist in a form view:

Workaround 1 – first attempt 

I’ve found that the problem exists when we have different returned rows number and Iterator’s RangeSize

This worked very slowly.

Workaround 2 – the better solution

1. You can add Tuning in the View Object’s Behavior – fetch rows in batches of X rows:

2. Add RabgeSize = -1 for the Iterator:

 

Have you ever had a similar problem? I’ll be glad to read about your approach in the comments below?

Do you want more great blogs like this?

Subscribe for Dreamix Blog now!