Skip to main content

Hi,

There is a migration job to create or update suppliers. We want to add ‘30’ prefix for the supplier id if the the supplier is a new supplier. I would like to know how we can do this.  we tried to get next supplier id and add ‘30’ prefix in the Method  List attribute as below. but it didn’t work.

Thanks,

Sachini

Hi sachini,

using the FIXED VALUE in the Method List Attribute won’t work bc it is just a fixed string.

It seems like you are parsing the value from the previous method 5.

The only way to make this work would be to inherit the Get_Next_Identity call in the method 10. So basically calling the Method in Method 10 and removing Method 5.

However this could lead to a complete rework of your existing job.

Hi ​@FlorianTauber ,

“The only way to make this work would be to inherit the Get_Next_Identity call in the method 10. So basically calling the Method in Method 10 and removing Method 5.”

 

Can you please give me the steps clearly to do above thing you mentioned in the comment?

 

Regards,

Sachini

Hi Sachini,

I would delete line 5.

On source mapping I would set the Source Column of SUPPLIER_ID  in the Source Mapping tab to be 

30|| Supplier_Info_General_API.Get_Next_Identity.

Like ​@FlorianTauber has mentioned, there might be impacts in other method lists / fields you are using and you may want to make sure all of those areas are covered.

Also, instead of having 10 and 15 to create the Supplier Info General, I may have only one of them and have a Case Statement.

Regards,

Malik

Hi ​@malik.sally ,

I am getting this error when I added '30' || SUPPLIER_INFO_GENERAL_API.GET_NEXT_IDENTITY Source Column of SUPPLIER_ID. Any idea how to fix this?

Regards,

Sachini

Are you all using Identity Series  to define the supplier number as shown below? 

 

If so, you will have to use party_identity_series_api.get_next_value('Supplier') instead of  SUPPLIER_INFO_GENERAL_API.GET_NEXT_IDENTITY

Hi ​@malik.sally ,

Yes. we are using Identity Series  to define the supplier number. When I add 

'30' || PARTY_IDENTITY_SERIES_API.GET_NEXT_VALUE('SUPPLIER') to Source Column of SUPPLIER_ID, supplier was created without ‘30’ prefix. How can I add ‘30’ prefix to supplier id?

Regards,

Sachini

Use  '30'||PARTY_IDENTITY_SERIES_API.GET_NEXT_VALUE('Supplier') in the Default Values column instead of the SOURCE_COLUMN as it is case sensitive and doesn’t return next value if you use SUPPLIER. 

Reply


Terms & ConditionsCookie settings