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 to facilitate issue replication. It's also highly recommended to have this done before an upgrade. P2T requests are made by opening service requests.
The entire production database is cloned with the following exceptions.
- BIPublisher Reports aren't copied.
- Files such as images and email stylesheets that are stored on the file system aren't copied.
- Recurring processes are disabled with a Next Process Time set in the distant future to prevent production processes from running on test data. These might be edited as needed to run in the test system.
- All users other than Service Administrators (users with the ‘DBA.ADMIN” role) are expired to prevent inadvertent use of the test system. There's 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's 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) isn't propagated.
The following table outlines the data that's 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 |