My Oracle Support Banner

E1: 43: Web Exception Error When Trying To Cancel Line On Purchase Order That Was Created From A Requisition (Doc ID 3029774.1)

Last updated on JUNE 18, 2024

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to cancel an old PO Line that was created from a Requisition with a G/L Date in April 2022 (more than 2 years ago), the program crashes with several consecutive messages on the screen.

"Select Application Failure Header Label"
There was a problem with the server while running the business function "GetPODetailShipmentNumber" (N4302630).

ASYNCHRONOUS BUSINESS FUNCTION ERROR
There was a problem with the server while running the business function "F4311EndDoc" (XT4311Z1).

TRANSACTION ERROR
Transaction cannot be committed. It was cancelled.

WEB CLIENT EXCEPTION
There was a problem with the server while running the business function "GetPODetailShipmentNumber" (N4302630)

Steps to Reproduce:  

Note: All references to actual client data have been removed from the steps below

  1. Find Purchase Order and Row Exit to Order Detail Revisions
    1. Order Date shows order was created in May 2019 (five years ago)
    2. Notice that Line 1.000 is at Status 400/400 partially received and the Request Date and G/L Date are in April 2022 (more than 2 years ago)
    3. Take the Cancel Line Row Exit
    4. The line is crossed out and appears to be canceled
    5. Click OK to save
  2. Instead of returning the PO Inquiry screen, the "Select Application Failure Header Label" screen appears with the following message:
    1. There was a problem with the server while running the business function "GetPODetailShipmentNumber" (N4302630)
    2. Click on the Close (X) button.
  3. Work with Order Headers screen appears with no records in the grid.
    1. ASYNCHRONOUS BUSINESS FUNCTION ERROR pop-up message appears
    2. There was a problem with the server while running the business function "F4311EndDoc" (XT4311Z1).
    3. Click OK
  4. Pop-up message appears.
    1. TRANSACTION ERROR
    2. Transaction cannot be committed. It was cancelled.
    3. Click OK again
  5. Another message appears
    1. WEB CLIENT EXCEPTION
    2. There was a problem with the server while running the business function "GetPODetailShipmentNumber" (N4302630)
  6. Review the JDEDEBUG.LOG and note the following:
    1. GetPurchaseOrderDetail (B4300110) failed with a Record Invalid (Error 0002)
    2. SQL SELECT STATEMENT failed because there is no record in the PO Detail (F4311) for Purchase Requisition.
      • SELECT * FROM ENVIRONMENT.F4311 WHERE ( PDDOCO = <Requisition Doc#>  AND PDDCTO = 'R*' AND PDKCOO = '0000X' AND PDSFXO = '000' AND PDLNID = 1000.000000 )
      • No More Data found

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


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