I am using the Data migration tool in Apps9 to update an existing custom field. This field is indexed and coming up with the error:
- Execution No 0
Error creating index CREATE INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB() - ORA-00936: missing expression
Do I need to set up the DM job in a certain way?
+10Hi
it seems that the field which shall be indexed is missing in the following SQL statement (in red characters below):
CREATE INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB(<FIELD>)
I suppose you’re using a migration job with the procedure MIGRATE_SOURCE_DATA or are you using another procedure for that purpose (INSERT_OR_UPDATE, INSER_BY_METHOD_NEW)?
Can you please provide me screenshots of the tabs “Rules” and also “Source Mapping”?
/Jens
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
