EPC 9.2 : The Fund Distribution Process (PC_fnd_dist) Abends When Run With “Reprocess Distributed Transactions” Checked. Unique Constraint Error at Step - PC_FND_DIST.REDSTRB.Step01d (Action SQL) -- RC = 805 (Doc ID 2909884.1)

Last updated on NOVEMBER 24, 2022

Applies to:

Symptoms

The Fund Distribution Process (PC_FND_DIST) abends when run with "Reprocess Distributed Transactions" checked.
 

Replication Steps:

1. Define Cost Rate set.
2. Define BIL Rate set
3. Rate Plan defn. Include the Cost Rate set and Bill Rate set in the plan.
4. Create a Project and Activity.
5. Create a contract with rate based contract line and associate it with a
6. Poject/Activity along with the rate plan.
7. Assign As incurred bill plans to the contract line.
8. Activate Contract
9. Create a transaction.
10. Create funds distribution rules for the Project.
11. Now run Funds distribution process
12. Run CA_BI_INTFC to send the BIL transactions to Billing.
13. Run the PC_FND_DIST with the "Reprocess Distributed Transactions" option checked (Navigation: Project Costing > Funds Distribution > Funds Distribution Process). The process abends with the error message

Demo Replication Steps

Cause

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