My Oracle Support Banner

22160153 Exception Group In Plan Causes Msc_system_items.sr_category_id = 0 - Then Req Import Fails (Doc ID 2089748.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On 12.2.4.1, using Advanced Supply Chain Planning:

ACTUAL BEHAVIOR
---------------
Exception group in plan options causes msc_system_items.sr_category_id = 0 - then req import fails when Preferences are setup as Group by Category

Releasing the planned orders is inserting the value of 0 (zero) into MSC_PO_REQUISITIONS_INTERFACE which in turn inserts into the PO_REQUISITIONS_INTERFACE_ALL.

When the exception group is not null in the plan options, then the records populated in the msc_po_requisitions_intreface table has group_Code as zero which is causing the requisition grouping to fail.
-- this is because msc_system_items.sr_category_id = 0 for all items in the plan
and MSCPRELB.pls version 120.89.12020000.14
  REQ_GRP_CATEGORY, nvl(to_char(msi.sr_category_id),

3) When the exception group is null in the plan options, then the records populated in the msc_po_requisitions_intreface table has group_Code as null and the requisitions created are grouped by category.

EXPECTED BEHAVIOR
-----------------------
Expect that the Planned Orders should be populating the proper group by code for requisition import.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Release the planned order from the ASCP workbench.
2. Find that the group by is set to 0 in the po_requisitions_interface_all.
3. The requisition import process would not complete.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the requisitions.
The users are able to login and access the application - this is working.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.