Technology Stack - EBS (MOSC)

MOSC Banner

Query against view fnd_conc_requests_form_v is giving multiple rows against single request id

edited Aug 8, 2018 5:00AM in Technology Stack - EBS (MOSC) 1 commentAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center