My Oracle Support Banner

ORetail ISSC - Cant Accept/promote To Authorized Status After Pressing Accept In ISSC (Doc ID 1513721.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Retail In-Store Space Collaboration - Version 13.2.3.15 and later
Information in this document applies to any platform.

Symptoms

Based on settings in the following tables, it is not possible to move into an Auth Status when using the Accept button:

##The sta_id_accept must be set to go into the id for Auth, in the OD1323UAT11 table this is set up for Proposal to go to Auth (STA_ID = 25)
select * --sta_id, sta_desc, sta_id_accept, sta_id_reject
from avttb_status
where stt_id = 7
order by sta_id;
update avttb_status set sta_id_accept = 25 where sta_id = 23 and stt_id = 7;


##AVTTB_PROCESS_FLOW is set up as follows
insert into avttb_process_flow (msf_id, pfl_id, sta_id, usg_id, pfo_id) values (3,1,42,1,3);
insert into avttb_process_flow (msf_id, pfl_id, sta_id, usg_id, pfo_id) values (3,1,41,1,3);
insert into avttb_process_flow (msf_id, pfl_id, sta_id, usg_id, pfo_id) values (3,1,40,1,3);
insert into avttb_process_flow (msf_id, pfl_id, sta_id, usg_id, pfo_id) values (3,1,23,1,3);


##FOLLOWING ARE SET TO ZERO, SO NO LEAD TIME
select * from avttb_system_variable where svr_id in (428,429);


##Example: User is [test_user] who belongs to the admin group

##SCENARIO
1. Go into ISSC as user [test_user], open jscC1/Ground/Revision 1/0145-sp-23 (Proposal),
2. Open and make a change (remove a fixture, confirm and then close, click on the Accept button, and then check status, it is still set as Proposal FAIL

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.