Re: Design Question

Does anyone have suggestions on this one?

Thanks & Regards
Vishalaksha Vyas

On Mon, Jan 15, 2018 at 4:58 PM, Vishalaksha Vyas <vishalaksha_at_gmail.com> wrote:

> Hello Experts,
>
>
>
> I need an advice on the interface design between two Oracle systems. These
> two systems would be Oracle ERP (R12, DB: 11g R2) and standalone
> application using Oracle Database 12c.
>
>
>
> The standalone application running on Oracle DB 12c works as the bridge
> between ERP and the shop floor machinery in a typical manufacturing plant.
> Shop floor users will work 75% of the time on the standalone application
> and they need to login into ERP system only for 25% of the time. Oracle ERP
> is the owner of all kind of data. Functionalities within the standalone
> application use live data from the ERP database and if the ERP system is
> not available then the standalone application will not work.
>
>
>
> ORACLE ERP (11g R2) ç===è STANDALONE APPLICATION (Oracle DB, 12c) ç===è
> Shop floor machinery
>
>
>
> The requirement is to design such an interface between ERP and standalone
> application which will allow the standalone application to work in
> isolation even if the ERP system is not up. I am thinking about below
> option to achieve this.
>
>
>
> Inbound Information (ERP to standalone):- Use of staging table in the
> standalone DB. This staging table will work as the source of data instead
> of directly reaching to ERP. There will be a scheduled job which will keep
> updating this staging table with the latest live data from ERP system so
> that when ERP is not available, still standalone application will be able
> to use the live data.
>
> ---> There is an assumption here that the live data is not changing
> frequently which actually matches the current business process as well.
>
>
>
> Outbound (standalone to ERP):- Use of Oracle advanced queues to push the
> shop floor transaction like sub inventory transfers or WIP completion to
> ERP. Standalone application will write the data into these queues and when
> ERP system is not available then these queues will hold the data and will
> push again whenever ERP system is up.
>
>
>
> I would really appreciate if anyone can suggest some innovative ideas or
> have suggestions for the current design.
>
>
>
> Thanks
>
> Vishalaksha
>
>
>

--
http://www.freelists.org/webpage/oracle-l