Query against view fnd_conc_requests_form_v is giving multiple rows against single request id
Hi all,
Query against view fnd_conc_requests_form_v is giving multiple rows against single request id.
I would like to know the reason for this issue.
EBS:12.2.5
DB :12.1.0.2
All request_id have more than 1 rows if I run the query using sys.
SQL> show user
USER is "SYS"
SQL> select ACTUAL_START_DATE from apps.fnd_conc_requests_form_v WHERE REQUEST_ID=5934686;
ACTUAL_START_DATE
------------------
04-JUN-18
04-JUN-18
04-JUN-18
04-JUN-18
select count(1) , REQUEST_ID from apps.fnd_conc_requests_form_v group by REQUEST_ID having count(1)=1;
6889 rows selected.
select count(1) , REQUEST_ID from apps.fnd_conc_requests_form_v group by REQUEST_ID having count(1) >1;