ECA / EPC : Customer Contract Fluid - Contract Profit Margin Tile Does Not Display Cost, Profit Margin and Profit Margin (%) Fields With Correct Values. (Doc ID 2818234.1)

Last updated on OCTOBER 03, 2023

Applies to:

Symptoms

Customer contract fluid - contract profit margin tile does not display Cost, Profit Margin, and Profit Margin (%) fields with correct values. Since Cost was calculated incorrectly the Profit Marfin fields are also incorrect.

Replication Steps:

1. Create an award with project budgets.
2. Create a new analysis type FRN.
3. Create a Rate plan with cost and billing rate set. Cost Rate Set - Creates an FRN target for PAY row of 50% cost. Billing Rate Set - Created BIL row at a mark up of 1.5 for both PAY and FRN transactions.
4. Create Cost transactions for the project. PAY row for example $100.
5. PAY and FRN rows got generated along with the associated BIL rows as per Rate Plan. Row exists at this time are $100 PAY, $50 FRN, $150 for BIL associated with PAY, and $75 for BIL associated with PAY.
6. Run CA_BI_INTFC.
7. The BIL rows got converted to BLD for billing rows associated with PAY and FRN rows.
8. Run PSA_ACCTGGL process to process revenue.
9. Run FS_JGEN (Journal Generator).
10. Run CA_LOAD_UPD. Retrieve Journal Updates process.
11. Added Project to My projects.
12. Ran the PC_SUM_PR (Refresh Reporting Tables) process.
13. Navigation: Go To the Fluid Home page. Customer Contracts > Contracts Profit Margin tile shows that the cost is $100 only. But the actual cost is $100 (PAY) + $50 (FRN) row for a total of $150.

Replication Document

Cause

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