In this Document
Symptoms
Cause
Solution
References
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Order Management - Version: 11.5.10
This problem can occur on any platform.
ConcurrentProgram:OEOIMP - Order Import
Symptoms
On 11.5.10 in Production:
When attempting to import orders, the following error occurs for some orders:
ORA-1403: no data found in Package OE_GROUP_SCH_UTIL Procedure Group_Schedule_sets
The issue occurs when the profile OM: Assign New set For Each Line is set to Y.
Cause
As part of fix done for a Bug, many changes were made in the package and there was a change in the record structures resulting in a NO DATA FOUND.
This issue has been fixed in the file OEXUGRPB.pls in version 115.77.11510.15.
This is explained in the following bug:
Bug 5557013 NO DATA FOUND IN PACKAGE OE_GROUP_SCH_UTIL PROCEDURE GROUP_SCHEDULE_SETS
.
Solution
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Consolidated
Patch 55182662. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.
References
Bug 5557013 - NO DATA FOUND IN PACKAGE OE_GROUP_SCH_UTIL PROCEDURE GROUP_SCHEDULE_SETS
Errors
ORA-1403 no data found
