My Oracle Support Banner

Create Personal Payment Method Errors - Payroll Batch Loader: JBO-Provide bankAccountId or BankName,BankBranchName,CountryCode,BankAccountNumber (Supplier bank account) (Doc ID 2379116.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Fusion Payments - Version 11.12.1.0.0 and later
Oracle Fusion Cash Management - Version 11.12.1.0.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Global Payroll

When attempting to Create Personal Payment Method,

the following error occurs.

ERROR
-----------------------
JBO-Provide bankAccountId or BankName,BankBranchName,CountryCode,BankAccountNumber

EXPECTED BAHAVIOUR
-----------------------
Create/ attach Personal Payment Methods for the employees accounts that have been loaded first as Suppliers.
(first being able to bulk inactivate the bank account number and bank account owners loaded as Suppliers)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Employee and employee as supplier need to co-exist in the system for two primary reasons:
a. For filing expenses
b. There can be a genuine scenario where an employee is registered as supplier for some services

This the first time we are encountering this issue. This due to execution constraints we migrated Suppliers first and then employees first time this way.
We are using FBDI to load supplier and all supplier attributes including banks.
We are using HDL for all employee information, PBL for employee banks and personal Payment method.

2. When attempting to Create Personal Payment Method the above error mentioned is encountered.

Observation:

Support provided Action Plan
1. Remove the account already present for the Supplier;
2. Add the bank account for employee Salary and for the same attach a Personal Payment Method;
3. Attach the same bank account to your Supplier.

User feedback:

Test1
1. Remove the account already present for the Supplier;
User -We cannot delete the bank account only inactivate it
Tried updating the end date using supplier fbdi and though it populated end date at assignment level, it did not inactivate the bank account itself, we checked from backend as well
2. Add the bank account for employee Salary and for the same attach a Personal Payment Method;
User - Still the same error - A record with this combination of values already exists
3. Attach the same bank account to your Supplier.

Test2
1. Remove the account already present (30588954) for the Supplier;
User - We inactivated the bank account from application manually - Populated field inactivated on
2. Add the bank account for employee Salary and for the same attach a Personal Payment Method;
User - Still the same error - A record with this combination of values already exists
3. Attach the same bank account to your Supplier.

Test3
1. Remove the account already present (30588954) for the Supplier;
User - We inactivated the bank account manually and went to Account owner record and populated the end date manually - Populated field inactivated on at bank account and end date for account owner
2. Add the bank account for employee Salary and for the same attach a Personal Payment Method;
User - Success
3. Attach the same bank account to your Supplier.
User - success

Since we are not able to bulk inactivate the bank account number and bank account owner, this option not helping

https://docs.oracle.com/cloud/farel12/procurementcs_gs/OAPRC/OAPRC1007476.htm#OAPRC1007365
Setting Up a Supplier's Bank Account: Explained

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create/ attach Personal Payment Methods for the employees accounts that have been loaded first as Suppliers.

Cause

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
Symptoms
Cause
Solution
References


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