Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Help with my SQL Code — 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

Help with my SQL Code

Accepted answer
57
Views
1
Comments
edited Mar 13, 2017 10:29AM in General Transactional Reporting (OTBI) 1 comment

Summary

Help with my SQL Code

Content

I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like  HR_DOCUMENTS_OF_RECORD, FND_DOCUMENTS_TL, ,FND_ATTACHED_DOCUMENTS and per_all_people_f with related to person_id.

Problem is my BIP report with below query keeps erroring. The SQL is valid but the SQL query pulls back too many records. How can I get this to work ?

select   "PER_ALL_PEOPLE_F"."PERSON_ID" as "PERSON_ID",

            "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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