Oracle Identity Management (OIM) is an integrated system of business processes, policies and technologies that enable organizations to facilitate and control their users' access to critical online applications and resources -- while protecting confidential personal and business information from unauthorized users. It supports user authentication, authorization and provisioning.OIM suite of products now has been extended to support the Oracle R12 E-Business Suite of ERP applications

In summary, Oracle Identity Management includes the following products and applications:

• Oracle Internet Directory (OID): Oracle Internet Directory is an LDAP server for authentication between Oracle R12 EBS and third party LDAP servers such as Microsoft Active Directory.
• Oracle Access Manager (OAM): OAM provides additional security authentication for identity management which basically replacing previous Oracle Single Sign On (OSSO) as future solution for single sign on authentication product.
• Oracle Adaptive Access Manager (OAAM) :Oracle Adaptive Access Manager (OAAM) is the complementary identity management solution which is part of the Oracle Identity Management (OIM) suite of Oracle Fusion Middleware products.
• Oracle Virtual Directory (OVD) :Oracle Virtual Directory provides LDAP virtualization directory services with Oracle Identity Management products to authenticate LDAP resources between Oracle database and Oracle EBS applications. As such OVD functions to
  integrate Oracle applications in a secure environment.

When you are trying to upload any attachment in EBS via iProc or iexpense or isupplier or istore, Take a note there is no limit to the file size of an attachment; however, the 2-4 GB limitation of a LOB could be considered the limitation of an attachment file.

You can also limit the file size by setting the Profile Option on site level:

'Upload File Size Limit'

Normally, any file upload within OA Framework observes this profile option value.

The 'Upload File Size Limit' profile option is being interpreted as bytes instead of kilobytes by the forms application.This profile option is being interpreted correctly by the framework interface but not interpreted correctly via the forms interface.

It specifies the maximum allowable file size in KB for uploaded attachments.For example, if the limit is 2MB, this value should be set to 2000.

Here is workaround for automatic/mass CCID generation or insertion of new CCID’s in GL_CODE_COMBINATIONS Table, when new values in Accounting Flexfield Segment are created, EXCEPT “Dynamic Insert” option activated .

you can use the api (function) -> fnd_flex_ext.get_ccid to create the ccid.

If the combination already exists, it returns the existing ccid else creates a new one and returns the id. Explicit commit command needs to be executed after calling this function.

Use below function which returns the CCID if it is exist and create the CCID if it doesn't exist in the application

 
<pre>fnd_flex_ext.get_ccid(application_short_name => 'SQLGL', 
                      key_flex_code          =>'GL#', 
                      structure_number       =>l_coa_id, 
                      validation_date        =>to_char(SYSDATE,apps.fnd_flex_ext.date_format), 
                      concatenated_segments  =>l_account); 
 

Read the rest of this entry »

If you are working in big user environment, user always complain there request get stuck or takes time to start processing. Majority of time Support team cann't do anything, unless waiting or asking DBA to check the server performance.

There is couple of option you can try , if you know a demanding user and there request name( Concurrent Program) he/she always want in periority.

Options 1: If you know what particular program user required in priority.

In oracle EBS you need to set the priority of specific users so that when they run specific reports, those reports should be run on high priority. The steps are very simple:

1. Go to Sysadmin Responsibility and go to menu Profile > System.
2. Make sure Site and User boxes are checked.
3. Select the user name for the user for whom you want to increase the priority
4. Enter the following within the Profile box and click on Find: Concurrent:Request Priority
5. Change the priority for the user as you see fit (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Options 2: You know the Program name, and want to make execution in priority

The steps are very simple:

1. Login system administrator /Application developer and go to define concurrent screen
   Under Concurrent >> Program >> Define
2. Find the Program name whose priority you wish to change for ex. "Payable Transfer to GL"
3. On this screen you can set priority of this request by entering value in "Priority" field( as mark in red) (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Oracle definition for Priority

Priority is used to indicate the priority that the concurrent request will be assigned when it is submitted. If you do not assign a priority, the user's profile option Concurrent:Priority sets the request's priority at submission.

Profile : Concurrent:Request Priority

This displays the default priority number for your concurrent requests. Only a system administrator can change your request priority.

Requests normally run according to start time, on a "first-submitted, first-run" basis. Priority overrides request start time. A higher priority request starts before an earlier request.

Priorities range from 1 (highest) to 99 (lowest). The standard default is 50.

Users can see this profile option, but they cannot update it. This profile option is visible and updatable at all four levels.

Here is quick compare with two process modeling tool available in oracle.

Suggested Read

• Oracle Workflow: Inside View

Architecture Assessment is a thorough and repeatable process to evaluate changed business requirements and assess their impact/risk to System Architecture:

It involve evaluation of

• Business Architecture-Business requirement gap analysis
• Application Architecture-Application Design & Frameworks
• Information Architecture -System Data Model and Data Migration
• Technical Architecture-Infrastructure, Configuration Management and Security

Read this:

• KNOW WHAT IS SUPPLY CHAIN MANAGEMENT (SCM)? : An Overview
• SCM Subsystem

This article is an easy guide for Techno-functional consultant to understand SCM from Implementation as well as Oracle Application product Prospective.Lets start the topic with some of high points of earlier post .

• As mention in earlier post a Supply Chain is a network of retailers, distributors, transporters, storage facilities and suppliers that participate in the sale, delivery and production of a particular product.
  • Make a note a supply chain is product specific, not company specific
• Supply chain management (SCM) is a systematic approach to manage the entire flow of information, materials, and services from raw material suppliers through factories and warehouses to the end customer.
• Moreover , SCM involves the flows of material, information and finance in a network consisting of customers,suppliers, manufacturers, and distributors.
• You should be clear with Flow that SCM can manage :
  • The flow of actual materials, the top middle bars
    • From suppliers : flows of raw materials, intermediate products, finished goods
    • Reverse material flows : returns, repairs, servicing, recycling, disposal
  • and the information flows
    • From suppliers : manufacturing capacity, delivery schedules, promotions they have going
    • Reverse flows : sales, orders, inventory, quality, promotions
  • And finally, there are financial flows:
    • From suppliers: Credits, consignment, payment terms, invoice
    • Reverse Flows : payments, consignment
• Supply Chain Management is the management of the entire value-added chain, from the supplier to manufacturer right through to the retailer and the final customer.
• SCM has three primary goals: Reduce inventory, increase the transaction speed by exchanging data in real-time, and increase sales by implementing customer requirements more efficiently
• The need for SCM is because effective Supply Chain Mgt. is the next logical step towards increased profits and market share.
• Supply Chain Management (SCM) in line manager prospective is "let's-keep-things-moving-efficiently".

Read the rest of this entry »

It was request from one of reader to provide some information for new organization Hierarchy model between two release of 11i and R12.Therefore invite you to run through the following diagram as below with some basics.

Read the rest of this entry »

Read this

• Managing Cash , EBS and SWIFT

Whenever the Bank Intergation is required , the very first term would come in mind is SWIFT , a very similar way as EDI sort of messaging servics that Financial sectors are using .So let explore what is SWIFT and how many of these can be potenially targetted for Integration .

What is a S.W.I.F.T?

S.W.I.F.T. (or SWIFT) stands for Society for Worldwide Interbank Financial Telecommunication. It is a non-profit organization comprised of member financial institutions. It was established in 1973 by European bankers who needed a more efficient and secure system for inter bank communications and transfer of funds and securities. Until then, all inter bank communications were by telephone, telex, courier, or mail.

Swift Messages

SWIFT messages are preset and referred to by category numbers called MT numbers. Through this network (a.k.a. SWIFTnet) information can be exchanged using special crafted messages known as Message-Types (MT).

Read the rest of this entry »

MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called "Multi-Org Preferences".

What is "Multi-Org Preferences"?

Multi-Org Preferences allows you to control the list of operating units to which you have access.

Lets say you have around 20 OU's divided into three major Region (North America, Europe and APAC). Lets say within APAC region you are responsible for all 7 OU's within Region.

Read the rest of this entry »