Java Exception Error JBO-27120 When Adding Material Requirements To Depot Repair WIP Job

(Doc ID 1992456.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 and 12.2.3 version, Repair Execution

When attempting to add customer product to the second WIP job in Execute Repair, the following error occurs.

From a Diff OU
Exception Details.
oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException
at oracle.apps.fnd.framework.OAException.wrapperException(
## Detail 0 ##

From Same OU
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: select concatenated_segments locator from mtl_item_locations_kfv mil where inventory_location_id = :1 and organization_id = :2 and subinventory_code = :3
at oracle.apps.fnd.framework.OAException.wrapperException(
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(

The issue can be reproduced at will with the following steps:
1. Create SR/SO in x OU
2. Receive Customer’s product into x organization (SJP)
3. Create WIP Job
4. Add labor to represent the initial inspection labor for the product.
5. Complete job issuing the customer’s product to the WIP job
6. Create Internal Move Order to send product to the y OU/Inventory Organization
7. Reserve, Pick, and Ship product
8. Switch responsibilities to the y org
9. Receive the product into the y organization (SBV)
10. Check material workbench to confirm receipt of correct serial number
11. Create a new WIP job in the SBV org
12. Errors:
a. Why is customer’s product is not placed on the WIP job as a requirement
b. When adding the customer’s product to the WIP job receive an ArrayIndexOutOfBoundsException error


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