After Applying PA Delta 6, Patch 17839156, Error "The table PA_PROJECTS_ALL is missing the column BILL_LABOR_ACCRUAL" is in the Worker Log for the Patch for pa_projects_all.xdf. (Doc ID 2080044.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After applying PA delta 6, patch:17839156, the following error appears in the worker log:

Error in worker log:

Table Name is PA_PROJECTS_ALL
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 201
The table PA_PROJECTS_ALL is missing the column BILL_LABOR_ACCRUAL

Executing statement

ALTER TABLE PA.PA_PROJECTS_ALL ADD ( BILL_LABOR_ACCRUAL VARCHAR2(1) DEFAULT 'N' NULL )

Start time for statement above is Wed Nov 18 23:48:33 CST 2015
End time for statement above is Wed Nov 18 23:48:33 CST 2015
Error in executing statement ALTER TABLE PA.PA_PROJECTS_ALL ADD ( BILL_LABOR_ACCRUAL VARCHAR2(1) DEFAULT 'N' NULL )
Error message is ORA-28133: full table access is restricted by fine-grained security
ORA-06512: at "APPS.PA_PROJECTS_ALL_T1", line 4
ORA-06512: at "APPS.PA_PROJECTS_ALL_T1", line 25
ORA-04088: error during execution of trigger 'APPS.PA_PROJECTS_ALL_T1'

Error code is 28133
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Wed Nov 18 23:48:33 CST 2015]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.

Time when worker failed: Wed Nov 18 2015 21:48:33

The following PA objects were invalid:

PA_CUSTOMER_INFO
PA_PROJ_TEMPLATE_SETUP_UTILS
PA_PROJECT_CORE
PA_PROJECT_CORE1
PA_PROJECT_PUB
PA_PROJECTS_PKG
PA_PROJECTS_PKG1
PA_PROJECTS_V
PA_TASKS_MAINT_PVT

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