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

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