E1: 49: Freight Update (R4981) not Using Ship to (SHAN) from F4215 to Flex DMAAI 4920 if Shipment Added and Cancelled During Unscheduled Delivery (P49655) (Doc ID 2936025.1)

Last updated on MARCH 17, 2023

Applies to:

Symptoms

When running Freight Update (R4981) over a load that contains a shipment that was cancelled in Unscheduled Deliveries (P49655), along with a shipment that was added in Unscheduled Deliveries, the flex accounting for the ship to address is not using the correct value. The flex value being used is the SHAN value from the F4215 of the cancelled shipment and not the shipment actually processed on the load.

STEPS
-----------------------

1. Setup flex accounting for the 4920 DMAAI in the P40296 for document type FT. Setup the SHAN value as the subsidiary value based on the F4215 table.
2. Verify the account that will be used on the 4920 DMAAI (EX: 30.6040)
3. Go to the P0901 and create two new accounts with the subsidiary value for two different ship to addresses (Ex: 30.6040.4242 and 30.6040.4245)
4. Create a TMS sales order using the P4210 for ship to address 4242.
5. Create a 2nd TMS sales order for ship to address 4245.
6. Using the P4960, build an in-transit load.
7. Only add the first shipment for address 4242 on the load and confirm the load is routed with payable charges.
8. Approve the load in the P4960.
9. Confirm the load using the P49640 and Ship Confirm (P4205) the quantity.
10. Go to Deliver Confirm (P49650) and take the form exit to Unscheduled Deliveries
11. In the P49655 (Unscheduled Deliveries), input the ship to address of the other sales order created for address 4245. Also, input the item, quantity, order number, order type, line number, company and branch for this sales order.
12. After clicking OK in the previous form, the user is taken back to the Deliver Confirm form (P49650). Take the row exit - cancel to cancel the original sales order on the load. The load is moved to status 80 (Complete).
13. Review the sales order information. The first sales order for ship to 4242 is cancelled and the sales order for 4245 has been assigned a new shipment number.
14. Turn on Flex Accounting on the Process tab of the R4981.
15. Run the R4981 in final mode, data selecting on the load number.
16. Review the account on the R4981. The account has the subsidiary of the ship to address of the cancelled shipment/sales order (30.6040.4242). The subsidiary value should have been the ship to of the shipment on the load (4245).

Changes

Cause

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