EPC: Wild Card Character '%' In Custom Rate -ABENDED At Step PC_PRICING.CUST1100.BILL or AT PC_PRICING.CUST1100.COST (Doc ID 2227772.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

Error:
SQL Error: ORA-00001: unique constraint (SYSADM.PS_PC_RT_RUN_TAO4) violated
PC_PRICING abended at PC_PRICING.CUST1100.BILL or PC_PRICING.CUST1100.COST

Replication steps:
1. Prepare custom rate and use wildcard in one of the RES_USER field.
2. Create a Timesheet or an Expense report or Add transaction with RES_USER populated
2. Run the process like PC_EX_TO_PC or 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