My Oracle Support Banner

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:

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

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

To view full details, 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 a vibrant support community of peers and Oracle experts.