Error ORA-01436 When Trying To View The Serial Genealogy Form From The Serial Numbers Form (Doc ID 1958766.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INVOBGEN.fmb

Symptoms

When attempting to view the serial number in the View Geneology form INVOBGEN.fmb, the below error occurs.

Error
ORA-01436: CONNECT BY loop in user data
FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01436

STEPS
1. Navigate to Inventory Responsibility > Onhand Availability form
2. Choose the Serial Numbers tab.
3. Enter the serial number in the To-From fields and click Find button Item is displayed
4. When the record is returned, click on View Genealogy.
5. Error message is displayed but the User is still able to view the data after clicking OK.

Changes

This issue occurs after applying <Patch 17839765>:R12.INV.B related to the below bug.

<Bug 17839765> - VIEW GENEOLOGY PERFORMANCE ISSUE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms