Issues With Work Invoice While Deleting Special Services From A Shipment On A Same Stop (Doc ID 1359867.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

A PAYABLE ZERO lineitem is not being created for a work invoice if a shipment has the same special service added more than once to a stop and one gets
deleted. Instead the special service is being deleted from the work invoice. This is resulting in duplication of payments. The Client expects that OTM should create a PAYABLE ZERO entry for every deleted special service from a shipment.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Setup:

Created Special Service: EXP_MEAL

Created Order: WORK_SPECIAL

Created Direct Shipment: 01520

Assigned Driver: SPECIAL_DRIVER

Added Special Service EXP_MEAL 2 times on the financial tab for stop 1 (as
Payable and Completed).
To Replicate:

1. Log into OTM 6.1.
2. Search for Shipment 01520.
3. Select and go to > Actions > fleet Management > Driver Dispatch > Generate
Driver Work Invoice.
4. Note Work Invoice SPECIAL_DRIVER-01520-01 was created.
5. Click to Edit the Work Invoice and note the following activity:

Activity Date Special Service Source Location Destination Location Payable
Indicator
2011-06-16 EXP_MEAL KDEST KDEST PAYABLE
2011-06-16 EXP_MEAL KDEST KDEST PAYABLE
2011-06-24 DEADHEAD KDEST KSOURCE PAYABLE
2011-06-24 LOAD KSOURCE KSOURCE PAYABLE
2011-07-17 UNLOAD KDEST KDEST PAYABLE
2011-07-17 TRANSPORT KSOURCE KDEST PAYABLE

The statuses are as follows:

WORK_INVOICE_SENT WORK_INVOICE_SENT_SENT
WORK_INVOICE_VALID WORK_INVOICE_VALID_VALID

6. Now Edit the shipment again and delete one of the EXPENSE_MEAL Special
Services from the shipment.

7. Click Finished on the Shipment.

8. Run the following query to fix the Work Invoice Status in Sql Backdoor:

update work_invoice_status set status_value_gid =
'SH.WORK_INVOICE_SENT_RECEIVED' where work_invoice_gid =
'SH.SPECIAL_DRIVER-01520-01' and status_type_gid = 'SH.WORK_INVOICE_SENT'
9. Select the shipment and go to > Actions > fleet Management > Driver
Dispatch > Generate Driver Work Invoice.

10. Note Work Invoice ID is SPECIAL_DRIVER-01520-02 and shows the following:

2011-06-16 EXP_MEAL KDEST KDEST PAYABLE
2011-06-24 DEADHEAD KDEST KSOURCE PAYABLE
2011-06-24 LOAD KSOURCE KSOURCE PAYABLE
2011-07-17 TRANSPORT KSOURCE KDEST PAYABLE
2011-07-17 UNLOAD KDEST KDEST PAYABLE
11. The client is expecting the following:

Expected result: the work invocie should be having a line-item with
PAYABLE_ZERO for the deleted special services
Business Impact: Since the deleted special service is missing in the work
invoice; the OIC will pay the driver twice.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.