Question

Updating an existing custom field that is indexed

  • 18 December 2023
  • 1 reply
  • 43 views
A
Rank
Userlevel 1
Badge +4

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?

1 reply

Jens
Rank
Userlevel 4
Badge +8

Hi @Ash1807 

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

Reply


Terms & ConditionsCookie settings