Cannot Compile Shipping Forms (Including Wshfstrx) After Upgrading To 12.1.1

(Doc ID 952596.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 and later
Oracle Shipping Execution - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2013***

Symptoms

-- Problem Statement:
On 12.1.1 in Production:
When attempting to compile forms WSHFSTRX.fmx., WSHSTREF.fmx, WSHQSSUI.fmx or INVTTESR.fmx
adadmin is giving the following error

ERROR
FRM-30064: Unable to parse statement SELECT *
FROM (SELECT serial_number, gen_object_id, 2 object_type, NULL lot_number
FROM mtl_serial_numbers msn
,mtl_serial_numbers_temp msnt
WHERE inventory_item_id = :serial_control.wip_assembly_id
AND transaction_temp_id = :mtl_serial_reference.parent_transaction_id
AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
AND msn.current_organization_id = :mtl_serial_reference.org_id
UNION ALL
SELECT serial_number, gen_object_id, 2 object_type, mtlt.lot_number lot_number
FROM mtl_serial_numbers msn
,mtl_serial_numbers_temp msnt
,mtl_transaction_lots_temp mtlt
WHERE inventory_item_id = :serial_control.wip_assembly_id
AND mtlt.transaction_temp_id = :mtl_serial_reference.parent_transaction_id
AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
AND (:serial_entry.assembly_lot_number IS NULL
OR :serial_entry.assembly_lot_number = mtlt.lot_number)
AND msn.current_organization_id = :mtl_serial_reference.org_id)
ORDER BY Lpad(serial_number, 20).
ORA-00918: column ambiguously defined
Record Group WOL_ASSEMBLY_SERIAL_NUMBER
Form: WSHFSTRX
FRM-30085: Unable to adjust form for output.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. use adadmin to compile the forms

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot use the forms as they cannot be successfully compiled

Changes

Upgraded to release 12.1.1

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