My Oracle Support Banner

E1: 49: Delivery Confirm (P49650) for Inbound In-Transit Load Does Not Clear In-Transit Quantity in F4963/F49631 - In-Transit Tables (Doc ID 2874651.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

JD Edwards EnterpriseOne Transportation Management - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.

Symptoms

When processing compartmentalized In-transit loads for inbound shipments based on purchase orders for bulk products then at Load Confirm (P49640) the item is received into stock and records are created in F4963 - Load In-transit and F49631 - In-Transit Ledger.
However when confirming the delivery (P49650) it is not updating the In-Transit quantity/volume in the In-transit tables. The F4963 record still exists, still showing the Quantity on Board (QTYL) and the F49631 In-transit ledger record has a record for Record type 30-Delivered Quantity however the Actual Quantity (ACLQ) is blank.
In addition there are errors Blanks Invalid - 0003 and Open Cursor or cache CF43092Z failed - 078M during Delivery Confirm. The error appears to be caused because NXT43092 - F43092EditLine is called and is looking for receipt routing records in F43092 even though no Receipt routing was activated.



Steps to Duplicate:
1) P4310 Enter Transportation purchase order for Bulk Item
2) P4960 Build Compartmentalized In-Transit load and Approve Load
3) P49640 Confirm Load
4) Note there are multiple/duplicate records created in the F4963 - Load In-transit, one with the load number populated (created by P49640) and one with a blank load number (created by P4205)
5) There are also multiple/duplicate records created in the F49631 - In-Transit Ledger, one with the load number populated (created by P49640) and one with a blank load number (created by P4205)
6) P49650 - Confirm Delivery - Confirm as Scheduled
7) Receive errors Blanks Invalid - 0003 and Open Cursor or cache CF43092Z failed - 078M
8) Click through the errors and Load Delivered (status 70)
9) Note that F4963 still has a record that shows Quantity on Board (QTYL) and F49631 has blank Actual Quantity (ACLQ) for the Record type 30 - Delivered




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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