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

(Doc ID 952596.1)

Last updated on FEBRUARY 16, 2018

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***


-- 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

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
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
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


Upgraded to release 12.1.1


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