Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Trans_barcode_conf Error in Xstore

edited Jul 18, 2020 5:11AM in Retail Point-of-Service Solutions (MOSC) 7 commentsAnswered

Hi Community,

There's an trans_barcode_error in xstore v18 when store ID length is of 5 digits and starts with 9 as initial digit like 91000.

Kindly anyone suggest me on this.

execute [151.282 ms StorePrimary]  SELECT tsn_session.tndr_repository_id, tsn_session.session_id, st.tndr_id, t.tndr_id FROM tsn_session INNER JOIN tsn_tndr_repository r ON tsn_session.organization_id = r.organization_id AND tsn_session.rtl_loc_id = r.rtl_loc_id AND  UPPER(tsn_session.tndr_repository_id) = r.tndr_repository_id INNER JOIN tsn_session_tndr st ON st.organization_id = tsn_session.organization_id AND st.rtl_loc_id = tsn_session.rtl_loc_id AND st.session_id = tsn_session.session_id LEFT JOIN tnd_tndr t ON t.organization_id = st.organization_id AND t.tndr_id = st.tndr_id WHERE r.organization_id = 817 AND r.rtl_loc_id = 91013 AND t.tndr_id IS NULL   :: dtv.data2.access.impl.jdbc.DtvPreparedStatement [startup]

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center