...

ENABLING FIELDS ON BANK PAGE USING REST APIs

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.

Country code

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:

/fscmRestApi/resources/11.13.18.05/bankAccountUserRules?q=CountryCode=’US’

Action: GET

Content-Type

Content type

Click Send

Payload is as below:

Payload

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

/fscmRestApi/resources/11.13.18.05/bankAccountUserRules

Action: Post

Content-Type

Post content type

Click Send

Payload as below:

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

Leave a Reply

Your email address will not be published. Required fields are marked *