All apps dba Blog is the blog contributed by Doyensys Employees, With the view to share the knowledge out of their experience.
Doyensys Is a Fast Growing Oracle Technology Based Solutions Company Located in the US And Offshore Delivery Centers in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite
Try to Schedule Sales Order In New Test Instance - Get Message - Summary Concurrent ==================================================== program is running. Try ATP Later =====================
On : 188.8.131.52 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.
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