Tuesday, July 21, 2015

Oracle iStore Multi Customer Access


Goal:
iStore business (B2B) user who can access multiple customer accounts which is also known as Multi customer Access  

Solution:

With the Multi customer Access feature, an iStore B2B user can view and place orders on behalf of multiple customers using a single login id. The B2B user can log in to the iStore Customer application and view or place orders for their default customer, and then use the switch customer interface in the Welcome Bin to view or place orders for another customer.

iStore: Multi Customer Access Setup

Profile Option Name
Site Level
IBE : Multi customer Access
Yes
IBE: Use Welcome Bin
Yes
HZ: Enable DQM Party Search
Yes
DQM Match Rule for Online Duplicate Identification
SAMPLE: SIMILAR_PERSON
HZ: Duplicate Allowed
No
HZ: Enable Duplicate Prevention at Party Creation
Person or Organization
HZ: Match Rule for Contact Duplicate Prevention
SAMPLE: SEARCH
HZ: Match Rule for Organization Duplicate Prevention
SAMPLE: SEARCH
HZ: Match Rule for Person Duplicate Prevention
SAMPLE: SEARCH

Run the below concurrent programs

"DQM Compile Match Rules"
"DQM Staging Program" with option STAGE_ALL_DATA
"DQM Synchronization Program"
"DQM Index Optimization Program"

STEP 1:
Identify the existing customer that employs the existing contact, this will be known as the “from Customer Contact”.
Navigation
·         On the Customers Tab, perform a simple search (Customer Type of Organization ) for the Customer that has an existing relationship with the contact
·         Select the Customer radio button for the desired Customer after performing the search
·         The available Account(s) for the Customer will be displayed below
·         Click on the Account Details icon on the Customer Search page


STEP 2: Identify the “from Customer Contact” for a specific Account:
Navigation
·         On the Receivables – Account Details Page, Click on the Communications Tab
·         A list of Account Contacts for the Customer will be displayed
·         Determine the Account Contact that you want to use as the “from Customer Contact”
·         Click on the Details icon for that Account Contact On the Receivables – Account Contact Details Page, note the following Contact Information:
o   First Name
o   Last Name
o   Job Title
o   Address (Street, City, State, Postal Code, Country)
·         Now that you have identified the “from Customer Contact”, you will assign them as the “to Customer Contact”

STEP 3: Create a new relationship between the “from Customer Contact” and an existing Customer:
Navigation
·         Back on the Customers Tab, perform a simple search (Customer Type of Organization ) for an existing Customer  that will be receiving the new relationship (of Self Service) with the “from Customer Contact”
·         Select the Customer radio button for the desired Customer after performing the search; this will be known as the “to Customer”
·         The available Account(s) for the “to Customer” will be displayed below
·         Click on the Account Details icon on the Customer Search page

STEP 4: Identify a specific Account for the “to Customer”:
Navigation
·         On the Receivables – Account Details Page, Click on the Communications Tab
Click on the Create Contact button
·         Enter the IDENTICAL information that was noted for the “from Customer Contact”, that being:
o   First Name
o   Last Name
o   Job Title
o   Address (Street, City, State, Postal Code, Country)
·         Click on the Apply button
·         You will be prompted on the next page, which is the Create Account Contact page to either Create a New Person or to Use an Existing Person
·         Click on the Use Existing Person button and the Select Focus region will appear
·         Click on the Select Focus radio button which corresponds to the “from Customer Contact”

STEP 5: Assign our “to Customer Contact” with a Self Service Contact Role:
Navigation
·         Once we add the Contact to the “to Customer ” there is  a new relationship
·         To create a Contact Role, on the Account Contact page for the “to Customer ”, click on the Add Another Role button in the Contact Roles region.
·         From the Role drop-down menu, select “Self Service User”
·         Click on the Apply button; this saves the role for the Contact
·         You will be navigated to the Account Detail page
·         Click on the Apply button; this saves the Account and Contact role relationship for the “to Customer ”

STEP 6: Verifying the data setup for a “Self Service” Contact Relationship

Using an Oracle Customers Online (OCO) as a reference application, you can perform the following:-

Navigation 
Oracle Customers Online Superuser ->In the Organizations Search enter the “to Customer ” from the prior steps and click on the Go button ->Click on the link for the “to Customer ”->Click on the Visualize Relationships button->Once the screen has launched click on "Has Contact"->You should now see the newly created user in the list
Note that the “from Customer Contact” now has a Self Service Role and relationship with the “to Customer 

STEP 7: Check that the two customer accounts have a relationship 
 In  Oracle Customers Online (OCO) query the Customer ->Select Update->Select Accounts hyperlink
Select Account number > Update ->Scroll down to Account Relationships
·         There must be an entry here for the Account number
·         if not select the Create Relationship button and apply



Oracle e-Business Suite Daily Business Intelligence

Oracle e-Business Suite Daily Business Intelligence

Goal:
To Set up Daily Business Intelligence for Oracle e-Business Suite Modules

Step 1:

  •  Profile Options :
    • OM: DBI Installation – Y (Site Level)
    • EDW : Degree of Parallelism on the source – 1 (Site Level)
    • ISC: Shipping/Transportation Execution DBI Installation – Yes (Site Level)
Step 2:

  • Setup Global Parameters
    • Daily Business Intelligence Administrator -> Global Parameters
Step 3:
Grant Organization Access to Daily Supply Chain Intelligence, Daily Business Intelligence Administrator and Development Manager Responsibility
Inventory -> Set up -> Organizations -> Organization Access ->

Step 4:
To use dashboards effectively, you must ensure that the Enterprise Calendar has periods defined from the Global Start Date to any future dated transactions that you will report on.

For example, if you are reporting on future dated transactions such as budgets and forecasts, periods must be defined for all possible future and back dated transactions.

GL - Setup- Financials - Calendars- Search for Accounting Query for the calendar value you found in the DBI Global Parameters for enterprise calendar Check for missing periods or lacks between periods

Step 5:
  • Setup Reporting UOM
    • Navigation - > Setup->Supply Chain -> Reporting Units of Measure
Step 6:
  • Assign the Item Category to the Item in Item Master
  • Run the Initial or Incremental Load in DBI

How to Remove Customer Tax Exemption Information in Oracle iStore Billing Page?

How to Remove Customer Tax Exemption Information in iStore Billing Page?

Uncheck the “Allow Override and Entry of Customer Exemptions”

Navigation ->E-Biz Tax Module > Defaults and Controls > Select Operating Unit and Application Receivables > Application Tax Options


Note : If you do not have any value for your Operating Unit and Receivables Application, create a dummy a dummy rule with no values and uncheck the checkbox.



Oracle e-Business Suite R12 - How to turn on address validation ?

How to Turn On Address Validation in Oracle e-Business Suite R12
Responsibility: Trading Community Manager
Navigation: Trading Community > Administration > Geography Hierarchy

  • In the Geography Hierarchy: Countries page, search for Country Code 'US'
  • Click on 'Manage Validations' icon.
  • Under 'Geography Mapping and Validations' section, check the Tax Validation and/or Geography Validation for State, County, City, Postal Code based on your business need.
  • Under 'Geography Validation Control' section, set the Geography Validation Level for Country.
  • Click Apply, and re-test.

Oracle iStore On Hand Availability Check

Basic ATP Setups for iStore to Show On Hand Availability
In order to display the On Hand quantity in Oracle iStore below are the minimum setups has to be done

Step 1 : Create ATP Rule

Step 2 : Attach ATP rule to the Item

Step 3: Set the Profile Options
·         INV:Capable to Promise - ATP Based on Collected Data - Site Level
·         OM: AutoSchedule - Yes - Site
·         OM: Auto Push Group Date - No - Site
·         ASO : Default Ship From Org - XYZ Warehouse - iStore (Application)
·         ASO: Use Sourcing Rule set - No - Site

Step 4: Create Instance
Navigation-> Order Management Super User ->Scheduling ->ATP and Scheduling Setup ->Instances
·         Instance Code : TST
·         Instance Type : Discrete
·         Version : 12.1
·         Enable Flag : Yes
·         Allow ATP : yes
·         Allow Releases : Yes
·         GMT Difference : -5
·         Currency : USD

Organizations :
·         Org : XYZ (Child Org)
·         Type : None
·         Enabled : Yes
·         Demand Planning Enabled : Yes
·         Collection Group : CG1

Org : ABC (Master Org)
·         Type : None
·         Enabled : Yes
·         Demand Planning Enabled : Yes
·         Collection Group : CG2


Step 5 : Create ATP Partitions
Navigation - > Advanced Planning Administrator - >View-> Request-> Run Create ATP Partitions

Step 6 : Defaulting Rule Change
·         Change Request Date at Order Line Level
·         Change Latest Acceptable Date at Order Line Level

Step 7 : OM System Parameters
·         Latest Acceptable Date : Honor the Latest Acceptable Date

Step 8 : Run Data Collection


Monday, July 20, 2015

Oracle eBusiness Suite R12 - User Management (UMX) – Proxy User Functionality





R12 - User Management (UMX) – Proxy User Functionality

Overview

The purpose of this document is to give a brief insight into the new feature of R12 that is “Proxy User” in User Management (UMX)

Requirement

To allow a user to specify a proxy who can act on their behalf when he/she is on vacation. The Proxy user should perform all the functions of the delegator (e.g. submit and review reports, approve documents, perform iProcurement transactions and so on) for the specified for date ranges.

Pre-requisites
  1. Have access to or have installed licensed version of Oracle Applications R12
  2. Having access to User Management (UMX)
Assumptions

The section lists the complete set of assumptions that need to be considered along with the other constituents of this solution.
  1. The Environment is a vision instance of Oracle Applications version R12
  2. The effort involved in localizing this for the end-client and deploying may vary from one client environment to another.
Activities

To illustrate, I'll refer to two types of E-Business suite Users:

OPERATIONS - This is the User who will delegate responsibility to perform transactions on their behalf to the user “BALA”.

BALA - This is the user who will sign on to the E-Business suite and access the responsibilities of the user “Operations”.

Step 1:
  • Connect to the R12 E-Business Suite as any User (e.g. SYSADMIN) with the responsibility 'User Management' and open the 'Users' form.
  • Search for the user name of the Operations.
  • Assign the role 'Manage Proxies' to this User
 



Step 2:

Now connect as the user “OPERATIONS “and navigate to the
'Preferences' form. Click on the 'Manage Proxies' option and then, the 'Add People' button. This will allow you to add the User Names of those Users that you wish to perform actions on your behalf. Now add the user names of all Users that you wish to assume your responsibilities.

In my example, I add the user name “BALA”.Apply the changes and exit the E-Business suite.
 

Step 3:

Now Login with the User Name “BALA”

Note - the new options 'Switch User' and 'Return to Self' available:

As its’ name suggests 'Switch User' is the button that allows you to 'become' the other User without having to enter their password i.e. BALA can become OPERATIONS and access their responsibility list.


Step 4:

Select the 'People Icon' to switch your user to that of OPERATIONS



Step 5:

Now you are in home page of the OPERATIONS, can access any of their current responsibilities and can perform action on their behalf in the E-Business that they themselves are allowed to perform. To return to the original user session, select the option 'Return to Self'.



The following are the salient features
  1. Provides the delegator the ability to grant/revoke the proxy privilege to individuals
  2. Provide a mechanism throughout the application’s framework where the user can access the proxy switcher feature
  3. Provide a mechanism throughout the application’s framework which indicates to the user that they are acting as a proxy
  4. One of the vital benefit of proxy user is the ability to delegate proxy authority provides great security controls and Granular control of proxy authority is provided i.e delegate authority can be specified for date ranges
  5. Simple approach with the tangible end deliverables clearly identified for each stage