ER CTMS 047-078: Difference between revisions
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 12.0 |ERNumber=ER047-078 }} {| class="wikitable" border="1" width="100%" |- bgcolor="silver" !Module !! Program Name !! Ver !! Call/Iss !! Client Ref !! Pr'ty !! Remarks |- |DATA_ADM_SYSTEM_PARAM_725398.sql |Database Script |1.1 |725398 |- |2 |Version 1.6.1.1 of DP_FLEXIPOD will be released to the 19c databases. Enables UpdateManifests to create and update manifests as per Route...") |
m (Text replacement - "ER]]↵</noinclude>" to "ER]] Category:ER CTMS 047 </noinclude>") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 23: | Line 23: | ||
1 .A new system parameter called FLEXIPOD_UPDATE_MANIFESTS can be set to Y to use the 'UpdateManifests' method to create manifests as per the Route Execution API. | 1 .A new system parameter called FLEXIPOD_UPDATE_MANIFESTS can be set to Y to use the 'UpdateManifests' method to create manifests as per the Route Execution API. | ||
2. A new system called FLEXIPOD_UNALLOCATED_DRIVER can be set to Y to use 'Unallocated' for the 'DriverUserCode' for the manifest in APOD when a driver has not been set for the trip. 'Unallocated' must exist as a driver in APOD. | 2. A new system called FLEXIPOD_UNALLOCATED_DRIVER can be set to Y to use 'Unallocated' for the 'DriverUserCode' for the manifest in APOD when a driver has not been set for the trip. 'Unallocated' must exist as a driver in APOD. | ||
3. The system parameter called FLEXIPOD_TPCLIENTNUM can be set for the customer, cost centre or system levels to store the client's number. Customer is the expected level. | 3. The system parameter called FLEXIPOD_TPCLIENTNUM can be set for the customer, cost centre or system levels to store the client's number. Customer is the expected level. | ||
| Line 129: | Line 131: | ||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]] | ||
[[Category:ER CTMS 047]] | |||
</noinclude> | </noinclude> | ||
Latest revision as of 09:44, 13 June 2025
EMERGENCY RELEASE - CTMS 12.0
RELNOTE ER047-078
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DATA_ADM_SYSTEM_PARAM_725398.sql | Database Script | 1.1 | 725398 | - | 2 | Version 1.6.1.1 of DP_FLEXIPOD will be released to the 19c databases.
Enables UpdateManifests to create and update manifests as per Route Execution. Refers to system parameters: 1 .A new system parameter called FLEXIPOD_UPDATE_MANIFESTS can be set to Y to use the 'UpdateManifests' method to create manifests as per the Route Execution API. 2. A new system called FLEXIPOD_UNALLOCATED_DRIVER can be set to Y to use 'Unallocated' for the 'DriverUserCode' for the manifest in APOD when a driver has not been set for the trip. 'Unallocated' must exist as a driver in APOD. 3. The system parameter called FLEXIPOD_TPCLIENTNUM can be set for the customer, cost centre or system levels to store the client's number. Customer is the expected level. PK and DL stops which are at a RDC will be excluded from APOD. Orders which are collected and delivered on the same trip will appear as separate manifests by drop. The planned distance should default to 0, although a distance should always exist for a trip. Also allow manifests to be updated for a drop for a customer ID that does not have a contact. Also allow the address for a manifest to be updated for a drop without special instructions. Drops can be deassigned from a manifest as an order is deassigned from a stop and a stop is deleted from a trip. DELETED trips will set the expiry date of the manifest to be in the past. |
| DATA_ADM_SYSTEM_PARAM_CONFIG_725398.sql | Database Script | 1.1 | " | " | " | " |
| TRG_BOOKING_REF_FLX.sql | Database Trigger | 1.4 | " | " | " | " |
| TRG_SCH_HAULAGE_FLX.sql | Database Trigger | 1.4 | " | " | " | " |
| TRG_SCH_TRIP_DRV_FLX.sql | Database Trigger | 1.4 | " | " | " | " |
| TRG_SCH_TRIP_XML_FLX.sql | Database Trigger | 1.3 | " | " | " | " |
| DP_FLEXIPOD.sql | Flexipod Package | 1.6 | " | " | " | " |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| FLEXIPOD_UNALLOCATED_DRIVER | SYSTEM | N | A driver will not be set for the manifest in APOD when a driver has not been set for the trip. |
| FLEXIPOD_UNALLOCATED_DRIVER | SYSTEM | Y | Uses 'Unallocated' for the 'DriverUserCode' for the manifest in APOD when a driver has not been set for the trip. 'Unallocated' must exist as a driver in APOD. |
| FLEXIPOD_UPDATE_MANIFESTS | SYSTEM | N | Uses the 'Add' method to create the manifests as per the public API. |
| FLEXIPOD_UPDATE_MANIFESTS | SYSTEM | Y | Uses the 'UpdateManifests' method to create the manifests as per the Route Execution API. |
| FLEXIPOD_TPCLIENTNUM | SYSTEM | Populated | Stores the 'TPClientNum' for the system. |
| FLEXIPOD_TPCLIENTNUM | COST_CENTRE | Populated | Stores the 'TPClientNum' for the cost centre. |
| FLEXIPOD_TPCLIENTNUM | CUSTOMER | Populated | Stores the 'TPClientNum' for the customer. This is the expected level. |
