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.
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.
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
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 =  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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms