Value Chain Planning - EBS (MOSC)

MOSC Banner

Memory Based Planner - Ends in Error

edited Nov 21, 2021 8:42AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered

Hello ,

I am receiving the below MBP error as part of the supply plan run in ASCP. if I run again sometimes this MBP runs sucessfuly. Please let me know if there is a resolution or root cause for this issue/any suggestion to troubleshooting is appreciated.


Thank you!

Ray


value used for ROWS parameter changed from 1000 to 167
Record 5727295: Rejected - Error on table "MSC"."MSC_FULL_PEGGING#".
ORA-00001: unique constraint (MSC.MSC_FULL_PEGGING_U1) violated


MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table "MSC"."MSC_FULL_PEGGING#":
  5727294 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                 997658 bytes(167 rows)
Read   buffer bytes: 1048576

Total logical records skipped:   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center