Supply Chain Management - PSFT (MOSC)

MOSC Banner

CM_CSTACCTG UNIQUE CONSTRAINT ERROR -

edited May 23, 2016 7:35AM in Supply Chain Management - PSFT (MOSC) 7 commentsAnswered

I am getting the below Error when I am running the CM_CSTACCTG process, I have checked the CM_RECEIPT Table but there is no Duplicate values in it.

SQL error. Function:  SQLExec Error Position:  0 Return:  805 - ORA-00001: unique constraint (SYSADM.PS_CM_RESOLVE_HIST) violated Statement:  INSERT INTO PS_CM_RESOLVE_HIST (BUSINESS_UNIT, INV_ITEM_ID, CM_BOOK, DT_TIMESTAMP, SEQ _NBR, CM_DT_TIMESTAMP, CM_SEQ_NBR, CM_DT_TIMESTAMP_A, CM_SEQ_NBR_A, CM_DT_TIMESTAMP_P, CM_SEQ_NBR_P, STORAGE_AREA, INV_LOT_ID, SERIAL_ID, TRANSACTION_GROUP, PRODUCTION_ID, OP_SEQUENCE, CM_COST_PROC_GR OUP, QTY_BASE, UNIT_MEASURE_STD, CONSIGNED_FLAG, TO_CONSIGNED_FLG, PROCESS_INSTANCE) SELECT A.BUSINE SS_UNIT, A.INV_ITEM_ID, A.CM_BOOK, A.DT_TIMESTAMP, A.SEQ_NBR, A.CM_DT_TIMESTAMP, A.CM_SEQ_NBR, A.CM_ DT_TIMESTAMP_A, A.CM_SEQ_NBR_A, A.CM_DT_TIMESTAMP_P, A.CM_SEQ_NBR_P,

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