22160153 Exception Group In Plan Causes Msc_system_items.sr_category_id = 0 - Then Req Import Fails
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.
On 188.8.131.52, using Advanced Supply Chain Planning:
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
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.
Expect that the Planned Orders should be populating the proper group by code for requisition import.
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.
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.
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