R12: Bank accounts are not visible

This is due to security set up. Please follow the steps:

1. Log in as Sysadmin.
2. Go to the User Management Responsibility. Path: Roles & Role Inheritance
3. In the Type field select Roles and Responsibilities
4. Wait until a new field appears, you will see the category field, please select Miscellaneous
5. In the Application select 'Cash Management' and click on GO button.
6. Search the responsibility name.
7. Click on the update icon.
8. A new window will be displayed, please click in the Security wizard button.
9. For CE UMX Security wizard click on the Run Wizard.
10. In this window, add the Legal Entity name that you want to grant the access to all the bank accounts and choose the privileges that you want to assign to this role on the bank accounts: USE, MAINTENANCE and BANK ACCOUNT TRANSFERS.
11. Save and apply the changes.

Display DFF value set values depending on form filed value

Create a table type value set.
Choose the form filed, from the diagonistics choose the form block name and filed name
In the where condition add the condition like

Where 1=1
and table.column_name= :FORM_BLOCK_NAME.FILED_NAME

example:
SELECT segment1
FROM pa_projects_all
WHERE project_status_code = 'UNAPPROVED'
and attribute1 || '.' || attribute2 || '.' || attribute3=SUBSTR(:LINES.ACCOUNTING_FLEXFIELD,1,11)

Form Folder - LINES
Form filed  -- ACCOUNTING_FLEXFIELD

Define Table type value set
Table Name: pa_projects_all
value: segment1
Where:
project_status_code = 'UNAPPROVED'
and attribute1 || '.' || attribute2 || '.' || attribute3=SUBSTR(:LINES.ACCOUNTING_FLEXFIELD,1,11)