Hi kenDonald

Most common used oracle projects tables & views are :

1.PA_PROJECTS_ALL
stores the highest units of work defined in Oracle Projects.

2.PA_TASKS
stores user-defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks.

3.PA_PROJECT_TYPES
Implementation-defined project classifications that supply default information and drive some project processing.

4.PA_PROJECT_PLAYERS
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

5.PA_AGREEMENTS_ALL
Customer contracts that serve as the basis for work authorization

6.PA_BUDGET_VERSIONS
stores the versions of project budgets. There are three categories of budget versions: Draft, Baselined, and Original.

7.PA_BUDGET_LINES
stores the detail information of a project or task budget, including the resource, time period and budget amounts entered. The time period may be PA period, GL period, or any user-defined period.

8.PA_DRAFT_REVENUES_ALL
Stores information about draft revenue generated for projects

9.PA_DRAFT_REVENUE_ITEMS
stores the lines of a draft revenue.

10. PA_DRAFT_INVOICES_ALL
Information about draft invoices generated for projects.

11. PA_DRAFT_INVOICE_DETAILS_ALL
Inter company invoice details for cross charged transactions.

12. PA_CLASS_CATEGORIES
Implementation-defined categories for classifying projects.

13. PA_CLASS_CODES
Implementation-defined values within class categories that can be used to classify projects.

14. PA_EXPENDITURE_COST_RATES_ALL
Cost rates for non-labor expenditure types

15.PA_BILL_RATES_ALL
Information about bill rates and markups of standard bill rate schedules.
 
Note: this is not all the tables and views are available in oracle projects application, however this may help you to get a small insights about what are these tables ? and small description of each one.
 
Regards. 

Hi albert

To fix this error, you will need to apply the following:

1. Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first).
2. Add the following parameter below the <inprocess> parameter:
   • <!–webcommandaccess>L1</webcommandaccess–>
   • Then change the value from L1 to L2
   • <webcommandaccess>L2</webcommandaccess>
3. Save and close the file
4. Restart WLS_REPORTS

Hello mahendra try this code now :

SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID
               ,PAA.ABSENCE_ATTENDANCE_TYPE_ID
               ,PAA.ABS_INFORMATION1
               ,PAA.PERSON_ID
               ,PAPF.FULL_NAME FNA
               ,PAPF.EMAIL_ADDRESS EM
               ,PAA.REPLACEMENT_PERSON_ID
               ,PAPF1.FULL_NAME FNR
               ,PAA.AUTHORISING_PERSON_ID
               ,PAPF2.FULL_NAME FNAUT
               ,PAA.DATE_NOTIFICATION
               ,PAA.DATE_START
               ,'\ \\\\\\for a period of \\\\\\\' || PAA.ABSENCE_DAYS || '\\\\\\\ days up to\\\\\\\'
               ,PAA.DATE_END
INTO   &ABSENCE_ATTENDANCE_ID
      ,&ABSENCE_ATTENDANCE_TYPE_ID
      ,&ABS_INFORMATION1
      ,&PERSON_ID
      ,&FULL_NAME
      ,&EMAIL_ADDRESS
      ,&REPLACEMENT_PERSON_ID
      ,&FULL_NAME
      ,&AUTHORISING_PERSON_ID
      ,&FULL_NAME
      ,&DATE_NOTIFICATION
      ,&DATE_START
      ,&ABSENCE_DAYS
      ,&DATE_END
FROM   PER_ABSENCE_ATTENDANCES PAA
      ,PER_ALL_PEOPLE_F PAPF
      ,PER_ALL_PEOPLE_F PAPF1
      ,PER_ALL_PEOPLE_F PAPF2
WHERE  1 = 1
AND    PAA.ABSENCE_ATTENDANCE_ID = 132128
AND    PAA.PERSON_ID = PAPF.PERSON_ID
AND    PAA.REPLACEMENT_PERSON_ID = PAPF1.PERSON_ID(+)
AND    PAA.AUTHORISING_PERSON_ID = PAPF2.PERSON_ID(+)
AND    TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE AND PAPF2.EFFECTIVE_END_DATE

but in the next time you create a question could you please leave more details about what you are trying to do or the error text along with error code you face to be able to help you efficiently.