My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.