Error While Creating New Internal Move In The Depot Workbench: ORA-01417: a table may be outer joined to at most one other table (Doc ID 2432926.1)

Last updated on AUGUST 08, 2018

Applies to:

Symptoms

On : 12.2.4

While creating an Internal Move Order in Depot Repair Workbench, the following error occurs.

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: SELECT cr.inventory_item_id , msi.concatenated_segments , msi.primary_uom_code , msi.primary_unit_of_measure, cr.quantity , TRUNC(SYSDATE) needByDate , org.organization_id shipFromOrg , ou.name OU_NAME , ou.organization_id ou , org.organization_name shipFromOrgName, msi.description, msi.restrict_subinventories_code, msi.restrict_locators_code FROM csd_repairs cr , mtl_system_items_kfv msi, hr_operating_units ou , org_organization_definitions org WHERE cr.repair_line_id = :1 AND msi.inventory_item_id(+) = cr.inventory_item_id AND ou.organization_id = nvl(fnd_profile.value('ORG_ID'), FND_GLOBAL.org_id) AND org.organization_id(+) = nvl(cr.inventory_org_id, fnd_profile.value('CSD_DEF_REP_INV_ORG')) AND msi.organization_id(+) = org.organization_id AND ou.organization_id = org.operating_unit(+)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

## Detail 0 ##
java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Depot Workbench
2. Create a repair order
3. On logistics tab select Actions > internal move order
    When HTML page opens select 'New Internal Move'
4. The reported error occurs

Changes

Cause