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 APRIL 17, 2025
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
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?
Solution
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
| Goal |
| Solution |
| References |