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 update Supplier information using API in Oracle EBS R12?

Is any way to run a supplier mass update from backend?

I bet this question was raised many time to E-Business Suite support team few months after go live. More over when data was migrated from a legacy system and cleaning activity was completed under time pressure.
Answer is yes, it’s possible to run a mass update as Oracle EBS provides APIs for supplier master data and also for supplier site level.

The API name is AP_VENDOR_PUB_PKG
· Create_Vendor
· Update_Vendor
· Create_Vendor_Site
· Update_Vendor_Site
· Create_Vendor_Contact
· Update_Vendor_Contact
· Update_Address_Assignments_DFF

In this video you can see the way AP_VENDOR_PUB_PKG.Update_Vendor may be used to update below fields:

Supplier type

Quantity Received Exception

Terms Date Basis and Pay Group

Inactive Date

Demo
 
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 Add iSurvey to iSupplier Registration Page in R12?

I just came across with a requirement to enrich supplier registration (iSupplier portal) page with a short questionnaire and also with possibility to add attachments.

iSupplier portal includes in release 12.2.3 add attachments functionality. In release 12.1.3  this feature is only inside standard supplier page - organization section.

What about questionnaire? Using as support Oracle note 1213989.1 I'll summarize the steps to deliver a solution using "out-of-the box" functionality.

Steps to follow

Step 1: Assign to your user Scripting Administrator and Survey Administrator responsibilities

Step 2: Create a questionnaire (Oracle Script)

Step 3: Create Oracle iSurvey and assign created Oracle Script to it

Step 4: Configure iSupplier onboarding profile by enabling the questionnaire

Step 5: Testing iSurvey from iSupplier portal

Step 6: View prospective supplier registration

Step 7: Reviewing iSurvey Responses

All steps are presented in this video.

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 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