what is the trace to setup to check the temp table values?
hi,
One of the appengine programs is going to no success due to the unique constraint error on a temp table. Below is the error message. I checked the data and could not see anything that could cause the unique constraint error. When I setup the SQL or peoplecode trace as TRACE 7 -TOOLSTRACEPC 3096 -TOOLSTRACESQL 135. I am not seeing the value that is causing the issue. Can you please let me know what trace level will give the values that is causing the error? Thanks.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_CA_BI_PC_TA25) violated Failed SQL stmt:INSERT INTO PS_CA_BI_PC_TA25 (PROCESS_INSTANCE, CONTRACT_NUM, CONTRACT_LINE_NUM, BUS INESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_ID, EVENT_OCCURRENCE, BUSINESS_UNIT_GL, DELETE_ME, INTFC_LINE_NUM, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, RESOURCE_QUANTITY , RESOURCE_AMOUNT, CURRENCY_CD, FOREIGN_AMOUNT, FOREIGN_CURRENCY, RT_TYPE, BILL_CUR_OPT, GROSS_EXTEN DED_AMT, BI_CURRENCY_CD, BUSINESS_UNIT, BUSINESS_UNIT_CA, BILL_PLAN_ID, BPLAN_LN_NBR, RETAINAGE_ID, RETAINAGE_PCT, INCLUDE_RETAINAGE, DISCOUNT_ID, DISC_SUR_ID, DISCOUNT_PCT, TRANS_DT, BUSINESS_UNIT_TO , BILL_TO_CUST_ID, ADDRESS_SEQ_NUM, CNTCT_SEQ_NUM, CONTRACT_TYPE, CONTRACT_DT, SHIP_TO_CUST_ID, SHIP