Hubble 18.1 Hubble Suite - Configuration Form (JD
Hubble Configuration Form JD Edwards World & EnterpriseOne Version 18.1 Hubble Suite
Document Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
i
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i Copyright . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i Disclaimer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i Version History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i Customer Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i
Chapter 1 - JD Edwards Database Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Summary Overview of JD Edwards Database Access . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Primary Source Database Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Source Database Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 JD Edwards Table Locations and Data Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Data Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 User Defined Code Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Security Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Data Dictionary Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Object Librarian Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 JD Edwards Configuration Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 General Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Model Business Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Chapter 2 - Replication Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Tables Included in Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Foundation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Additional Information Required for Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 General Table Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 SQL Server Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Oracle Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 AS/400 Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Chapter 3 - Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8 Creating Hubble Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Document Information | Notices
Document Information Notices Copyright Hubble® is a brand name of the insightsoftware.com Group. insightsoftware.com is a registered trademark of insightsoftware.com Limited. Hubble is a registered trademark of insightsoftware.com International Unlimited. Other product and company names mentioned herein may be the trademarks of their respective owners. The insightsoftware.com Group is the owner or licensee of all intellectual property rights in this document, which are protected by copyright laws around the world. All such rights are reserved. The information contained in this document represents the current view of insightsoftware.com on the issues discussed as of the date of publication. This document is for informational purposes only. insightsoftware.com makes no representation, guarantee or warranty, expressed or implied, that the content of this document is accurate, complete or up to date.
Disclaimer This guide is designed to help you to use the Hubble applications effectively and efficiently. All data shown in graphics are provided as examples only. The example companies and calculations herein are fictitious. No association with any real company or organization is intended or should be inferred.
Version History Date 27th Apr 2018
Software Version
Revision 1.0
18.1
Comments Initial issue for 18.1.
Customer Support For more information regarding our products, please contact us at http://gohubble.com/. For product support including Training, Documentation and Customer Support, visit our Hubble Community at https://community.gohubble.com/.
Page i
Chapter 1: JD Edwards Database Access Summary Overview of JD Edwards Database Access The Hubble Accelerator requires access to the following JD Edwards Tables for the purposes of mirroring the data: 1. The Data Tables within JD Edwards – JD Edwards reporting information is stored in this table. 2. The Security Tables within JD Edwards – JD Edwards user and role information is stored in this table. 3. The Data Dictionary Table within JD Edwards – Data Dictionary information is used to capture data characteristics for display purposes. 4. The UDC tables within JD Edwards – JD Edwards UDC information is stored in this table. 5. Object Librarian Table - JD Edwards Object library information is stored in this table.
Primary Source Database Information Source Database Information The following information will be used as part of the mirroring configuration process. What is the database vendor, e.g. Oracle, AS/400 DB2, SQL Server?
Which version of the database are you running, e.g. SQL Server 2008, Oracle 10g? If AS/400 DB2, which version of the operating system is running, e.g. V5R4?
If DB2, what is the system name?
JD Edwards Table Locations and Data Access If you are an existing Hubble customer, you can export your current production profile from the Administrator Application and send it to us so that we can use that information in the profile to retrieve the JD Edwards Table Location and JD Edwards configuration information. If you are a new Hubble customer, please complete the below information.
Page 1
JD Edwards Database Access | JD Edwards Table Locations and Data Access
Data Tables Location What is the name of the location (database/library/schema) to the JD Edwards Data Tables, e.g. F0901? (Standard Location example is PRODDTA.)
General Information What is the database account User ID that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
User Defined Code Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards User Defined Code Tables, e.g. F0005? (Standard Location example is PRODCTL.)
General Information What is the database account User ID that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Control Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
Page 2
JD Edwards Database Access | JD Edwards Table Locations and Data Access
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Security Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Security Tables, e.g. F0092? (Standard Location example is JDESY.)
General Information What is the database account user name that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Security Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Data Dictionary Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Data Dictionary Tables, e.g. F9201 for World or F9210 Enterprise One? (Standard Location example is JDEDD.)
Page 3
JD Edwards Database Access | JD Edwards Table Locations and Data Access
General Information What is the database account user name that is used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Dictionary Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Object Librarian Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Object Librarian Tables, e.g. F9801 for World or F9860 for Enterprise One? (Standard Location example is OL9.)
General Information What is the database account user name that is used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Dictionary Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Page 4
JD Edwards Database Access | JD Edwards Configuration Questions
JD Edwards Configuration Questions General Information Are you a World, EnterpriseOne (OneWorld) or a co-existence site?
Which version of JD Edwards are you running, e.g. A73, A92, B733, E1 8.10, E1 9.0, etc.?
What is the name of the JD Edwards environment you wish to connect to, e.g. PD733, PROD810?
If you use the SOP module, do you use Customer Line of Business Support?
Model Business Units What are the model business units used for GL?
Page 5
Chapter 2: Replication Information Tables Included in Replication Foundation Below is a list of the tables that we use as a starting point for replication. Table
Description
F0004
User Defined Code Types
F0004D*
User Defined Code Types - Alternate Language
F0005
User Defined Codes
F0005D*
User Defined Code Types - Alternate Language
F0006
Business Unit Master
F0006D*
User Defined Code Types - Alternate Language
F0008
Date Conversion
F0009
General Constants
F00090
Supplemental Database Setup
F00091
Supplemental Database Data Types
F00092
Supplemental Data
F0010
Company Constants
F0011
Batch Control Records
F0012
AAI Master
F0013
Currency Codes
F0014
Payment Terms
F0025
Ledger Currency Overwrite
F0030
Bank Transmit Number Master File
F0050
Organization Structure Master
F0092
Library Lists - User
F00921*
User Display Preferences
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number Page 2
Replication Information | Tables Included in Replication
Table
Description
F01151
Address Book - Electronic Address
F0116
Address by Date
F01161
Address by Date
F0150
Address Organization Structure
F03012
Customer Master - Line Of Business
F0401
Supplier Master
F06904
Payroll AAIs
F0901
Account Master
F0902
Account Balances
F0902Z1
Account Balances Batch File
F0907
Structured Subledger
F0909
Chart of Accounts - Reference File
F0911
Account Ledger
F0911Z1
Journal Entry Transactions - Batch File
F1201
Asset Master
F1501
Tenant/Lease Master
F15017
Lease Master Detail
F1501B
Tenant/Lease Master
F1507
Unit Master File
F1720
Contract Header
F1755
Customer Calls
F4008
Tax Area
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
F4105
Item Cost
F4106
Item Price
F4108
Inventory Lot Master
F4201
Sales Header File
F4301
Purchase Order Header
F4801
Work Order Master
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F9210
Data Dictionary
F95921
Role Relationships
F95922
Permission List Relationships
F9860
Object Library
* These tables are only needed if you will be using localization. Page 3
Replication Information | Tables Included in Replication
Sales Below is a list of the tables that we use as a starting point for replication. Table
Description
F0004
User Defined Code Types
F0005
User Defined Codes
F0006
Business Unit Master
F0008
Date Conversion
F0009
General Constants
F0010
Company Constants
F0012
AAI Master
F0013
Currency Codes
F0025
Ledger Currency Overwrite
F0092
Library Lists - User
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F03012
Customer Master - Line Of Business
F0901
Account Master
F0907
Structured Subledger
F0911
Account Ledger
F0911Z1
Journal Entry Transactions - Batch File
F1201
Asset Master
F1720
Contract Header
F1755
Customer Calls
F4006
Order Address Information
F4008
Tax Area
F40205
Line Type
F4074
Price Adjustment Ledger
F41001
Inventory Constants
F41002
Item Units of Measure Conversion Factors
F41003
Unit of Measure Standard Conversion
F4101
Item Master Page 4
Replication Information | Additional Information Required for Replication
Table
Description
F4102
Item Branch
F4104
Item Cross Reference
F4108
Inventory Lot Master
F42005
Sales Commission
F4201
Sales Header File
F42019
Sales Order Header History
F4209
Held Orders
F4211
Sales Order Detail
F42119
Sales Order History
F4211Z1
Sales Order Detail Unedited Transaction File
F42140
Customer Master Commission Information
F42199
Sales Order Detail Ledger
F4229
Sales Summary History File
F4600
Warehouse Request
F4801
Work Order Master
F49211
Sales Order Detail
F49219
Sales Order Detail - Tag History
F4941
Shipment Routing Steps
F4942
Shipment Detail
F4945
Shipment Charges
F4981
Freight Audit History
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F95921
Role Relationships
F95922
Permission List Relationships
Additional Information Required for Replication General Table Information Are there specific tables updated at a certain time of day?
Are there any record level filters? If yes, are the filter columns changeable?
Do all tables have a primary key? If not, do tables without primary keys have a unique index?
Page 5
Replication Information | Additional Information Required for Replication
SQL Server Only Do you use AlwaysOn Availability Groups?
Is the database a full recovery model? If yes, you must do a full database backup before replication can be done. MS Replication must be enabled on the source database as well.
Oracle Only What is the retention period for your Archived Redo Logs?
Do you use RAC? If yes, are the Redo Logs on Shared Device?
Do you use ASM? If yes, answer the below 4 questions.
What is the name and IP address of the ASM Server?
What is the Port Number?
What is the Service Name (SID Name)?
What is the user name for the ASM User?
Do you have compressed tables?
Do you have encrypted tables?
If Oracle 12c, is the environment multitenant or configured as a non-CDB database?
If mirroring from a standby database, the CDC process can only read from a physical standby configuration and not a logical standby database.
Page 6
Replication Information | Additional Information Required for Replication
AS/400 Only What system CCSID are you using (“DSPSYSVAL QCCSID”)?
What is the CCSID configuration on the tables?
Are the tables already being journaled?
What journal configuration is defined?
We require before and after journal images (*BOTH). Confirm this is being done.
Are journal entries to be omitted?
For all tables being replicated, indicate the library, journal, and journal library: Table
Description
F0004
User Defined Code Types
F0004D*
User Defined Code Types - Alternate Language
F0005
User Defined Codes
F0005D*
User Defined Code Types - Alternate Language
F0006
Business Unit Master
F0006D*
User Defined Code Types - Alternate Language
F0008
Date Conversion
F0009
General Constants
F00090
Supplemental Database Setup
F00091
Supplemental Database Data Types
F00092
Supplemental Data
F0010
Company Constants
F0011
Batch Control Records
F0012
AAI Master
F0013
Currency Codes
F0014
Payment Terms
F0025
Ledger Currency Overwrite
F0030
Bank Transmit Number Master File
Library
Page 7
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F0050
Organization Structure Master
F0092
Library Lists - User
F00921*
User Display Preferences
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F01161
Address by Date
F0150
Address Organization Structure
F03012
Customer Master - Line Of Business
F0401
Supplier Master
F06904
Payroll AAIs
F0901
Account Master
F0902
Account Balances
F0907
Structured Subledger
F0909
Chart of Accounts - Reference File
F0911
Account Ledger
F1201
Asset Master
F1501
Tenant/Lease Master
F15017
Lease Master Detail
F1501B
Tenant/Lease Master
F1507
Unit Master File
F1720
Contract Header
F1755
Customer Calls
F4008
Tax Area
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
F4105
Item Cost
F4106
Item Price
F4108
Inventory Lot Master
F4201
Sales Header File
Library
Page 8
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F4210
Data Dictionary
F4301
Purchase Order Header
F4801
Work Order Master
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F9210
Data Dictionary
F95921
Role Relationships
F95922
Permission List Relationships
F9860
Object Library
Library
* These tables are only needed if you will be using localization.
Page 9
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Sales Table
Description
F0004
User Defined Code Types
F0005
User Defined Codes
F0006
Business Unit Master
F0008
Date Conversion
F0009
General Constants
F0010
Company Constants
F0012
AAI Master
F0013
Currency Codes
F0025
Ledger Currency Overwrite
F0092
Library Lists - User
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F03012
Customer Master - Line Of Business
F0901
Account Master
F0907
Structured Subledger
F0911
Account Ledger
F1201
Asset Master
F1720
Contract Header
F1755
Customer Calls
F4006
Order Address Information
F4008
Tax Area
F40205
Line Type
F4074
Price Adjustment Ledger
F41001
Inventory Constants
F41002
Item Units of Measure Conversion Factors
F41003
Unit of Measure Standard Conversion
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
Library
Page 10
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F4108
Inventory Lot Master
F42005
Sales Commission
F4201
Sales Header File
F42019
Sales Order Header History
F4209
Held Orders
F4211
Sales Order Detail
F42119
Sales Order History
F42140
Customer Master Commission Information
F42199
Sales Order Detail Ledger
F4229
Sales Summary History File
F4600
Warehouse Request
F4801
Work Order Master
F49211
Sales Order Detail
F49219
Sales Order Detail - Tag History
F4941
Shipment Routing Steps
F4942
Shipment Detail
F4945
Shipment Charges
F4981
Freight Audit History
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F95921
Role Relationships
F95922
Permission List Relationships
Library
Page 11
Journal
Journal Library
Chapter 3: Users Creating Hubble Users Users must be created for logging into both the Hubble Designer Application and the Hubble end user application accessed on a web browser. Please identify the users that will need to be configured and which applications they will be using. Be sure to incorporate any future users that make sense in your business (for example including the CFO because this person will be using approvals eventually). Hubble does generate emails so you may want to use artificial email address for non-participants. User Name
ERP User Name
Email Address
Page 8
Indicate whether a Designer User or Power/Explorer User
Document Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
i
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i Copyright . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i Disclaimer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i Version History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i Customer Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i
Chapter 1 - JD Edwards Database Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Summary Overview of JD Edwards Database Access . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Primary Source Database Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Source Database Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 JD Edwards Table Locations and Data Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Data Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 User Defined Code Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Security Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Data Dictionary Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Object Librarian Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 JD Edwards Configuration Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 General Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Model Business Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Chapter 2 - Replication Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Tables Included in Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Foundation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Additional Information Required for Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 General Table Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 SQL Server Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Oracle Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 AS/400 Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Chapter 3 - Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8 Creating Hubble Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Document Information | Notices
Document Information Notices Copyright Hubble® is a brand name of the insightsoftware.com Group. insightsoftware.com is a registered trademark of insightsoftware.com Limited. Hubble is a registered trademark of insightsoftware.com International Unlimited. Other product and company names mentioned herein may be the trademarks of their respective owners. The insightsoftware.com Group is the owner or licensee of all intellectual property rights in this document, which are protected by copyright laws around the world. All such rights are reserved. The information contained in this document represents the current view of insightsoftware.com on the issues discussed as of the date of publication. This document is for informational purposes only. insightsoftware.com makes no representation, guarantee or warranty, expressed or implied, that the content of this document is accurate, complete or up to date.
Disclaimer This guide is designed to help you to use the Hubble applications effectively and efficiently. All data shown in graphics are provided as examples only. The example companies and calculations herein are fictitious. No association with any real company or organization is intended or should be inferred.
Version History Date 27th Apr 2018
Software Version
Revision 1.0
18.1
Comments Initial issue for 18.1.
Customer Support For more information regarding our products, please contact us at http://gohubble.com/. For product support including Training, Documentation and Customer Support, visit our Hubble Community at https://community.gohubble.com/.
Page i
Chapter 1: JD Edwards Database Access Summary Overview of JD Edwards Database Access The Hubble Accelerator requires access to the following JD Edwards Tables for the purposes of mirroring the data: 1. The Data Tables within JD Edwards – JD Edwards reporting information is stored in this table. 2. The Security Tables within JD Edwards – JD Edwards user and role information is stored in this table. 3. The Data Dictionary Table within JD Edwards – Data Dictionary information is used to capture data characteristics for display purposes. 4. The UDC tables within JD Edwards – JD Edwards UDC information is stored in this table. 5. Object Librarian Table - JD Edwards Object library information is stored in this table.
Primary Source Database Information Source Database Information The following information will be used as part of the mirroring configuration process. What is the database vendor, e.g. Oracle, AS/400 DB2, SQL Server?
Which version of the database are you running, e.g. SQL Server 2008, Oracle 10g? If AS/400 DB2, which version of the operating system is running, e.g. V5R4?
If DB2, what is the system name?
JD Edwards Table Locations and Data Access If you are an existing Hubble customer, you can export your current production profile from the Administrator Application and send it to us so that we can use that information in the profile to retrieve the JD Edwards Table Location and JD Edwards configuration information. If you are a new Hubble customer, please complete the below information.
Page 1
JD Edwards Database Access | JD Edwards Table Locations and Data Access
Data Tables Location What is the name of the location (database/library/schema) to the JD Edwards Data Tables, e.g. F0901? (Standard Location example is PRODDTA.)
General Information What is the database account User ID that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
User Defined Code Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards User Defined Code Tables, e.g. F0005? (Standard Location example is PRODCTL.)
General Information What is the database account User ID that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Control Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
Page 2
JD Edwards Database Access | JD Edwards Table Locations and Data Access
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Security Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Security Tables, e.g. F0092? (Standard Location example is JDESY.)
General Information What is the database account user name that will be used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Security Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Data Dictionary Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Data Dictionary Tables, e.g. F9201 for World or F9210 Enterprise One? (Standard Location example is JDEDD.)
Page 3
JD Edwards Database Access | JD Edwards Table Locations and Data Access
General Information What is the database account user name that is used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Dictionary Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Object Librarian Tables SKIP SECTION if same as JD Edwards Data Tables above.
Location What is the name of the location (database/library/schema) to the JD Edwards Object Librarian Tables, e.g. F9801 for World or F9860 for Enterprise One? (Standard Location example is OL9.)
General Information What is the database account user name that is used to access the data?
What is the name and IP Address of the server that hosts the JD Edwards Data Dictionary Tables?
If the database is SQL Server, what is the Instance Port Number used to connect?
If the database is Oracle, what is the Port Number used to connect?
If the database is Oracle, what is the Service Name (SID Name)?
Page 4
JD Edwards Database Access | JD Edwards Configuration Questions
JD Edwards Configuration Questions General Information Are you a World, EnterpriseOne (OneWorld) or a co-existence site?
Which version of JD Edwards are you running, e.g. A73, A92, B733, E1 8.10, E1 9.0, etc.?
What is the name of the JD Edwards environment you wish to connect to, e.g. PD733, PROD810?
If you use the SOP module, do you use Customer Line of Business Support?
Model Business Units What are the model business units used for GL?
Page 5
Chapter 2: Replication Information Tables Included in Replication Foundation Below is a list of the tables that we use as a starting point for replication. Table
Description
F0004
User Defined Code Types
F0004D*
User Defined Code Types - Alternate Language
F0005
User Defined Codes
F0005D*
User Defined Code Types - Alternate Language
F0006
Business Unit Master
F0006D*
User Defined Code Types - Alternate Language
F0008
Date Conversion
F0009
General Constants
F00090
Supplemental Database Setup
F00091
Supplemental Database Data Types
F00092
Supplemental Data
F0010
Company Constants
F0011
Batch Control Records
F0012
AAI Master
F0013
Currency Codes
F0014
Payment Terms
F0025
Ledger Currency Overwrite
F0030
Bank Transmit Number Master File
F0050
Organization Structure Master
F0092
Library Lists - User
F00921*
User Display Preferences
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number Page 2
Replication Information | Tables Included in Replication
Table
Description
F01151
Address Book - Electronic Address
F0116
Address by Date
F01161
Address by Date
F0150
Address Organization Structure
F03012
Customer Master - Line Of Business
F0401
Supplier Master
F06904
Payroll AAIs
F0901
Account Master
F0902
Account Balances
F0902Z1
Account Balances Batch File
F0907
Structured Subledger
F0909
Chart of Accounts - Reference File
F0911
Account Ledger
F0911Z1
Journal Entry Transactions - Batch File
F1201
Asset Master
F1501
Tenant/Lease Master
F15017
Lease Master Detail
F1501B
Tenant/Lease Master
F1507
Unit Master File
F1720
Contract Header
F1755
Customer Calls
F4008
Tax Area
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
F4105
Item Cost
F4106
Item Price
F4108
Inventory Lot Master
F4201
Sales Header File
F4301
Purchase Order Header
F4801
Work Order Master
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F9210
Data Dictionary
F95921
Role Relationships
F95922
Permission List Relationships
F9860
Object Library
* These tables are only needed if you will be using localization. Page 3
Replication Information | Tables Included in Replication
Sales Below is a list of the tables that we use as a starting point for replication. Table
Description
F0004
User Defined Code Types
F0005
User Defined Codes
F0006
Business Unit Master
F0008
Date Conversion
F0009
General Constants
F0010
Company Constants
F0012
AAI Master
F0013
Currency Codes
F0025
Ledger Currency Overwrite
F0092
Library Lists - User
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F03012
Customer Master - Line Of Business
F0901
Account Master
F0907
Structured Subledger
F0911
Account Ledger
F0911Z1
Journal Entry Transactions - Batch File
F1201
Asset Master
F1720
Contract Header
F1755
Customer Calls
F4006
Order Address Information
F4008
Tax Area
F40205
Line Type
F4074
Price Adjustment Ledger
F41001
Inventory Constants
F41002
Item Units of Measure Conversion Factors
F41003
Unit of Measure Standard Conversion
F4101
Item Master Page 4
Replication Information | Additional Information Required for Replication
Table
Description
F4102
Item Branch
F4104
Item Cross Reference
F4108
Inventory Lot Master
F42005
Sales Commission
F4201
Sales Header File
F42019
Sales Order Header History
F4209
Held Orders
F4211
Sales Order Detail
F42119
Sales Order History
F4211Z1
Sales Order Detail Unedited Transaction File
F42140
Customer Master Commission Information
F42199
Sales Order Detail Ledger
F4229
Sales Summary History File
F4600
Warehouse Request
F4801
Work Order Master
F49211
Sales Order Detail
F49219
Sales Order Detail - Tag History
F4941
Shipment Routing Steps
F4942
Shipment Detail
F4945
Shipment Charges
F4981
Freight Audit History
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F95921
Role Relationships
F95922
Permission List Relationships
Additional Information Required for Replication General Table Information Are there specific tables updated at a certain time of day?
Are there any record level filters? If yes, are the filter columns changeable?
Do all tables have a primary key? If not, do tables without primary keys have a unique index?
Page 5
Replication Information | Additional Information Required for Replication
SQL Server Only Do you use AlwaysOn Availability Groups?
Is the database a full recovery model? If yes, you must do a full database backup before replication can be done. MS Replication must be enabled on the source database as well.
Oracle Only What is the retention period for your Archived Redo Logs?
Do you use RAC? If yes, are the Redo Logs on Shared Device?
Do you use ASM? If yes, answer the below 4 questions.
What is the name and IP address of the ASM Server?
What is the Port Number?
What is the Service Name (SID Name)?
What is the user name for the ASM User?
Do you have compressed tables?
Do you have encrypted tables?
If Oracle 12c, is the environment multitenant or configured as a non-CDB database?
If mirroring from a standby database, the CDC process can only read from a physical standby configuration and not a logical standby database.
Page 6
Replication Information | Additional Information Required for Replication
AS/400 Only What system CCSID are you using (“DSPSYSVAL QCCSID”)?
What is the CCSID configuration on the tables?
Are the tables already being journaled?
What journal configuration is defined?
We require before and after journal images (*BOTH). Confirm this is being done.
Are journal entries to be omitted?
For all tables being replicated, indicate the library, journal, and journal library: Table
Description
F0004
User Defined Code Types
F0004D*
User Defined Code Types - Alternate Language
F0005
User Defined Codes
F0005D*
User Defined Code Types - Alternate Language
F0006
Business Unit Master
F0006D*
User Defined Code Types - Alternate Language
F0008
Date Conversion
F0009
General Constants
F00090
Supplemental Database Setup
F00091
Supplemental Database Data Types
F00092
Supplemental Data
F0010
Company Constants
F0011
Batch Control Records
F0012
AAI Master
F0013
Currency Codes
F0014
Payment Terms
F0025
Ledger Currency Overwrite
F0030
Bank Transmit Number Master File
Library
Page 7
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F0050
Organization Structure Master
F0092
Library Lists - User
F00921*
User Display Preferences
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F01161
Address by Date
F0150
Address Organization Structure
F03012
Customer Master - Line Of Business
F0401
Supplier Master
F06904
Payroll AAIs
F0901
Account Master
F0902
Account Balances
F0907
Structured Subledger
F0909
Chart of Accounts - Reference File
F0911
Account Ledger
F1201
Asset Master
F1501
Tenant/Lease Master
F15017
Lease Master Detail
F1501B
Tenant/Lease Master
F1507
Unit Master File
F1720
Contract Header
F1755
Customer Calls
F4008
Tax Area
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
F4105
Item Cost
F4106
Item Price
F4108
Inventory Lot Master
F4201
Sales Header File
Library
Page 8
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F4210
Data Dictionary
F4301
Purchase Order Header
F4801
Work Order Master
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F9210
Data Dictionary
F95921
Role Relationships
F95922
Permission List Relationships
F9860
Object Library
Library
* These tables are only needed if you will be using localization.
Page 9
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Sales Table
Description
F0004
User Defined Code Types
F0005
User Defined Codes
F0006
Business Unit Master
F0008
Date Conversion
F0009
General Constants
F0010
Company Constants
F0012
AAI Master
F0013
Currency Codes
F0025
Ledger Currency Overwrite
F0092
Library Lists - User
F00926
Role Sequences
F0093
Library List Control
F00950
Security Workbench
F0101
Address Book Master
F0111
Address Book Who's Who
F01112
Related Person
F01138
AB Data Permission List
F0115
Address Book - Contact Tel Number
F01151
Address Book - Electronic Address
F0116
Address by Date
F03012
Customer Master - Line Of Business
F0901
Account Master
F0907
Structured Subledger
F0911
Account Ledger
F1201
Asset Master
F1720
Contract Header
F1755
Customer Calls
F4006
Order Address Information
F4008
Tax Area
F40205
Line Type
F4074
Price Adjustment Ledger
F41001
Inventory Constants
F41002
Item Units of Measure Conversion Factors
F41003
Unit of Measure Standard Conversion
F4101
Item Master
F4102
Item Branch
F4104
Item Cross Reference
Library
Page 10
Journal
Journal Library
Replication Information | Additional Information Required for Replication
Table
Description
F4108
Inventory Lot Master
F42005
Sales Commission
F4201
Sales Header File
F42019
Sales Order Header History
F4209
Held Orders
F4211
Sales Order Detail
F42119
Sales Order History
F42140
Customer Master Commission Information
F42199
Sales Order Detail Ledger
F4229
Sales Summary History File
F4600
Warehouse Request
F4801
Work Order Master
F49211
Sales Order Detail
F49219
Sales Order Detail - Tag History
F4941
Shipment Routing Steps
F4942
Shipment Detail
F4945
Shipment Charges
F4981
Freight Audit History
F5201
Contract Headers
F9203
Data Item Alpha Descriptions
F95921
Role Relationships
F95922
Permission List Relationships
Library
Page 11
Journal
Journal Library
Chapter 3: Users Creating Hubble Users Users must be created for logging into both the Hubble Designer Application and the Hubble end user application accessed on a web browser. Please identify the users that will need to be configured and which applications they will be using. Be sure to incorporate any future users that make sense in your business (for example including the CFO because this person will be using approvals eventually). Hubble does generate emails so you may want to use artificial email address for non-participants. User Name
ERP User Name
Email Address
Page 8
Indicate whether a Designer User or Power/Explorer User
