My Sessions at the COLLABORATE-15 Conference

COLLABORATE-15 My OAUG Forum Sessions in Mandalay Bay, Las Vegas from April 12th through 16th 2015:

 

Session 1:

10084: OAUG Oracle Business Intelligence-Big Data Special Interest Group (OBI-BD SIG)

Sun. April 12| 1:00 PM - 2:00 PM | Room Jasmine C

I will be doing a quick demo on BIMAD for Fusion Applications in the SIG meeting. 

Don’t go Mad, use BI MAD

Lakshmi Sampath, ERP Cloud Evangelist, Global Sales Engineering, Oracle

Mobile App Designer is an amazing application that enables anyone to create beautiful multi-touch information-driven applications with rich interaction, rich visualization, and rich media, for mobile devices such as iPhone, iPad, Android phone and tablet, Windows, and more.  Lakshmi will present a brief overview and demonstrate the power of BI MAD’s rapid mobile report creation and deployment capabilities in a quick demo to demonstrate the power of Oracle’s rich BI framework that has become the BI fabric behind all Oracle Cloud solutions.

---

Session 2:

I will be doing a quick demo on Fusion Financials Close Monitor and Period Close towards the end of this presentation.

10158: Finance Close: Get your time back.

Sun. April 12| 2:15 PM - 3:15 PM | Room South Seas J

Pankaj Chaukade, DELL and Lakshmi Sampath, ORACLE

This paper will highlight issues encountered while closing books. Most of the folks are well aware of the pain of closing the finance books each month and quarter. This paper will shed the light on how to make your month end close smoother without any pain but by gaining a lot of expertise after following an end to end process implemented at Dell. Dell is one of the largest Oracle application implementers in the world and we use almost all flavors of the various modules to meet the business desired goals. We will also cover those challenges encountered and lessons learned during such processes.

---

Session 3:

10063: OAUG Cloud ERP SIG

Tue. April 14| 11:00 AM - 12:00 PM | Room Reef E

Agenda:

1. Introduction to the SIG (Padam Bansal and Shince Francis, PWC)
2. Upcoming Webinar Presentations on Cloud ERP
3. Don’t Administer: Innovate.. with Oracle ERP Cloud (Brent Grech & Lakshmi Sampath, Oracle)
4. Open Questions

If you are an Oracle EBS Customer or interested in knowing about the latest and the greatest in Fusion Applications, you don’t want to miss our SIG Meeting.
You will not only become a part of the future direction for ERP Cloud, but also an information repository for your customer in assisting them help the product for the future direction.

Don’t Administer: Innovate…with the Oracle ERP Cloud

Brent Grech, VP, Fusion Applications & Lakshmi Sampath, ERP Cloud Evangelist, Oracle

Imagine how many projects you could get done if you only didn’t have to worry about hardware upgrades and failures, database and application patching, integration failures and the other painful pitfalls experienced when managing your own enterprise software implementation. How many projects has your organization put to the side, heavily reduced scope or have simply failed due to resources getting pulled away to manage your internal systems?

Oracle’s ERP Cloud provides a completely integrated suite of the ERP Applications to run your business. These applications are also natively integrated with Oracle Sales and HCM cloud services which helps eliminates the integration overhead of synchronizing employees, sales data and more. Oracle ERP Cloud is extensible through the Oracle Platform as a Service, allowing our customers to build Java and Database applications rapidly that enables our customers to innovate and leverage the information in Oracle Cloud Applications, Customer on Premise Solutions. Brent Grech, Vice President, Fusion Applications and Cloud demonstration services and Lakshmi Sampath, ERP Cloud evangelist will present a brief overview of the Oracle Cloud and available services, followed by an overview of each ERP Cloud application, and supported by a brief demonstration to give you a sense of the important themes of the Oracle ERP Cloud, Social, Integrated and Insightful.

Session 4:

10096: Central States OAUG

Tue. April 14| 4:30 PM - 5:30 PM | Room Breakers C

We will be doing a brief presentation on On-premise vs Cloud differences, Oracle ERP Cloud/HCM Cloud/CRM Cloud Integrated demo flow, talk about the BI strategy in Fusion Applications and so on.

Session 5: Full One hour session on ERP Cloud (Come learn about Fusion Financials, Fusion Procurement, Fusion Supply Chain, Fusion PPM and co-existence strategies)

10595: Leave the Crowd: Join the Cloud

Thu. April 16| 8:30 AM - 9:30 AM | Room Jasmine C

Lakshmi Sampath, ERP Cloud Evangelist and Brent Grech, VP, Fusion Apps, Oracle

This paper will talk about all the latest features and functionality in Oracle ERP Cloud (a.k.a.) Fusion Applications –Fusion Financials, Fusion Projects Portfolio Management (PPM), Fusion Procurement and Fusion Supply Chain Management (SCM). This presentation will also enlighten about the co-existence strategy available for EBS with Fusion Applications - Fusion Revenue Management, Fusion Accounting Hub, Fusion Reporting Cloud and Fusion DOO. Also, the enhancements, value proposition of ERP Cloud will be covered in Detail. A brief Demo of the various co-existence scenarios of Fusion Applications with EBS will be covered.

Fusion Applications Release 9 (Oracle Cloud R9) - What's new

All,

As you know Oracle just released Fusion Applications Release 9 (AKA - Oracle Cloud R9)

Thanks to Oracle Product strategy, New Public content is available on Oracle Cloud R9 .

 

For each Pillar, Human Capital Management, Sales, Financials, Procurement, Project Portfolio Management, Supply Chain Management,  You will find :

 

1) Release Content Documents

2) What's new in R9 Documents and

3) Direct access to Corporate Videos presenting "What is new in R9" by Product Strategy Managers. 

 

Click on the following link for the Oracle Cloud R9 documents.

 http://cloud.oracle.com/saasreadiness

Also,  New Oracle Corp Youtube Channels have been created especially for Release 9 (R9).
 

• Oracle Readiness Youtube Channel, featuring all "What's new in R9" videos by pillar


• Oracle Applications Tutorials for Release 9 Youtube Channel, featuring tutorials by pillar on new functionalities

 

Whether you are trying to understand new functionality in Fusion Apps or trying to evaluate Fusion Apps for your customer needs, you will find this information extremely helpful.

Thanks and Regards
Lakshmi

 

My Presentations/Panel at the Oracle Openworld 2014 Conference

Here are the two panels I will be speaking at during the Oracle Openworld 2014.

-----------------------------------------------------------------------------------------

Agenda GL-SIG @ OpenWorld 2014 on Sunday, September 28^th, 11.00am
Location – Moscone W – 3005


Agenda

1. Introduction to the SIG                     
2. Proactive support presentation      
3. Sponsor message (Excel4Apps)      
4. Lakshmi (SLA on Upgrade @ Dell) 
5. David Haimes new functionality     
6. Open questions                                

We will be joined by our Oracle colleagues to tell us about ProActive support and their leading practices to deliver content and help to the Oracle user community.
Excel4Apps will be helping us by sponsoring the meeting at this conference.

In the past many oracle apps customers have looked elsewhere for their reporting needs – until now – see a preview of “Fusion Account Hub Reporting Cloud Service”. See how many finance users are using their favorite tools for reporting – Smartview, Cubes, and related functionality to get their financials.  Fusion Account Hub Reporting Cloud Service is a new subscription service provides out of the box integration with EBS R12 General Ledger for reporting.  This session will provide an introduction to the new service, how it connects, works with EBS data, the reporting capabilities available and what it does and does not support.  Come listen to David Haimes, Senior Director, Financials Product Development t alk about the new service.

Hear what Lakshmi Sampath from Dell has to say about their upgrade to R12. The presentation covers the R12 Upgrade Case-Study at Dell providing details on what happens during upgrade to R12 in various subledgers (PO, AP, AR, PA, FA) with respect to SLA. This presentation will also provide details on strategies for data conversion to SLA model during upgrade, and cover critical lessons learned during the upgrade @ DELL. 

-----------------------------------------------------------------------------------------

When – Sunday, September 28, 2014 – 2:30 pm – 3:15 pm Pacific Time

Where – Moscone West, Room 3007

What – Oracle Business Intelligence-Big Data Special Interest Group Meeting

Attend our Annual OBI-BD SIG OpenWorld meeting to hear real world experiences from our Oracle Business Intelligence & Big Data Customer RoundTable.

Hear from Healthcare, High Technology and other industries how their organizations regarding their Oracle BI & Big Data landscape, challenges and roadmap.                                                           

Participate in the Q & A session to ask your specific Oracle BI & Big Data questions.

Hear Oracle Corporation present ‘How to Get the Most Out of OpenWorld 2014’ from an Oracle Business Intelligence, Analytics & Big Data perspective along with a ‘sneak peek’ at Oracle’s Roadmap & Vision for these exciting subject areas.

Agenda

2:30 – 2:35 pm – Introductions, About the OBI-BD SIG                                                      

2:35 – 2:45 pm – How to Get the Most Out of OpenWorld 2014 regarding Oracle BI, Analytics & Big Data – Oracle Corporation

2:45 – 3:00 pm – Oracle BI, Analytics & Big Data Customer RoundTable

Customer RoundTable speakers from Healthcare, High Tech and other industries discuss their BI and Big Data Landscape & Roadmap – Dell, Humana, Other

3:00 – 3:15 pm – Oracle BI Customer RoundTable

Q & A Session with Audience – Direct your specific BI & Big Data questions to Dell, Humana, Oracle Corporation and/or the OBI-BD SIG Board

-----------------------------------------------------------------------------------------

I will also be attending the IOUC (International Oracle User Committee) meeting - with OAUG Customer Support Council representing the Council as the Vice-Chair. 

Look forward to meeting everyone at the Oracle Openworld. 

Regards

Lakshmi

Subledger Accounting Query to download all SLA Setups - for your BR-100 documentation

Here is a SQL that can be used to download all the information on the Subledger Accounting Setups from Application Accounting Definition to Account Derivation Rule




-- This SQL will pull all the details of Application Accounting Definition all the way from AAD name to ADR (Account Derivation Rule).
-- Two of the Oracle Forms are captured in this query


SELECT distinct A.PRODUCT_RULE_CODE     AAD,
                A.EVENT_CLASS_CODE      Event_Class,
                A.EVENT_TYPE_CODE       Event_Type,
                A.HEADER_DESC_NAME,
                B.line_definition_code  JLD_Code,
                B.Line_definition_name  JLD_Name,
                B.line_definition_desc  JLD_Desc,
                A.HEADER_DESC_TYPE_DSP,
                T.line_definition_code  JLD_CODE,
                T.accounting_line_name  Journal_Line_Type,
                T.description_name      Journal_Line_Description,
                T.accounting_line_code,
                N.segment_rule_name     ADR_NAME,
                N.segment_rule_code     ADR_CODE,
                N.segment_rule_owner,
                N.segment_rule_desc     ADR_DESCRIPTION,
                N.flexfield_segment_num
  FROM apps.xla_prod_header_desc_fvl     A,
              apps.xla_aad_line_defn_assgns_f_v B,
              apps.xla_line_defn_jlt_assgns_f_v T, -- To get all the details of Journal Line Type
              apps.xla_line_defn_adr_assgns_f_v N -- To get all the details of ADR
 WHERE (A.APPLICATION_ID = 140) -- Application_id from FND_APPLICATION.
   and (A.AMB_CONTEXT_CODE = 'DEFAULT')
   and (A.PRODUCT_RULE_TYPE_CODE = 'C')
  -- and (A.PRODUCT_RULE_CODE LIKE 'XXFA_ASSET_AAD')-- If you want Product rule code --specific, write the name here
  -- and (A.ENTITY_CODE = 'TRANSACTIONS') -- IF you want to use the query for just a --particular entity,
   and A.product_rule_code = B.product_rule_code
   and A.application_id = B.application_id
   and A.amb_context_code = B.amb_context_code
   and A.event_class_code = B.event_class_code
   and A.event_type_code = B.event_type_code
   and T.application_id = 140 -- Application_id from FND_APPLICATION.
   and T.application_id = B.application_id
   and T.event_class_code = A.event_class_code
   and B.line_definition_code = T.line_definition_code
   and B.event_class_code = T.event_class_code
   and B.line_definition_code = T.line_definition_code
   and B.event_type_code = T.event_type_code
   and T.event_Class_code = N.event_Class_code
   and T.line_definition_code = N.line_definition_code
   and T.application_id = N.application_id
   and T.line_definition_code = N.line_definition_code
   and T.event_type_code = N.event_type_code
   and N.accounting_line_code = T.accounting_line_code
 order by 2, 3, 5, 10, 11, 16;

My Presentations/Panel at the COLLABORATE-14 Conference

April 7th 2014

1 to 2 PM Pacific

OAUG Oracle Business Intelligence - Big Data SIG Meeting (Customer Round Table)

Level 3, San Polo - 3506

April 8th 2014

6:45 PM Pacific

RadiOAUG powered by Business RadioX

 OAUG Membership Booth #1039 (OAUG Customer Support Council)

April 9th 2014

 2 to 3 PM Pacific

 "How I wish I Knew SLA" - (Oracle Subledger Accounting)

Session ID : 14843

Level 1, Marco Polo - 803



Look forward to meeting you all on tomorrow (7th April 2014)

Regards
Lakshmi

How to view other User's Request in Oracle EBS R12

This is one of the interesting issues I came across during our EBS Upgrade from 11i to R12.1.3

In 11i, All the users can view other's concurrent requests through a simple Profile Option called  'Concurrent: Report Access Level'.  When we assign the above profile option value to Responsibility, all users logging into that Responsibility can view other's requests.

Ofcourse R12 has a lot more security and is based on role based access. Hence, that profile option to allow anyone to view other's requests at the responsibility level is Disabled.

So here is what you need to do to enable the same functionality in R12. I have provided step by step instructions on how to do that.

You will be using the UMX Role based Access Control (RBAC) to control who can view other User's requests.

---------------------------------------------------------------------------------------------------------------------

Step 1:

Login as Sysadmin User (Not responsibility) and Navigate to User Management Responsibility, Click on Users Tab and search for the User Name and then assign Security Administrator, Functional Developer and Functional Administrator  roles to that user .

     Click On Update

  Click on Assign Roles and search for Security Administrator role and assign to the user.

When assigning the role, it will ask for justification. Provide a reason for justification and save.

You will get a confirmation that you have successfully updated the information, but may not see the changes in the application until after the Workflow Background engine's next run.

Assign Functional Developer and Functional Administrator roles to the same user. You need Functional developer role to create new roles.

PLEASE NOTE: User Management is an inherited role from Security Administrator role. User Management will only work if you have the Security Administrator role assigned to the user.

 

Step 2:

 The steps described in Step 2  is a one time step 

2(a) Creation of Object Instance Set Code

Login as Functional Developer and click on objects (You can do this either using Sysadmin user or your own user who has the Functional Developer role)

Click on objects tab, then search for 'concurrent requests' in the name and click go as shown below:

Click on Concurrent Requests link above (Not Update)

 Click on Create Instance Set and create a new instance set as follows. Make sure your object instance set code is a single word without space.



Enter the following as your predicate:
&TABLE_ALIAS.request_id in (select cr.request_id from fnd_concurrent_requests cr where cr.responsibility_id = fnd_global.resp_id and cr.responsibility_application_id = fnd_global.resp_appl_id)

 Click on Apply and save. 

You will get a confirmation that your object instance set is created successfully.

2(b)  Creation of Role and Grant

     (i)  Creation of Role

Now Login as User Management, Role and Role inheritance

Click on Create Role in the above screen and create a new role as follows:

Click on save, then Click on Create Grant

ii) Creation of Grant - 

Step 1 of 4

Click Next to go to the next step

Step 2 of 4

Click the Data context type as Instance set and search for your instance set you created a few minutes ago (in this case XX Dell View Other Requests)

Step 3 of 4

Click Next and in the screen select set as "Request Operations"

Step 4 of 4

Click Next
Click on Finish. You will get a confirmation as below.

 Now the Role to view other user's requests with the grant is fully created.
-----------------------------------------------------------------------------------------------------------------------

Step3:

This is the only step you will be repeating to assign other users the ability to view other's requests.  

a)  Login to User Management Responsibility.

Navigate to Users, Search for the user whom you are planning to assign the role to view other's requests.

b) Click on Update, and Click on Assign Roles

c)  Search for the Role that you created in Step 2 as shown below. Then click Select 

d) The form will ask you for Justification. Enter a justification and click on save.

Now the User Vishal_Pande has the access to view other user's concurrent requests. 

 --------------------------------------------------------------------------------------------------------------------


Hope you find this information useful. Please feel free to drop a note if you have any questions on this.

Oracle Releases R12.2 version for Oracle EBS (Much awaited Release)

Yesterday Oracle Corporation released Oracle E-Business Suite 12.2 - The next version of Oracle EBS 12.1.3.

We all have been waiting for this Release for quite sometime. One of the significant advantage of  EBS 12.2 is that it includes Online Patching. We don't need maintenance downtimes for applying any of our patches.

Also there are some significant enhancements across the entire E-Business Suite. For e.g. Oracle Financials Integration with Fusion Accounting Hub, Enhanced cost breakdown structure and labor costing with Oracle Projects, New subscription services solution with Oracle Order Management, Improved User Interface with Oracle Supplier Lifecycle Management etc.

Here is a link to Oracle's Release Announcement:

http://www.oracle.com/us/corporate/press/2016931


Thanks and Regards
Lakshmi