EPC: Funds Distribution With Budget Checking, Processes Transactions to PS_PROJ_RESOURCE When Budget Exceptions Exist
(Doc ID 3010127.1)
Last updated on SEPTEMBER 24, 2024
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
- When running Funds Distribution with Budget Checking in Project Costing, FND and FDR Analysis Types are configured with Budget Checking enabled on the FD Rule.
- Transactions are processing through Funds Distribution generating FND & FDR entries.
- Within a Project/Activity/FD Sequence, Funds Distribution and Budget Checking assign a "Journal ID" to the PC_JOURNAL transaction.
- When that transaction PARTIALLY processes as a budget exception, the non-errored transactions are processing to PS_PROJ_RESOURCE, even though they did not process properly through Budget Checking
- Note: If all transactions error, or if all transactions pass budget checking, this problem is not apparent.
STEPS
1. Set Up Financials/Supply Chain > Install > Installation Options > Products > Commitment Control turned on for GL and PC
2. Set Up Financials/Supply Chain > Product Related > Project Costing > Transaction Options > use PC Analysis Types: FDR and FDS
3. Setup Financials / Supply Chain > Business Unit Related > General Ledger > Open Periods > Open Period Mass Update
a. Product = GL, Unit = EGV01, From Year 2024 - 01, To Year 2024 - 12
b. Boxes checked for all Subsystems
4. Project Costing > Project Definitions > Define Project General Info > BU = EGV01 > Add Project = ORA_FD_SR
a. Calculate = End Date, Duration in Days = 1, Start Date = 01/01/2024, End Date = 12/31/2024
b. Click “Proposed” link > change Status = ‘A’ (Approved) > Processing Status = Active, Project Status = Approved
5. Project Costing > Project Definitions > Define Project General Info > BU = EGV01 > Project = ORA_FD_SR
a. Click Project Activities link
b. Add two Activities: Test1 and Test2
6. Commitment Control > Budget Journals > Enter Budget Journals > Ledger Group = EG_APP > BU = EGV01 > add two lines:
a. Fund = F410, Class = 2600, Bud Ref = B0000, Amount = 1000.00
b. Fund = F450, Class = 2400, Bud Ref = B0000, Amount = 1000.00
c. Click Process button to Post > Status = Posted
7. Commitment Control > Budget Journals > Enter Budget Journals > Ledger Group = EG_PCE > BU = EGV01 > add one Line
a. PCBU = EGV01, Bud Ref = B0000, Project = ORA_FD_SR, Activity = 000000000000001
b. Click Process button to Post > Status = Posted
8. Commitment Control > Review Budget Activities > Budgets Overview > Add Inquiry = ADHOC2 > BU = EGV01
a. Ledger Group = EG_APP: Fund = F410 - F450, Class = 2400 - 2600, Budget Reference = B0000 > click Search > Budget = 2000.00,
Budget Balance = 2000.00
b. Ledger Group = EG_PCE: Bud Ref = B0000, PCBU = EGV01, Project = ORA_FD_SR, Class = 2400 – 2600, Activity = 000000000000001 >
click Search > Budget = 2000.00, Budget Balance = 2000.00
9. Project Costing > Funds Distribution > Funds Distribution > create Funds Distrib Rule to Process all Inbound Transactions Reverse Existing Costs
a. Radio button for ‘All Participating Activities’, Target Analysis Type = ACT
b. Click ‘Target’ link > Threshold Amount = 10000.00
c. Define Target Rows - Project Costing tab: Percentage = 100%, Analysis Type = FDS, boxes checked for Budget Check Reversals
d. General Ledger Tab - Fund Code = F450, Class Field = %, Budget Ref = %
10. Project Costing > Transaction Definitions > Add Transactions > Project = ORA_FD_SR, Activity = 000000000000001 > add two rows:
a. Analysis Type = ACT, Source Amount = 500.00, Source Currency = USD
b. Analysis Type = ACT, Source Amount = 500.00, Source Currency = USD
c. Click Transaction Detail link
> 1 of 2: Account = 6001, Fund Code = F410, Dept = ADM000, Class Field = 2600, Budget Ref = B0000
> 2 of 2: GLBU = EGV01, Account = 6001, Fund Code = F450, Dept = ADM000, Class Field = 2400, Budget Ref = B0000
d. Click Process Transactions button > PC_INTFEDIT Status = Successful, 0 Errors
11. PS_PROJ_RESOURCE has 2 rows: One for Fund F410 and the other for Fund F450 and RESOURCE_AMT = 500.00 for both
12. Project Costing > Funds Distribution > Process Funds Distribution > PC_FND_DIST Status = Success, Processed: 1, Errors: 1
13. SQL: select project_id, activity_id as Activity, resource_id, resource_id_from, analysis_type as an_type, fund_code, class_fld, budget_ref, journal_id, resource_amount, fnd_dist_status, budget_hdr_status, budget_line_status from ps_proj_resource where business_unit = 'EGV01' and project_id = 'ORA_FD_SR'
One FDR/FDS pair did not trigger a Budget Exception and also did not go to “Valid”.
Since there are no entries for these transactions in commitment control, the FDS/FDR entries should not be in this record, PS_PROJ_RESOURCE.
AN_TYPE FUND_CODE CLASS_FLD RESOURCE_AMOUNT RESOURCE_HDR_STATUS BUDGET_LINE_STATUS
ACT F410 2600 500.00 Y Y
ACT F450 2400 500.00 Y Y
FDS F450 2400 500.00 N N
FDR F450 2400 - 500.00 N N
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |