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 FEBRUARY 03, 2019
Applies to:
Oracle Depot Repair - Version 12.2.4 and laterInformation 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |