PC_FND_DIST Process Abend at Step PC_PRICING.COST100.CA1000 (Action SQL) -- RC = 920 (Doc ID 2252592.1)

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

With the setting Installation Options - Project Costing Integration "Run For Incoming Transaction" - checked on, the process abends with the below when described steps are followed.

ERROR
-----------

-- 16:04:17.138 ........(PC_PRICING.COST100.CA1000) (SQL)
INSERT INTO PS_BPA_RATES_TA0 (PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID,
ACTIVITY_ID, CONTRACT_NUM, CONTRACT_LINE_NUM, EFFDT, RATE_DEF_TYPE,
TEMPLATE_TYPE, RATE_PLAN_TYPE, PC_TEMPLATE_ID, SOLD_TO_CUST_ID,
BUSINESS_UNIT_CA, RATE_PLAN, TIER_PRICE_SW, RATE_TMPL_OPTION, CA_RQST_SRC,
SEPARATE_BIL_REV) SELECT 101539, CDP.BUSINESS_UNIT_PC, CDP.PROJECT_ID,
CDP.ACTIVITY_ID, CDP.CONTRACT_NUM, CDP.CONTRACT_LINE_NUM, CR.EFFDT, 'C',
PR.TEMPLATE_TYPE, ' ', CR.PC_TEMPLATE_ID, HDR.SOLD_TO_CUST_ID,
HDR.BUSINESS_UNIT, CR.RATE_PLAN, DTL.TIER_PRICE_SW, CR.RATE_TMPL_OPTION,
HDR.CA_RQST_SRC, HDR.SEPARATE_BIL_REV FROM PS_CA_CONTR_HDR HDR, PS_CA_RATE
CR, PS_CA_DETAIL DTL, PS_CA_DETAIL_PROJ CDP, PS_PC_RATE_HDR PR WHERE
HDR.CONTRACT_NUM = CR.CONTRACT_NUM AND CR.CONTRACT_NUM = DTL.CONTRACT_NUM AND
CR.CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM AND DTL.CONTRACT_NUM =
CDP.CONTRACT_NUM AND DTL.CONTRACT_LINE_NUM = CDP.CONTRACT_LINE_NUM AND
CR.EFF_STATUS = 'A' AND CR.RATE_PLAN = ' ' AND HDR.CA_PROC_STATUS <> 'C' AND
DTL.CA_LINE_STATUS <> 'C' AND CR.RATE_TMPL_OPTION = 'NSTD' AND
PR.BUSINESS_UNIT = CDP.BUSINESS_UNIT_PC AND PR.PC_TEMPLATE_ID =
CR.PC_TEMPLATE_ID AND PR.TEMPLATE_TYPE = 'C' AND PR.RATE_DEF_TYPE IN ('C',
'M') AND CDP.BUSINESS_UNIT_PC = 'US004' AND CDP.PROJECT_ID = 'VJ123' AND
CDP.ACTIVITY_ID = '111' AND CDP.BUSINESS_UNIT_PC = 'US004' AND CDP.PROJECT_ID
= 'VJ123' AND CDP.ACTIVITY_ID = '111' AND CDP.BUSINESS_UNIT_PC = 'US004' AND
CDP.PROJECT_ID = 'VJ123' AND CDP.AC AND 1=1 AND 1=1
/
-- Row(s) affected: 0
-- 16:04:17.338 Process 101539 ABENDED at Step PC_PRICING.COST100.CA1000 (Action SQL) -- RC = 920
ROLLBACK
/
-- 16:04:17.460 SQL Error: ORA-00920: invalid relational operator


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

In the Installation Options - Project Costing Integration "Run For Incoming Transaction" is checked on for funds distribution.

1. Create a Project with 2 activities, TEST1 & TEST2
2. Rate set defined to create a BUR for 30% from an ACT
3. Create a Funds Distribution Rule for Activity - TEST1 . Use this Rate set in Funds distribution Rule.
4. Source ACT and BUR -- Target FND with another activity TEST2 -- Reversals on
5. Using Add transactions page, Create ACT transaction of $100 and process
6. The PC_WRAPPER fails at the steps PC_PRICING.COST100.CA1000 (Action SQL) -- RC = 920 as mentioned above.

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