EPC: PC_PRICING Is Not Re-Pricing BIL Rows When Funds Distribution Rows (FDS & FDR) Are Distributed to GL (Doc ID 1459483.1)

Last updated on JANUARY 03, 2024

Applies to:

Symptoms

PC_PRICING will not re-price a BIL row created from an original cost  (PAY) row when funds distribution (FDS & FDR) rows created from the same cost (PAY) row are distributed to GL. The GL_DISTRIB_STATUS on the FDS & FDR rows should not impact the re-pricing of a BIL row but this is currently happening with the current code in PC_PRICING.

Replication steps:
1. Setup and Activate a Project.
2. Setup a Funds Distribution Rule for a Project.  This rule creates FDS rows split 50/50 and also creates reversal (FDR) rows.
3. Setup a Rate Based Customer Contract to Bill Costs from the Project.
4. This Customer Contract uses Transaction Limits.  One Transaction Limit is for costs billed against the Source Type 1 value and the second transaction limit is for costs billed against the Source Type 2.
5. The rate set is attached to the contract line to price costs at 80% for billing under the Source Type 1.  The rate set picks up ACT, PAY, ATE, CNV and the FDS & FDR analysis types.  The FDS & FDR analysis types are from funds distribution.
6. Enter a PAY transaction directly into Project Costing.
7. Run the Funds Distribution process to create the FDS and FDR rows from the PAY row.
8. Run the Create Project Accounting process to create accounting entries for the FDS & FDR rows.  This changes the GL_DISTRIB_STATUS = D on the FDS & FDR rows.
9. Run pricing for the project.  This creates BIL rows for the PAY, FDS, & FDR rows.
10. Go back to the Customer Contract and change the rate set to price using the source type 2 instead of the source type 1.  Note that the BIL rows have not been distributed to billing or GL at this point.
11. Run Pricing with the re-price option for the project.  Would expect all 5 of the BIL rows to re-price and change the source type from 1 to 2.  The BIL row created from the PAY row will not re-price because the FDS & FDR rows created from the PAY row were run through create project accounting.  The fact that the FDS & FDR rows have been run through Create Project Accounting should not matter to re-pricing logic.  The other 4 BIL rows created from the FDS & FDR rows are re-priced.  

This seems to be a bug with Pricing when using funds distribution.  

From the attached trace of PC_PRICING the step PC_PRICING.MN1100.FROMPAY selects the 5 BIL rows for re-pricing.  Note that only rows with system source of PRP, PRC, or PRR are selected.

-- 17.02.01 ....(PC_PRICING.MN1100.FROMPAY) (SQL)
INSERT INTO PS_PC_RESID_TAO (BUSINESS_UNIT , PROJECT_ID , ACTIVITY_ID ,
RESOURCE_ID_FROM , PROCESS_INSTANCE , PC_DISTRIB_STATUS)
SELECT SRC.BUSINESS_UNIT , SRC.PROJECT_ID , SRC.ACTIVITY_ID , SRC.RESOURCE_ID_FROM ,
119550 , 'N' FROM PS_PROJ_RESOURCE SRC
WHERE SRC.SYSTEM_SOURCE IN ('PRP', 'PRC', 'PRR')
AND SRC.BUSINESS_UNIT = 'XXXX'
AND SRC.PROJECT_ID = 'XXXXXXX'
AND 1 = 1
AND SRC.BI_DISTRIB_STATUS IN ('P','C', 'I','U','N')
AND SRC.GL_DISTRIB_STATUS IN ('C', 'H')
AND SRC.CA_FEE_STATUS = ' '
AND SRC.FND_DIST_STATUS = 'N'
GROUP BY SRC.BUSINESS_UNIT , SRC.PROJECT_ID , SRC.ACTIVITY_ID ,SRC.RESOURCE_ID_FROM
/
-- Row(s) affected: 5

Later in the attached trace of Pricing, the PC_PRICING.MN1100.DEL_INP step deletes/eliminates the one BIL row created directly from the PAY row but does not delete the 4 BIL rows created directly from the FDS & FDR rows even though the FDR & FDS rows were created from the PAY row.  It seems that this step also needs system source logic of PRP, PRC, or PRR so it only eliminates a row from re-pricing if another row with the same resource_id_from value has a system source of PRP, PRC, or PRR and it has either been distributed to billing or GL.

-- 17.02.01 ....(PC_PRICING.MN1100.DEL_INP) (SQL)
DELETE FROM PS_PC_RESID_TAO
WHERE PROCESS_INSTANCE = 119550
AND (BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, RESOURCE_ID_FROM) IN ( SELECT /*+
hash_sj */ PR.BUSINESS_UNIT ,PR.PROJECT_ID , PR.ACTIVITY_ID , PR.RESOURCE_ID_FROM
FROM PS_PROJ_RESOURCE PR
WHERE PR.RESOURCE_ID <> PR.RESOURCE_ID_FROM
AND PR.ANALYSIS_TYPE <> 'SFA'
AND (PR.BI_DISTRIB_STATUS NOT IN ('P', 'C', 'I', 'U','N')
OR PR.GL_DISTRIB_STATUS NOT IN ('C', 'H', 'I', 'N')
OR PR.ASSET_ID <> ' '
OR PR.AM_DISTRIB_STATUS = 'D'
OR PR.CA_FEE_STATUS = '1'))
/
-- Row(s) affected: 1

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.