E1: 47: EDI Advanced Ship Notice Extraction (R47032) Returns Blank PDF with Open Cursor for Cache Error with Incorrect Hierarchical Configuration (P47HL) (Doc ID 2572205.1)

Last updated on NOVEMBER 14, 2022

Applies to:

Symptoms

EDI Advanced Ship Notice Extraction (R47032)

After running EDI Advanced Ship Notice Extraction (R47032), the ASN is not processed, the PDF report is Blank and the EDI Tables (F47036 and F470371) are NOT updated.

Specific error messages
JDEDEBUG.LOG shows the following error

Open Cursor for cache failed (078M) was issued by CacheProcessASNShipmentNumber (b4900194.c) on line 1715 of the code

CAUSE . . . . A cursor was not able to be opened because the Cache Init was not successful or cache was empty.
RESOLUTION. . Verify that the Cache Init was successful and that records exist in your cache prior to the Open Cursor. Check the JDE.LOG and JDEDEBUG.LOG for additional information.

Steps to Duplicate

1. Setup a Customer Master for ASN Processing. On the Customer Ship Notice Tab, enter "O I" as the Pick Pack Config and select the Pick Pack radio button as the Default Configuration.
2. Create Hierarchical Configuration for the Customer
   1. Entered Customer Address
   2. Leave Hierarchical Configuration Blank
   3. Enter Hierarchical Structure Code was as O I
3. Create a Sales Order for the customer
4. Ship Confirm the Sales Order
5. Run EDI Advanced Ship Notice Extraction (R47032) with data selection on the order and with Debug logs activated.
6. System Returns a Blank PDF.
7. Debug logs show Open Cursor for cache failed (078M) was issued by CacheProcessASNShipmentNumber (b4900194.c) on line 1715 of the code.

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.