Oracle Financial Applications

1、oracle financials current configuration overview external users field office lans 22 servers 100-base ethernet 23 field office sites willow grove, pa livonia, mi altamonte springs. fl pleasanton,ca portalnd, or chesapeake, va richardson, tx arapaho richardson, tx central las vegas, nv kent, wa burli

2、ngton, nj burnaby, bc canada honolulu, ha alexandria va orlando fl jamesburg nj melville ny virginia beach va lamesa ca brea ca schaumburg il englewood co gold river ca cityplace lan 100-base ethernet oracle forms executables on lan server at each site 7-11 wide area network 256kb cir 56kb t1 hp9000

3、-k570 plslc020 t1 oracle database server production hp9000-k420 plslc021 oracle database server for development lawpack racom lab environment odbc txcorp-svr-4 plano support site uspldslnd001 appx 450 users txcorp-wts-t1 windows terminal server for dialup users and users on wan who do not have a loc

4、al server south windsor ct brockton ma appx 300 users appx 30 users technical support staff gl test f01gl test f02 master consolent client win 95 client .exe and .dll files on each pc frame relay compaq-233, 300 or 350 pentinum; 64mb; 3g hd;nt 4.0 or win 95 compaq-233, 300 or 350 pentinum; 64mb; 3g

5、hd; nt 4.0 or win 95 10-base and 100-base ethernet 7-11 private lan eds smc plano,tx 10-base ethernet edslink 12 users oracle forms executables on lan server .exe and .dll files on each pc oracle 11i architecture plslc022- web server users pc plslc026- web server contains ofap database, concurrent p

6、rogram executables contains ofam database, concurrent program executables contains executables for odbc (for apdi/fds/ msaccess)/gldi/cfo dev oracle 11i world plslc023- database server contains web server - applications forms and discoverer that display on your pc through a web browser plslc025 - we

7、b server plslc024 - database server odbc connections for apdi/fds msaccess web connections for application & discoverer load balancing web connections for application & discoverer odbc connections for apdi/fds msaccess contains web server (2) - applications forms and discoverer that display on your

8、pc through a web browsertest environment production environment 7-eleven oracle accounts payable * requires dual vendor entry. accounts payable oracle bis (banking information system) payment data construction, override rent, & real estate lease payment invoices accounting distributions vendors corp

9、 ap paid vouchers non-edi invoices equipment lease payment invoices reports signage advertising $0 chk req legal fee invoices valutech bank selection check data for reconciliation electronic funds checks check reconciliation invoices equipment system pms (property management sytem) supply inventory

10、system *lawpack travel ad valorem tax retail stores system utility *sleds (southland environmental database system) *dispatch-1 1099/t99 system pbi expense (franchisee draw) repeat expenses invoices invoice/check requests invoice/check requests non-edi merchandise invoices edi invoices from citgo in

11、voices 7-eleven banks positive pay data citgo (via sps) payment data apdi navigater invoicesinvoices glpo pc corp ap open vouchers oracle accounts payable interfaces corporate accounting distributions corporate paid vouchers corporate vendors corporate open vouchers retail vendors (evd) purchasing a

12、ccounts payable oracle financial applications environment general ledger project costing vendors accounting distributions equipment system evr nst (corp sales tax) pms (property management system) ad valorem tax sleds (southland environmental database system) amex 1099/t99 system check reconciliatio

13、n rental income detail and balance forward reports retail systems bis (banking information system) legacy systems cfo reports general ledger location segment balancing segment (adds) balancing segment parent/child employee numbers (ssn) retail daily journals statistics file (monthly) budget file (mo

14、nthly) sep (monthly) month end account balances spl (monthly) balancing segment (wrap) journal detail interface actuals/budget import/post execution reports actuals/budget src budget software server fds file server dss gldi journals 7-eleven oracle general ledger oracle general ledger interfaces statistics