SKUs are not appearing in JDA

Overview

You are facing some SKUs that are not appearing in JDA and you'd like to reflag them.

Solution

Please reach out to the Support team and provide SKUs that are not appearing in JDA and the support team will reflag them in the DB.

 

<supportagent>

Note: The agent should have access to the customer's DB.

To reflag the SKUs you need to delete flags from the DB using SQL queries:

It is recommended to create backup tables first before changing the data and drop the backup tables after the solution is confirmed:

create table sup.zd2544171_FF_PRODUCT_REGISTER as 
select * from XDI_180416.FF_PRODUCT_REGISTER
where sty_barcode in ('n1','n2',...);

Clearing the flag:

delete from XDI_180416.FF_PRODUCT_REGISTER 
where sty_barcode in ('n1','n2',...)
and sty_barcode in
( select sty_barcode from sup.zd2544171_FF_PRODUCT_REGISTER );
COMMIT;

where:

  • XDI_180416 - is the latest XDI schema name
  • 'n1','n2', ... - are SKUs provided by the customer

</supportagent>

Comments

0 comments

Article is closed for comments.