My Oracle Support Banner

On 12.2.3 VCP and 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 DECEMBER 16, 2020

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.


EBS source -
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 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

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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.