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:

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

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