Monthly Archives: October 2008

Gallery

Happy Diwali – Enjoy…


To All Friends & Readers, We are taking vacations and will be back again after diwali. Wishing everyone a great diwali and prosperous happy new year. Let’s take some break and enjoy. We will continue our knowledge journey :-) KnowOracle … Continue reading

Shivmohan – Oracle 11i Multi Org – Definition


What is the MultiOrg and what is it used for?

MultiOrg or Multiple Organizations Architecture allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit’s transaction data separate and secure. Further all organizations can share some master data like supplier, customer, bank, AFF, payment terms, price lists etc.

Use the following query to determine if MuliOrg is intalled:

select multi_org_flag from fnd_product_groups;

 

Thanks – Shivmohan Purohit

Aside

Oracle Financials, part of Oracle E-Business Suite, helps financial officers create an information-driven enterprise that synchronizes data centrally from all systems-including third-party systems-so financial information is consistently collected, calculated, analyzed, and stored, ensuring data integrity while reducing costs. This approach … Continue reading

NoetixViews for Oracle E-Business Suite


NoetixViews for Oracle E-Business Suite


NoetixViews includes an extensive set of reporting objects (metadata) that deliver best-practice business views of the application’s database using an expert blend of table joins, cross operational functionality, customizations and indexes.

Ø      Business views for Oracle Financials, Order Management, Procurement, Projects, Discrete and Process Manufacturing, Human Resources, Grants, Service, Advanced Supply Chain Planning, and Enterprise Asset Management.

Ø      Metadata tailored to your configuration of Business Groups, Sets of Books, Operating Units, and Inventory Organizations.

Ø      Basic views for reports mapped to the Oracle screens; value-added views that integrate data from more complex business processes; and cross-functional views that integrate data from multiple application modules for full business process end-to-end reporting.

Ø      Unique features include special columns for key and descriptive flexfields, and lookups; support for multiple currencies and language translations; and special primary and foreign key columns for joining multiple views together for advanced reporting.

Ø      Built-in security seamlessly integrates with the data access rules of your Oracle responsibilities. Also included is support for module-specific data access controls such as GL flexfield security rules and HR security profiles.

This set of views enhances the following AOL components:

- Audit Trail

- Common Quick Picks

- Concurrent Manager Rules

- Concurrent Program Executables

- Concurrent Programs

- Currencies

- Database Conflicts in Concurrent Processing

- Descriptive Flexfields and Segments

- Flexfield Hierarchies, Values and Security

- Flexfield and Segment Qualifiers

- Key Flexfield Cross-Validation Rules

- Indexes

- Languages

- Printers

- Profile Options

- Report Request Groups

- Requests and Arguments

- Responsibilities

- Security

- Shorthand Flexfield Aliases

 

Thanks – shivmohan purohit

Gallery

New feature added – Email subscription & more….


Friends, you must have observe, we have added few useful feature, first like to know your view on header image, we tried to outline the purpose and approach about this site. also we encourage you to participate and enroll yourself … Continue reading

Oracle Expert – Mandeep Dhami


Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Mandeep Dhami, An Oracle Application experts in his area. I encourage you all to ask ur query/ question to him.

Name

Mandeep Dhami

Expertise

Module: Payables, Assets, Internet Expense and GL

Organization

Current: Merrill Lynch

Past: J.P. Morgan Chase

Contacts

Email: mandeepdhami4u@hotmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I have just got into the world of Oracle Professionals, working as Functional Consultant on Payable, Assets, Internet Expense and GL modules. So far I have been involved in implementing the above modules of Oracle across various locations in Asia Pacific region. I have been involved from operations side giving requirements to the deployment team, who then sets up the system and then I get involved in doing System Integration Testing (SIT). Once SIT is successfully done we get the same testing done by end users as part of Users Acceptance Testing (UAT). This also involves giving training and preparing training material for the end users.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: It will be too early for me to comment on this as I am quit novice in this role. But whatever I have experienced so far I can say that the functional consultant should have good knowledge about the working of various modules from end users perspective.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Financials Modules.

Ans:  What accounting entries are generated when an invoice is entered and paid?

What’s the difference between cross validation rule and security rule?

4.      What is your favorite Oracle Applications modules, share some of your interesting professional work experience.

Ans: My favorite module is Payables. In terms of interesting experience I can recollect one when implementing oracle payables for one of the locations where they were giving cash advance to employee. This was also a new learning for me. I got the solution for the same after consultation with my colleagues from the team. The real problem was to sale this solution to the location as first of all this application was new for them and this functionality was to be used by them only in the region. It took couple of training sessions with detailed flow chart and training material to get them agree to the solution suggested.

5.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I would say that the professional should have good knowledge about the modules they are working on and should always strive to be up to date with latest happenings on their areas of work. I would also suggest visiting such blog (http://knoworacle.wordpress.com/) which are full of information and knowledge.

6.      Your feedback on Knoworacle.wordpress.com

Ans: Very good initiative by you to share knowledge on Oracle. There are various articles on different modules of Oracle and all these is from your own practical experience which makes this initiative all that more special, important and accurate.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Gallery

Let’s join – learn and share together with knowOracle


       As an Individual, I can see you can join and participate in following 5 levels with KnowOracle and you can start with level 1 and based on your interest you can explore more, here are some detail as follows … Continue reading