PA_GMS_INTEGRATION_API: A Payables Invoice Does Not Pass Funds Check and is Placed On Hold (Doc ID 2964507.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

When performing the Funds Check on a new Payables (AP) Invoice the invoice is placed on hold and is not released.

Reviewing Funds Check for the Project will show a Result Code of F166.

1. Log into a Projects Responsibility
2. Navigate to Expenditures > Transaction Funds Check Results
3. Enter the project number
4. Click Find
5. The results will show Funds Check results for transactions against this project
6. The Funds Check Results section will list the reason for the failed Funds Check
   1. F166 - There is no baselined budget version for this project

The data can also be reviewed in the pa_bc_packets table.

1. Run the query - Select * from PA_BC_PACKETS where PROJECT_ID = :PROJECT_ID;
2. Review the results with the highest packet_id being the most recent entry.
3. Look for columns with names, result_code task_result_code and resource_result_code.
4. If any of these columns shows a value of F1##, then that will indicate the reason for the failure.
   1. This case F166 - There is no baselined budget version for this project is indicated
   2. Refer to R12: What are the Funds Checking Result Codes in Oracle Projects (Doc ID 445119.1) for a full list of meanings.

The issue can be reproduced with the following steps:

1. Login to AP Responsibility

2. Create Standard Invoice and assign a project

3. Check Funds from Menu Action, Error message appears.

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.