Not Able To Display Shipment Cost Remarks (Doc ID 2764226.1)

Last updated on MARCH 29, 2021

Applies to:

Symptoms

When attempting to add Remark Qualifiers to a screenset for Shipment Cost, then inquiring in a shipment where the remark qualifiers were added the UI will not open and an error is set.

java.sql.SQLSyntaxErrorException: ORA-00904: "SCR_R0"."SHIPMENT_GID": invalid
identifier

Replication Steps:

1) Configuration and Administration > Power Data > Qualifiers > Remark Qualifiers. Add a Remark Qualifier.

2) Configuration and Administration > User Configuration > Screen Set Manager. Copy the SHIPMENT_COST public screenset. On the results tab add Shipment GID, Cost Type, Accessorial Code, Cost, Domain Name, and Remark Text(P). Set Remark Text(P)= to the one created in step 1.

3)Shipment Management > Shipment Management > Buy Shipments. Go to the Finacials tab and add Remark Qualifier to the cost.

4) Configuration and Administration > User Configuration > Menu Manager. Add to menu.

5)Configuration and Administration > User Configuration > Manage User Access.
Add the menu. Log out and back in.

6) Go to the menu icon and enter the shipment in the Shipment Gid and select the contains operand and click Find. Error is set.

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.