DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query not working in Oracle Developer 2000 / Reports Builder For Win 95/NT

604708Feb 13 2008 — edited Feb 14 2008

Hii

I've written and tested a query in TOAD which isn't working in Oracle Reports and i'm confronted with the error

REP-0496: Internal Error - Unable to parse the query

I'm using Developer 2000 / Report Builder For Windows 95 / NT.

Moreover on my laptop i'm using Windows XP and the remote host is an Oracle Apps 11i 11.5.9 with Oracle 9.2.x Db and i've to develop custom reports for this application.

SELECT DISTINCT
PAPF.PERSON_ID,
PAPF.APPLICANT_NUMBER,
PAPF.FULL_NAME AS EMPLOYEE_NAME,
PG.NAME AS GRADE,
PPG.GROUP_NAME AS BANK_GROUP,
PQFS.TITLE AS QUALIFICATIONS
FROM
PER_ALL_PEOPLE_F PAPF
INNER JOIN
PER_ALL_ASSIGNMENTS_F PAAF
ON
PAPF.PERSON_ID=PAAF.PERSON_ID
INNER JOIN
PER_GRADES PG
ON
PG.GRADE_ID=PAAF.GRADE_ID
INNER JOIN
PER_QUALIFICATIONS PQFS
ON
PAPF.PERSON_ID=PQFS.PERSON_ID

INNER JOIN
PAY_PEOPLE_GROUPS PPG
ON
PPG.PEOPLE_GROUP_ID=PAAF.PEOPLE_GROUP_ID

Kindly Help

Regards

Fahad Hameed