Skip to main content

Hello everyone,

 

I want to update the supplier association number using a data migration job.
I have identified the relevant package to use: Supplier_Info_General_API.Modify__.

When I call this package through a PL/SQL script, it works as expected and successfully updates the value.

the package is called by the crud_update method :

supplier_handling_svc.crud_update(
                '*',
                v_supplier_id,
                'ASSOCIATION_NO' || chr(31) || v_association_no || chr(30),
                'DO',
                supplier_info_general## => ''
            );


However, when I run the same operation through the data migration job, no changes occur.

 

Any idea why please?

The select statement generated by the datamigration job do return the correct value :

 

Datamigration Job Details : 

The ATTR_ value used is : 

 

'ASSOCIATION_NO'|| chr(31)|| IC_I_SUPP_ASSOC_UPDATE_TAB.association_no|| chr(30)

Hi ​@N.GEORGI 

CHR(31) and CHR(30) will not be taken in consideration when you use it the source mapping.

But there is an easier way to solve your requirement.

Tick off “New”

 

Go to the Source Mapping.

Remove all not needed columns in the source mapping and only keep the key fields and the field you want to update.

Execute.

/Jens

​@Jens , thank you, i’ll try it and let you know 

 

In general, is there any equivalent for the CHR(31) and CHR(30) please?

​@Jens the datamigration works well when picking the supplier_info_general view.

 

For other packages, and in general , is there any equivalent for the CHR(31) and CHR(30) please?

Terms & ConditionsCookie settingsAccessibility statement