On 12.2.3 VCP and 12.1.3.9.2 EBS Source - Work Order Release From ASCP Workbench Results In Error "Error In The Release Process " ORA-00904: UNADJUSTED_RESOURCE_HOURS (Doc ID 2206487.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

EBS source - 12.1.3.9.2
with MRP_AP_REL_PLAN_PUB MRPRELPB.pls 120.11.12010000.26

VCP destination - 12.2.3 with 18734033:R12.MSC.C
with MSC_REL_PLAN_PUB MSCPRELB.pls 120.89.12020000.11


Work Order Release from ASCP workbench results in error "Error in the release process.

Navigate to ASCP workbench, view supply and demand. Check Firm and Release on a planned order.
Choose Action Release
Receive error. Work order is not created due to this error.

ERROR
-----------------------
Error in the release process. Please check the setup.
ORA-00904: "UNADJUSTED_RESOURCEHOURS" invalid identifier
ORA-06512 at "APPS.MRP_AP_REL_PLAN_PUB line 2413
ORA-0652 at APPS.MSC_REL_PLAN_PUB line 1034




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Supply Chain Plan > Workbench
2. Select planned order and release

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This will prevent our year-end patch application scheduled for weekend of November 19th

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