PC_INTFEDIT or PC_WRAPPER ABENDED at Step PC_PRICING.NSTD.PCRPLAN (Action SQL) -- RC = 1427 (Doc ID 2255385.1)

Last updated on APRIL 24, 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

On : 9.2 version, Functionality

When running PC_INTFEDIT or PC_WRAPPER, the following error is received.

ERROR
-----------------------
-- 18:19:13.416 .........(PC_PRICING.NSTD.PCRPLAN) (SQL)
UPDATE PS_BPA_RATES_TA0 SET RATE_PLAN_TYPE = 'R', RATE_PLAN = ( SELECT
PLN.RATE_PLAN FROM PS_PC_PRICE_RATES PLN WHERE PLN.BUSINESS_UNIT =
PS_BPA_RATES_TA0.BUSINESS_UNIT AND PLN.PROJECT_ID =
PS_BPA_RATES_TA0.PROJECT_ID AND PLN.ACTIVITY_ID =
PS_BPA_RATES_TA0.ACTIVITY_ID AND PLN.RATE_SELECT = '2' AND
PS_BPA_RATES_TA0.PROCESS_INSTANCE = 98529) WHERE PROCESS_INSTANCE = 98529 AND
RATE_TMPL_OPTION = 'NSTD' AND TEMPLATE_TYPE = 'C' AND CONTRACT_NUM IS NOT
NULL AND CONTRACT_NUM <> ' ' AND PC_TEMPLATE_ID IS NOT NULL AND
PC_TEMPLATE_ID <> ' ' AND EXISTS( SELECT 'X' FROM PS_PC_PRICE_RATES PLN WHERE
PLN.BUSINESS_UNIT = PS_BPA_RATES_TA0.BUSINESS_UNIT AND PLN.PROJECT_ID =
PS_BPA_RATES_TA0.PROJECT_ID AND PLN.ACTIVITY_ID =
PS_BPA_RATES_TA0.ACTIVITY_ID AND PLN.RATE_SELECT = '2' AND
PS_BPA_RATES_TA0.PROCESS_INSTANCE = 98529)
/
-- Row(s) affected: 0
-- 18:19:13.540 Process 98529 ABENDED at Step PC_PRICING.NSTD.PCRPLAN (Action SQL) -- RC = 1427
ROLLBACK
/
-- 18:19:13.641 SQL Error: ORA-01427: single-row subquery returns more than one row

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a Cost rate set . Source TLX to Target ACT
2. Create a Rate Plan with this cost Rate set.
3. Create a Project/Activity - Today’s date is 12/21. But the project start date is 12/1
4. Associate the rate plan that was created in step #2
5. Create activity with start date as 12/1
6. Rates assigned with effective date 12/1 to this activity
7. Update Activities as of today 12/21. Another row gets added to the Activity rates with today's effective date
8. Create a Contract with rate based contract line and save
9. Create Contract rate set of billing type for the contract that was created in step #8. Source TLX to Target BIL
10. Associated the project/Activity, rate set created in step 9 to the contract line using Related project page and save
11. Create a TLX transaction and process.
12. The process abends with the above error message


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