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
Oracle Advanced Supply Chain Planning - Version 12.2.4 and later Information in this document applies to any platform.
On 220.127.116.11, 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!