EPC Wild Card Character '%' In Custom Rate- Abended At PC_PRICING.CUST1000.Step01 After Bug 24836646 (Doc ID 2227815.1)

Last updated on JANUARY 27, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Wildcard character '%' is used in Custom Rate, PC_PRICING will abend at PC_PRICING.CUST1000.Step01 after Bug 24836646 is applied

Error:
ABENDED at Step PC_PRICING.CUST1000.Step01 (Action SQL) -- RC = 805
SQL Error: ORA-00001: unique constraint (SYSADM.PS_PC_CUST_TAO6) violated

REPLICATION STEPS
=================
1. Prepare custom rate and use wildcard in one of the RES_USER field.
SELECT SETID, RATE_NAME, EFFDT, ROW_NUMBER()OVER(PARTITION BY FIELDVALUE1 ORDER BY FIELDVALUE2), APPLY_RATE_TO,CURRENCY_CD, UNIT_OF_MEASURE, FIELDVALUE1, FIELDVALUE2, FIELDVALUE3,Fieldvalue4, Fieldvalue5 FromPS_PC_RATE_CUSTVW CUSTI WHERE CUSTI.RATE_NAME = 'CUSTOMRT'
.
SETID RT_NAME EFFDT ROW ART UOM FLDVAL1 FLDVAL2 FLDVAL3 FLDVAL4 FLDVAL5
CRDCO CUSTOMRT 01-01-01 1 Q MHR LADMN CLNTB N AK OTHER
CRDCO CUSTOMRT 01-01-01 2 Q MHR LADMN CLNTB N ALL 1001
CRDCO CUSTOMRT 01-01-01 3 Q MHR LADMN CLNTB N ALL OTHER
CRDCO CUSTOMRT 01-01-01 4 Q MHR LADMN CLNTB N HI OTHER
CRDCO CUSTOMRT 01-01-01 5 Q MHR LADMN CLNTB Y ALL OTHER
CRDCO CUSTOMRT 01-01-01 1 Q MHR LPROF CLNTB N AK OTHER
CRDCO CUSTOMRT 01-01-01 2 Q MHR LPROF CLNTB N ALL 1001
CRDCO CUSTOMRT 01-01-01 3 Q MHR LPROF CLNTB N ALL OTHER
CRDCO CUSTOMRT 01-01-01 4 Q MHR LPROF CLNTB N HI OTHER
CRDCO CUSTOMRT 01-01-01 5 Q MHR LPROF CLNTB Y ALL OTHER

2. Create a Timesheet or an Expense report or Add transaction with RES_USER populated
3. Run the process like PC_INTFEDIT - it will abend.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms