HRMS 9.1 ACA Patch 24483819 Throwing Error For Altertables.sql (Doc ID 2215142.1)

Last updated on DECEMBER 16, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When applying HRMS 9.1 Patch 24483819 for the Affordable Care Act, an error results for the altertables.sql.

 

ERROR:
16:49:46 SQL> AR2(6) NOT NULL,
SP2-0734: unknown command beginning "AR2(6) NOT..." - rest of line ignored.
16:49:46 SQL> CNSLSTX_AMT DECIMAL(7, 2) NOT NULL,
SP2-0734: unknown command beginning "CNSLSTX_AM..." - rest of line ignored.
16:49:46 SQL> CNSLSTX_ANN_AMT DECIMAL(7, 2) NOT NULL) TABLESPACE BNLARGE STORAGE
SP2-0734: unknown command beginning "CNSLSTX_AN..." - rest of line ignored.
16:49:46 SQL>  (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0)
16:49:46   2   PCTFREE 10 PCTUSED 80
16:49:46   3  /
 (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0)
  *
ERROR at line 1:
ORA-00928: missing SELECT keyword


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Apply HRMS 9.1 ACA Patch for 2016 changes
2.  Run script for alter tables

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