Issues With Funding Workbench Form (Doc ID 1590382.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

1. During the creation of a new funding source/agreement and click the Allocations button to go into Fund Allocations form, you cannot exit the form if you don’t enter anything. You continually get the message at the bottom of the screen “FRM-40202: Field must be entered.” and the Amount field is highlighted. It doesn’t matter if you click the Clear Record or Delete menu icon. The only way to exit is to issue the File/Close Form menu command but this causes user to exit the entire Funding workbench form, not just the Fund Allocations form.

2. We use Form Personalization to make the Funding Workbench non updatable if there is no change request. We do this by setting the Block FUND_SOURCE property UPDATE_ALLOWED to FALSE. (See screen shots below.) This seems to work correctly as all fields on the main Funding Workbench are not updatable along with the Funding Source DFF. However, as you can see in the screen shot of the Agreements DFF is updatable. This causes an error if the use mistakenly updates an Agreements DFF field. The message “FRM-41050: You cannot update this record.” is repeatedly displayed and the user is stuck in a loop. The only way to get out is to kill the java session. I believe that this can be prevented if prior to the call to display the Agreements DFF the property UPDATE_ALLOWED is queried for the FUND_SOURCE block object and if it is set to FALSE, call the Agreements DFF in view only mode, the same way the Funding Source DFF is being displayed.

3. When you are using change requests and you are in the Contract Organizer form and you attempt to Goto the Authoring workbench you get a popup message (OKE-248089) that tells the user to that they must use Change Management to edit/update Authoring workbench info and the form is read only. The user doesn’t receive the same message nor is the Funding Workbench form in read only mode when the user clicks Goto/Funding Workbench from the Contract Organizer. One would expect the functionality to be the same. If you are using Change management then one should only be able to get to modifiable Authoring or Funding workbench forms if there is an active Change Request and via the Change Request Implement button.

4. Once you have an administrator assigned, you can't delete it and have a NULL value saved. If you highlight the name in the Administrator field, delete it, then save the funding source record you get a message at the bottom of the form that the record was saved yet the ADMINISTRATOR_ID column in the OKE_K_FUNDING_SOURCES table still has the old value. You can select a different administrator from the LOV, click save and the new person_id is assigned to the ADMINISTRATOR_ID column in the OKE_K_FUNDING_SOURCES table still has the old value. But since the administrator is not a required field you should be able to save a NULL value.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms