E1: 42: 43: P4312 PO Receipts Fails to Receive when Over-Receiving a Direct Ship Order Created from a Blanket Order on the Sales Side Leaving Multiple Records Locked in the SQL Server Database
(Doc ID 3068866.1)
Last updated on JANUARY 23, 2025
Applies to:
JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
P4312 fails to receive when over-receiving a direct ship order that was created from a blanket order on the sales side leaving multiple records locked in the SQL Server database. The issue does not occur when using the Oracle database.
Replication Steps:
1) UDC. Verify SB doc type exists in UDC 40/BT.
2) P4210. Enter a blanket order for using a D line type for a quantity of 50000.
3) P420111. Set processing option to call the direct ship version of P4210. Release 10000.
4) P4312. Over receive the quantity for the direct ship.
After a few seconds the following message pops up. Your current request is being processed. This page will refresh every 5 seconds until your request has finished processing. Check the call object kernel on the enterprise server and is still active. Check the SQL Server database and multiple records are locked. Review the logs and the following error is seen after a DELETE to the F42216WF by DeletePendingReleaseBlanketWF from F4211FSEndDoc and the thread the process was executing on just stops.
ODBC:S DBInitRequest(new) req=000000000C94A550,con=000000000C0D3B70,env=0000000001AE5B70,dbc=0000000001AE8A60,spid=63 phoenix145197 A (JDEUSR@phoenix145197)
DELETE FROM DATA920.PRODDTA.F42216WF WHERE ( PBKCOO = '00001' AND PBDOCO = 505.000000 AND PBDCTO = 'SB' AND PBLNID = 1000.000000 AND PBPEID = 1892.000000 AND PBTCID = 232.000000 )
SQL0000122 - Delete Failed. StringLenOut <183> is greater then StringLenIn <0>.
Entering DBPerformRequest
ODBC:S DBPerformRequest req=000000000C94A550,con=000000000C0D3B70,env=0000000001AE5B70,dbc=0000000001AE8A60,spid=63 phoenix145197 A (JDEUSR@phoenix145197)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |