E1: 46L: "ORA-00907: Missing Right Parenthesis" Error in Warehouse Availability P46230 (Doc ID 3057968.1)

Last updated on NOVEMBER 06, 2024

Applies to:

Symptoms

Error “ORA-00907: missing right parenthesis” is seen in the debug log when performing a Find on a Child LPN Number in P46230.

The issue can be reproduced at will with the following steps:
1. Fast path to P46230 - Warehouse Availability Inquiry.
2. On the Item/Location/Lot tab, enter the Branch Plant number in the Branch Plant field.
3. Click the License Plate tab.
4. Enter a child license plate number (LPN). (A child LPN is one that has a parent LPN.)
5. Press Find. The license plate information is displayed in the License Plate Structure section.
6. Click on Expand All...(next to Records 1 - 1 at top of License Plate Structure section).
7. Review the logs to see the missing right parenthesis and error ORA-00907: missing right parenthesis.

Cause

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