How to update Supplier bank or Supplier bank branch details in Oracle EBS R12?

I’m sure you will find this demo very useful as it’s showing the correct way to update supplier bank and supplier bank branch details in Oracle EBS Release 12x. In many occasions I saw users creating new bank and/or branches due to lack of knowledge, training or access.

Instead to update or correct the existing banks and/or branches users will create new ones that in fact means duplicated information in your database and later on your will pay a lot of effort to clean you master data.

When a new supplier Bank or Branch will be created this information will be shared and visible together with all Banks or Branches created during the Internal bank accounts setup. This is way any implementation/upgrade should have a strict process in place to manage and keep a clean list of banks and branches.




Snapshot with supplier Banking Details page

 

Snapshot with manage Banks and Branches page

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to Create Supplier Bank, Branch and Bank Account Using APIs?

Data migration is always a pain task for all ERP implementation projects because of both data quality and migration scripts/available interfaces.

eBusiness Suite provides for important metadata and transactions either standard interface option or APIs (Application programming interfaces).

In this post I'll show to you how to use supplier bank APIs in case your client is providing you supplier banks details after you already migrated all supplier data.

Supplier bank APIs are (feel free to download):
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
IBY_EXT_BANKACCT_PUB.CREATE_BANK_ACCT
IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment

Live video

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to Create, Maintain Hierarchical Relationship of Trade Partners and Produce Reporting Base on Desired Hierarchy?

Most of the time e-Business Suite customers are looking for specific functionality to create, maintain hierarchical relationship of their trade partners (customers, suppliers, employees, banks, etc) and also to produce reporting base on desired hierarchy.

To achieve this functionality in Oracle eBS R12.1.1 you may use Customers Data Librarian responsibility and in later releases Supplier Data Librarian responsibility.

Using this responsibility you will be able to create and manage very easy various hierarchies and also access important information about each party.

Another great feature is the possibility to easily locate on yahoo/google maps each site of your partner based on its address.

Steps

1. Go to Customer Online Data Librarian Super User responsibility
2. Create party hierarchy
3. View hierarchy and details about each partner
4. Review and change hierarchy to create different levels
5. Create a new hierarchy that will be linked later with first one
6. Add first hierarchy under the second one
7. Also we may continue to add other children or change levels
8. Let's locate on map the customer / supplier address

Live Demo

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address