My Oracle Support Banner

Ship To Search Field Produces Error On Shipment Planning And Transactions Form - FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 (Doc ID 3026337.1)

Last updated on JUNE 12, 2024

Applies to:

Oracle Shipping Execution - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

When attempting to bring up the list of values (LOV) for the ship to,
the following error occurs and is shown on the form.

Error shown on the shipping transaction form / query manager:
  FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508


The issue can be reproduced at will with the following steps:
1. Order Management Super User responsibility
2. Navigate to Shipping Transaction form
3. Click on the "Ship To" field.
    Pull up the list of values, enter %TEX% and click on the FIND button.
    Find cursor spinning.
    LOV is not rendered
4. Error message above is shown:
    FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
5. Find that this form is unusable after clicking on the ship to field.



Changes

Upgraded the instance from 12.1.3 to 12.2.11
Within 12.1.3 the field worked. Within 12.2.11 the field does not work.
Had applied Patch 35142043:R12.WSH.C
Using current file versions
   $WSH_TOP/forms/US/WSHFSTRX.fmb 120.83.12020000.64
   $WSH_TOP/forms/US/WSHQSSUI.fmb 120.35.12020000.31
   $WSH_TOP/forms/US/WSHSTREF.fmb 120.162.12020000.102

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


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