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 Assign Products and Services to an Existing Supplier (eBS R12.2.3)?

Most of the time organizations are looking to categorize their own suppliers based on type of products and services they are purchasing.

This post will walk you trough Oracle eBS Supplier Products and Services configuration and the way products and services may be assigned to an existing supplier or may be included as a step inside supplier registration flow (iSupplier).

Configuration steps

The following are the configuration steps (a flex structure is already configured):

1. Identify the default category set assigned to Purchasing functional area (Purchasing in our example)
2. Identify the Flex structure linked to category set (PO Item category, in our example)
3. Populate flex structure  (PO Item category) with values - categories
4. Assign only values - categories you consider are relevant for suppliers
5. Setup up Products and Services category by assigning one or more segments of your flex structure (PO Item category)
6. Enable Products & Services profile section for internal users (standard supplier page) and/or for supplier users (iSupplier or supplier registration page)

Demo

1. Navigate to supplier page to add Products & Services categories to existing suppliers
2. Navigate to supplier registration page (iSupplier portal) and verify that Products & Services section is visible and may be used

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 

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