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

Testing

Once the Service is called again by the third-party application, JDA, this would repopulate the same entries again to the XDI_180416.FF_PRODUCT_REGISTER table that was deleted.  The agent should use the content of the given table as a flag whether it was called or not, and check that the flag was retrieved by JDA and not showing ready to be picked anymore.

</supportagent>