Skip to main content
Question

Datamigration ATTR_ value

  • October 22, 2025
  • 3 replies
  • 26 views

Forum|alt.badge.img+6

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)

3 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • October 22, 2025

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


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • October 22, 2025

@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?


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • October 22, 2025

@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?