DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, March 29, 2016


Try to Schedule Sales Order In New Test Instance - Get Message - Summary Concurrent 
====================================================
program is running. Try ATP Later
=====================


On : 11.5.10.2 version, Scheduling and Sourcing

When attempting to book the sales order,
the following error occurs.
Error message in the application is:
Summary Concurrent program is running.  Try ATP Later

OM debug log file shows
ERROR
-----------------------
-----------------Loading MRP Result---------------
MRP COUNT IS 1
SCHEDULE ACTION CODE SCHEDULE

X_RETURN_STATUS E
RR: L2
AFTER ACTION SCHEDULE : E
SCH SHIP DATE
SCH ARR DATE
SHIP_FROM 2453
Exiting schedule_line: 11-JUN-12 10:48:57
schedule return status E
scheduling flow error ORA-0000: normal, successful completion
In WF save messages
ENTER Save_API_Messages
L_MSG_DATA=Scheduling failed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. PS OM Super User
2. Orders/Returns-->
3. Book the sales order
4. error occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot book the sales order.


SOLUTION :
=========

1. Run the following SQL on the APS destination instance.

update MSC_APPS_INSTANCES set SUMMARY_FLAG = NULL;
commit;

Somehow the flag in msc_apps_instances got set to 2... this would be normal if you ran the program -
 Load ATP Summary Based on Collected Data OR Load ATP Summary Based on Planning Output
- while the program is running, it would set this flag and provide this message, then upon completion, 
would remove the flag so you could continue scheduling orders.
- This program is launched by user or when you have profile - MSC: Enable ATP Summary Mode - Yes

Appears instance was cloned with this flag - 2

Note, you should not use this program when you have distributed install, and both instances 
should have the profile MSC: Enable ATP Summary Mode - NO

No comments: