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
