Bank page in Oracle HCM Cloud is one of the most used and important pages. It captures the details from the employees, and they are then used during payroll processing.
One of our customers recently had a request where we had to add additional fields in the bank page.
As you may be aware, from release 20A, bank page rules can be handled Using Rest APIs. In this blog, we will see how we added country specific rules delivered by Oracle, using REST APIs.
FETCHING COUNTRY SPECIFIC RULES
We have country specific rules defined in Oracle Fusion HCM.
In below screenshot we can observe that each field has been defined by default whether to be displayed and made mandatory.
Normally we can fetch the details using SQL as below:
| Select * from FUSION.CE_CTRY_SPECIFIC_UI_RULES – where country_code = ‘US’ |
Using REST API, we can now perform the following GET action:
Example:
REST URL:
| <server>/fscmRestApi/resources/11.13.18.05/bankAccountUserRules?q=CountryCode=’US’ |
Action: GET
Content-Type
Click Send
Payload is as below:
Now, let us have look at one of scenarios where we want to enable Bank Name for US.
Using POST Action available in API, we can create new resources.
Usage of POST Action
On successful creation, the call returns HTTP status 201, i.e., returning location header with a link to the newly created resource.
Example:
Example:
URL
| <server>/fscmRestApi/resources/11.13.18.05/bankAccountUserRules |
Action: Post
Content-Type
Click Send
Payload as below:
Now that you have seen how we can cater such requests at Employee Self Service level, a question would arise as to how we can handle same scenario on the Administrator page. Are you looking to implement such a solution? Contact us
