Hello,
We’re getting errors when trying to migrate the Procurement Clause Connection Rules in 22R2, using FNDMIG. We’re getting errors not wanting a value for Connection ID, but when left null, we’re getting an ORA:00936 missing expression error. Data inputs without error manually.
Has anyone come across or found a fix/work-around for this?
Any help is very much appreciated!
Hello,
We’re getting errors when trying to migrate the Procurement Clause Connection Rules in 22R2, using FNDMIG. We’re getting errors not wanting a value for Connection ID, but when left null, we’re getting an ORA:00936 missing expression error. Data inputs without error manually.
Has anyone come across or found a fix/work-around for this?
Any help is very much appreciated!
Make sure there isn’t anything in the “Default Value” column. If that doesn’t work, can you try removing that column from the mapping tab altogether?
Thank you! I ended up figuring it out. We were using the INSERT_AND_UPDATE method to update some and insert others. This method does not work for inserting records. To insert, you must use the INSERT_BY_METHOD_NEW and delete the connection ID column from the file mapping (and file, of course).
Thanks, again, for your response and help!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
