My Oracle Support Banner

During Upgrade From FSCM 9.1 To 9.2, Task 5-15-4: Creating Triggers Encountered 'PLS-00049: bad bind variable' Errors (Doc ID 2147431.1)

Last updated on NOVEMBER 17, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


While going through task 5-15-4: 'Creating Triggers' during an upgrade from 9.1 to 9.2 Image 11, the Create Triggers script failed because it attempted to create triggers PSUPROJ_CATG_TBL PSUPROJ_RES_TYPE PSUPROJ_SUBCAT_TBL and PSUPROJECT on non-existent columns SYNCID and SYNCDTTM on four tables, PS_PROJ_CATG_TBL, PS_PROJ_RES_TYPE, PS_PROJ_SUBCAT_TBL and PS_PROJECT.

Since the SYNCID and SYNCDTTM columns are not on these tables in 9.2 can we ignore the errors?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.