R12 PAXPREPR - Unable to see Task in Project Entry Form due to Incorrect Definition of View PA_TASKS_WBS_V (Doc ID 1609396.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Oracle Project Foundation - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
*** Checked for relevance 27-Feb-2015 ***

Symptoms

After applying patch 17367189:R12.PJ_PF.B CUMULATIVE RELEASE 11 FOR 12.1.3 ON RELEASE DATE 28-AUG-2013, in the form PAXPREPR : for some projects, no task is displayed whereas there are some tasks existing in PA_TASKS table.

But in the other Forms (i.e. "Expenditure inquiry" or SelfService page"timecard entry"), the tasks are still available.

Have noticed that the view PA_TASKS_WBS_V is different in our test instance,the following restriction has been added to the view script :
AND LK.SECURITY_GROUP_ID = FND_GLOBAL.SECURITY_GROUP_ID


select * from PA_TASKS_WBS_V where project_id = 143165;
-- no row returned

select * from PA_WBS_V where project_id = 143165;
-- no row returned

select * from PA_TASKS TASK START WITH TASK.TASK_ID IN ( SELECT TASK_ID FROM PA_TASKS P WHERE P.PROJECT_ID =143165 ) CONNECT BY PRIOR TASK.PARENT_TASK_ID = TASK.TASK_ID ;
-- 3 rows returned

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms