Oracle Financials Current Configuration OverviewExternal usersField Office Lans22 servers100-baseEthernet23 Field Office SitesWillow Grove, PALivonia, MIAltamonte Springs. FLPleasanton,CAPortalnd, ORChesapeake, VARichardson, TX ArapahoRichardson, TX CentralLas Vegas, NVKent, WABurlington, NJBurnaby, BC CanadaHonolulu, HAAlexandria VAOrlando FLJamesburg NJMelville NYVirginia Beach VALaMesa CaBrea CASchaumburg ILEnglewood COGold River CACITYPLACE LAN100-baseEthernetOracle formsexecutableson Lan serverat each site7-11 Wide AreaNetwork256Kb CIR 56KbT1HP9000-K570PLSLC020T1Oracle DatabaseServer ProductionHP9000-K420PLSLC021Oracle Database Serverfor developmentLAWPACKRACOMLAB ENVIRONMENTODBCTXCORP-SVR-4Plano Support SiteUSPLDSLND001Appx 450 usersTXCORP-WTS-T1Windows Terminal Serverfor Dialup users and users on WANwho do not have a local serverSouth Windsor CTBrockton MAAppx 300usersAppx 30 usersTechnical support staffGL TEST F01GL TEST F02Master ConsoleNT ClientWin 95 client.exe and .dllfiles on eachpcFrame RelayCompaq-233,300 or 350Pentinum;64Mb; 3GHD;NT 4.0 orWin 95Compaq-233,300 or 350Pentinum;64Mb; 3G HD;NT 4.0 or Win9510-base and100-baseEthernet7-11Private LANEDS SMCPlano,TX10-baseEthernetEDSLINK 12 usersOracle formsexecutableson Lan server.exe and .dllfiles on eachpcOracle 11i Architectureplslc022- Web ServerUsers PCplslc026- Web ServerContains OFAPdatabase,ConcurrentProgramExecutablesContains OFAMdatabase,ConcurrentProgramExecutablesContains Executables forODBC (for APDI/FDS/MSAccess)/GLDI/CFODevOracle 11i Worldplslc023- Database ServerContains WebServer -Applications Formsand Discoverer thatdisplay on your PCthrough a WebBrowserplslc025 - Web Serverplslc024 - Database ServerODBC connectionsfor APDI/FDSMsAccessWeb connectionsfor Application &DiscovererLoad BalancingWeb connectionsfor Application &DiscovererODBC connectionsfor APDI/FDSMsAccessContains Web Server (2)- Applications Forms andDiscoverer that displayon your PC through aWeb BrowserTEST ENVIRONMENTPRODUCTIONENVIRONMENT7-Eleven Oracle Accounts Payable* Requires dual vendor entry.Accounts PayableORACLEBIS(BankingInformationSystem)PaymentDataConstruction,Override Rent, &Real Estate LeasePayment InvoicesAccountingDistributionsVendorsCorp APPaidVouchersNon-EDIInvoicesEquipment LeasePayment InvoicesReportsSignageAdvertising$0 Chk ReqLegal FeeInvoicesValuTech BankSelectionCheck Data forReconciliationElectronicFundsChecksCheckReconciliationInvoicesEquipmentSystemPMS(PropertyManagementSytem)SupplyInventorySystem*LawPackTravelAd ValoremTaxRetail StoresSystemUtility*SLEDS(SouthlandEnvironmentalDatabase System)*Dispatch-11099/T99SystemPBIExpense(Franchisee Draw)RepeatExpensesInvoicesInvoice/CheckrequestsInvoice/CheckrequestsNon-EDIMerchandiseInvoicesEDI InvoicesFrom CitgoInvoices7-Eleven BanksPositive Pay DataCitgo(via SPS)Payment DataAPDINavigatERInvoicesInvoicesGLPOPCCorp AP OpenVouchersOracle Accounts Payable InterfacesCorporateAccountingDistributionsCorporatePaidVouchersCorporateVendorsCorporateOpenVouchersRetailVendors(EVD)PurchasingAccountsPayableORACLEFinancial Applications EnvironmentGeneral LedgerProject CostingVendorsAccountingDistributionsEquipmentSystemEVRNST(Corp Sales Tax)PMS(Property ManagementSystem)Ad Valorem TaxSLEDS(Southland EnvironmentalDatabase System)AMEX1099/T99 SystemCheckReconciliationRentalIncomeDetail andBalance ForwardReportsRetail SystemsBIS (BankingInformation System)Legacy SystemsCFO ReportsGeneral LedgerLocation SegmentBalancing Segment (Adds)Balancing Segment Parent/ChildEmployee Numbers (SSN)Retail Daily JournalsStatistics File (Monthly)Budget File (Monthly)SEP (Monthly)Month End Account BalancesSPL (Monthly)Balancing Segment (Wrap)Journal Detail InterfaceActuals/BudgetImport/PostExecution ReportsActuals/BudgetSRC BudgetSoftwareServerFDSFile ServerDSSGLDIJournals7-Eleven Oracle General LedgerOracle General Ledger Interfaces