Part Number LOV Generates Error On Install In HTML Debrief

(Doc ID 1665187.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Debrief / Field Service Report

On the HTML debrief, When trying to add an Install material line, and clicking on the Part Number LOV, an error stack is generated. The LOV on the "Remove" seems to work without issue.

ERROR
-----------------------
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT msibk.concatenated_segments item_number,
  msibk.description item_description,
  msibk.inventory_item_id,
  msibk.material_billable_flag billing_type,
  msibk.mtl_transactions_enabled_flag,
  msibk.recovered_part_disp_code,
  msibk.primary_uom_code,
  fl.meaning recovered_part_disp,
  decode(:1, 'NO_CTBT', -1, ctbt.transaction_type_id) transaction_type_id,
  msibk.organization_id,
  msibk.restrict_locators_code,
  nvl(msibk.comms_nl_trackable_flag, 'N') update_ib_flag,
  nvl(msibk.comms_nl_trackable_flag, 'N') ib_trackable,
  msibk.location_control_code,
.....
  AND NOT EXISTS
  (SELECT 'x'
  FROM mtl_onhand_quantities_detail moqd
  WHERE moqd.organization_id = msibk.organization_id
  AND moqd.inventory_item_id = msibk.inventory_item_id
  AND moqd.subinventory_code = cila.subinventory_code)
  ORDER BY item_number
===========

STEPS
-----------------------
1. Login to Oracle Apps
2. R) Field Service Manager -> Create Service Request -> Create Task and assign the same to a FS technician
3. Click the Debrief button to open the Debrief html page.
4. In the Material Debrief section, Add a new row in the Install section.
5. Enter the Business process, SAC, Click on the Part number lov and get the above mentioned error.

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