My Oracle Support Banner

Bank code is not fetching in the BI report. Bank code exist in the may EFT file but not fetching in the June and July EFT file generated from system. (Doc ID 2583483.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

Bank code is not fetching in the BI report. Bank code exist in the may EFT file but not fetching in the June and July EFT file generated from system.

Bank codes are kept in the application as a Lookup Type and report is picking up the information from here.

The following code* is being used to get the bank code information in the report: select * from (SELECT DISTINCT lookup_code,meaning FROM fusion.fnd_lookup_values WHERE language = 'US' AND lookup_type = 'XY_PAY_BANK_CODES') flv

as per sql code* the output the LOOKUP_CODE: XYZ / MEANING: 005 is shown

LOOKUP_CODE MEANING
XYZ 005

May-19 – EFT file >>>>>>>>>> Showing Bank Code of '005' <<<<<<<<<
Sr.NoEmployee NumberEmployee NameBank NameBank CodeIBAN NumberAccount Number
123456Peter Pan United Bank005XY12345678910111213141516171819202122324
789101Tinker Bell United Bank005XY12345678910111213141516171819202122397

June-19 – EFT File >>>>>>>>>> NOT Showing Bank Code of '005' <<<<<<<<<
Sr.NoEmployee NumberEmployee NameBank NameBank CodeIBAN NumberAccount Number
123456Peter Pan United Bank XY12345678910111213141516171819202122324
789101Tinker Bell United Bank XY12345678910111213141516171819202122397

July-19 – EFT file >>>>>>>>>> NOT Showing Bank Code of '005' <<<<<<<<<
Sr.NoEmployee NumberEmployee NameBank NameBank CodeIBAN NumberAccount Number
123456Peter Pan United Bank XY12345678910111213141516171819202122324
789101Tinker Bell United Bank XY12345678910111213141516171819202122397

Observation:
Bank code will not be updated against the employee level. Its picked from the lookup value only.
Business will create a personal payment method and attach the bank account details only.
There is no field in front end to capture the bank code.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.