E1: 41: Inventory Adjustment (P4114) Fails if Unicode Character (Long Hyphen) is Copied from Outlook to Explanation field During Entry (Doc ID 3069269.1)

Last updated on JANUARY 28, 2025

Applies to:

Symptoms

When Copying and Pasting a text description with a Unicode only Character (Long Hyphen) from a Microsoft Outlook email, into the Explanation field of an Inventory Adjustment (P4114) the transaction appears to succeed but after the transaction is completed there is no entries written in the Item Ledger (F4111) or General Ledger (F0911), but the Item Balance (F41021) table shows the On-Hand Quantity was updated.

The JDEDEBUG.LOG shows the following Errors in the INSERT INTO PRODDTA/F0911 statement from the IBM Non-Unicode Database:

Steps to Reproduce:

1. Text comes to the user in a Microsoft Outlook email in HTML format that contains a long hyphen which is a Unicode character and cannot be read by a Non-Unicode database
2. Before performing an Inventory Adjustment (P4114) the user checks Item Availability Inquiry (P41202)
   1. The Quantity On-Hand is noted.
3. The user performs an Inventory Adjustment (P4114) transaction with debug logs activated.
   1. The user copies the text the from the email that contains a long hyphen which is a Unicode character
   2. The user pastes in the Text containing the long hyphen (Unicode) character into the Explanation field in the header.
   3. The transaction quantity is entered as -2 for a specific location and lot.
   4. The user is able to save the transaction and no error is displayed to indicate anything is wrong.
4. After the transaction, the user checks Item Availability Inquiry (P41202)
   1. Quantity On Hand for the specific location and lot is reduced by 2.
5. User then checks Item Ledger (P4111) Inquiry.
   1. No transaction was recorded.
6. User checks the Account Ledger (F0911) table.
   1. No transaction was recorded.
7. User retrieves and reviews JDEDEBUG.LOG and finds the following errors:
   1. OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0335 - Character conversion resulted in substitution characters.
   2. JDB3400009 - Failed to perform Insert for F0911
   3. JDB9901232 - Canceling transaction because: TC052 InsertTable: Insert failed
   4. 078F - Insert to table F0911 failed
      • CAUSE . . . . The record being inserted into table F0911 already exists or you do not have authority to insert records into this table.
        RESOLUTION. . Verify that the record being added doesn't already exist and that you have proper authority. Check the JDE.LOG and JDEDEBUG.LOG for additional information.
      • Returned by Business Function F0911FSEditLine (b0900049)

Cause

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