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