Shipment Flex Field Column on Invoice Screenset Throws 'An Undefined Error Has Occurred" Error

(Doc ID 2374755.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Transportation Management Cloud Service - Version 6.4.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to click on the Shipment User Defined Attribute/Flex Field column on the Invoice Finder, the following error occurs.

ERROR
-----------------------
An Undefined Error Has Occurred. Please Try Again Later


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

01. Flex Field Def: XXX

Table Name: INVOICE
Field Name: ATTRIBUTE2

Manager Layout
Query Table ID: SHIPMENT
Screen Set ID: SHIPMENT

Screen Set
Query Table ID: SHIPMENT
Screen Set ID: SHIPMENT

02. Custom Invoice Screenset: XXX (Include the User Defined Attribute 2)

03. Agent: XXX
Agent Type: INVOICE
Agent Event: INVOICE - CREATED
Agent Action: DIRECT SQL UPDATE

UPDATE INVOICE SET ATTRIBUTE2=(SELECT INS.SHIPMENT_GID FROM INVOICE_SHIPMENT INS WHERE INS.INVOICE_GID=$GID) WHERE INVOICE_GID=$GID

04. Create a Shipment

05. Create an Invoice

06. Login to OTM

07. Open the custom INVOICE Screen Set> enter invoice ID XXX > Click search > Scroll to the right, column User Defined Attribute 2 > Click on the Shipment ID > Error

An Undefined Error Has Occurred. Please Try Again Later.

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