Production to Test Cloning (P2T)
Oracle Transportation and Global Trade Management service supports the ability to have the production database instance cloned to your test instances. This is often a good idea to have done shortly after go-live in order to facilitate issue replication. It is also highly recommended to have this done prior to an upgrade. P2T requests are made by opening service requests.
The entire production database is cloned with the following exceptions.
- Recurring processes are disabled with a Next Process Time set in the distant future to prevent production processes from running on test data. These may be edited as needed to run in the test system.
- All users other than Service Administrators (users with the ‘DBA.ADMIN” role) are expired in order to prevent inadvertent use of the test system. There is a “Manage User Expiration Date” action available on the User Manager, which can be used to un-expire a group of users.
- The Transportation and Global Trade Management password for Service Administrators is retained from production. Note: This password would only be used if the DBA.ADMIN user was used for Integration processing, which is highly discouraged. Regardless, it is highly recommended to change this password immediately following a P2T.
- The web services are unlinked from the External System record. Edit the corresponding External Systems and relink them to the test web service after the P2T is complete.
- Environment Specific data and data potentially containing Personally Identifiable Information (PII) is not propagated. The following table outlines the data that is not propagated.
| Table Name | Column Name |
|---|---|
| ADHOC_NOTIFY | COM_ADDRESS |
| APP_MACHINE | MACHINE_URL |
| CONTACT | CELL_PHONE |
| CONTACT | EMAIL_ADDRESS |
| CONTACT | FAX |
| CONTACT | PHONE1 |
| CONTACT | PHONE2 |
| CONTACT_POINT | COM_ADDRESS |
| CUSTOMER_TAX_INFO | All Columns |
| DOMAIN_SETTING_TAX_INFO | All Columns |
| DRIVER | DATE_OF_BIRTH |
| DRIVER_CDL | All Columns |
| EXTERNAL_SYSTEM | HOSTNAME |
| EXTERNAL_SYSTEM | URL |
| EXTERNAL_SYSTEM | IP_ADDRESS |
| EXTERNAL_SYSTEM_SERVICE | All Columns |
| I_MESSAGE | CELL_PHONE |
| NOTIFY_REQUEST | COM_ADDRESS |
| ORDER_RELEASE | EM_PHONE_NUMBER |
| PROBLEM | PROBLEM_URL |
| PROCESS_CONTROL_REQUEST | NEXT_PROCESS_TIME, for all public entries |
| REPORT_EMAIL | EMAIL_ADDRESS |
| SHIPMENT | EM_PHONE_NUMBER |
| X_UN_LOC_CODE | EMAIL_ADDRESS |