This content has been marked as final. Show 2 replies
We are interfacing with third party WMS systems (2 of them) which operate 24/7
It depends on what you mean by "access" - if you simply want to be able to query the database, I can see no reason why this cannot be allowed at any time during the RMS batch.
If you wish RMS to consume transactions on the RIB (e.g. shipping store orders, receiving POs, etc), I also found that I can do this at any time during the RMS batch without integrity problems OTHER than when salstage.pc is running.
As SALSTAGE essentially performs a destructive read on TRAN_DATA, it might be dangerous to have any processes writing to there at the same time. However, as TRAN_DATA is a view alternating over tables TRAN_DATA_A and TRAN_DATA_B and salstage.pc performs a "switcheroo" from the full table to the empty table by recreating the TRAN_DATA view, there is probably only a microsecond of time where there is danger of salstage.pc crashing due to inability to get exclusive lock on TRAN_DATA view to rebuild it.
While I have not tried it, my research points to the conclusion that the worst that could happen is that salstage.pc fails. This could be mitigated by setting up your job scheduler to retry, if such an error caused the job to fail.
Many thanks for the reply, gives some very useful insight.
Unfortunately I couldn't float this question by Oracle Retail EMEA as I resigned and left at the end of October. Currently freelancing on a project in the UK.