| April 3, 2007 |
 |
- Session 1
April 3, 2007 9:00 AM U.S. Eastern (New York) Time
Measuring Recruitment Effectiveness: A Public Sector Dashboard
Newark Public Schools has instituted a management by metrics program that helps it focus human and financial resources on recruitment sources and events that not only result high numbers of applicants, but those that result in quality hires.
As part of its recent implementation of eRecruit and Recruit Workforce, NPS initiated a strategic recruiting program to identify its most productive instructional referral sources. The resulting dashboards allow the HR organization to understand yields per source, associated costs of each applicant, candidate, offer and hire, and the time to fill and time to start for each approved job requisition.
The presentation concludes with the lessons NPS learned about striking the right balance between creating a new culture around measurements and choosing the best measurements.
Available Seats: 24
Presenter, Company: David Downey, CherryRoad Technologies Inc.
- Session 2
April 3, 2007 12:00 PM U.S. Eastern (New York) Time
Planning Implementation of Oracle Product Lifecycle Management
What is Oracle PLM Product Lifecycle Management or Advance Product Catalog? What does it mean to a project manager or user of Oracle E-Business Suite? How do I plan to implement it? What parts of my project are affected by this module? These questions and more can be answered with a simple flow through of what PLM functionality entails and how this module helps me through the implementation and management of other modules that it integrates with.
Available Seats: 13
Presenter, Company: Bob Barnett, McKinley-Alexandra LLC
- Session 3
April 3, 2007 5:00 PM U.S. Eastern (New York) Time
Measuring Recruitment Effectiveness: A Public Sector Dashboard
Newark Public Schools has instituted a management by metrics program that helps it focus human and financial resources on recruitment sources and events that not only result high numbers of applicants, but those that result in quality hires.
As part of its recent implementation of eRecruit and Recruit Workforce, NPS initiated a strategic recruiting program to identify its most productive instructional referral sources. The resulting dashboards allow the HR organization to understand yields per source, associated costs of each applicant, candidate, offer and hire, and the time to fill and time to start for each approved job requisition.
The presentation concludes with the lessons NPS learned about striking the right balance between creating a new culture around measurements and choosing the best measurements.
Available Seats: 24
Presenter, Company: David Downey, CherryRoad Technologies Inc.
- Session 4
April 3, 2007 8:00 PM U.S. Eastern (New York) Time
Planning Implementation of Oracle Product Lifecycle Management
What is Oracle PLM Product Lifecycle Management or Advance Product Catalog? What does it mean to a project manager or user of Oracle E-Business Suite? How do I plan to implement it? What parts of my project are affected by this module? These questions and more can be answered with a simple flow through of what PLM functionality entails and how this module helps me through the implementation and management of other modules that it integrates with.
Available Seats: 20
Presenter, Company: Bob Barnett, McKinley-Alexandra LLC
 | | April 10, 2007 |
|
- Session 1
April 10, 2007 9:00 AM U.S. Eastern (New York) Time
Practical help for the “SOXed-in” Oracle Apps DBA
Currently, there is a great deal of confusion around terms such as “SOX compliance”, “IT Controls”, “Section 404”, “SOD” and “APD”. While IT folks at all levels are understandably apprehensive, “SOXed-in” Oracle Applications DBAs are doubly so! As holders of the “keys to the kingdom”, Apps DBAs are under intense pressure to conform to various controls as well as provide records of these controls on an ongoing basis. The objective of this paper is to provide some reasonable starting points for the hard pressed DBA to start working out some common issues that we have encountered while striving to conform to these standards and rulings. We will start briefly with an explanation of what these terms actually mean for the DBAs’ activities, and more importantly, show how these controls, checks and balances translates to scripts, triggers, alerts, reports and audit trails at the technical level.
The Oracle Applications’ AOL and FND layers stores a lot of information about the security, integrity and auditability of the financial data that is held within an Oracle E-Business Suite database. This includes information pertaining to all the access privileges required by users as well as organizational and structural information that defines what functions, forms and reports can be assessed using these privileges. This information often needs to be extracted for review during the initial discovery phases of a remediation, and the DBA is often tasked to provide this information in an easily usable format that can be manipulated using spreadsheets. Using scripts and SQL, we will look at how this control data is structured in FND tables and how it can be made available in a easily usable format, rather than rely on cumbersome, inflexible Oracle reports or even screen shots from Oracle forms.
Once discovery is complete, the DBA may be tasked with remediation which usually includes an en-masse change of responsibilities. Again, knowledge of underlying FND functions can come to the rescue and we will look at some examples of how this can be done.
Remediation is just half the story. The Apps DBA needs to monitor compliance in many forms including auditing, access control and reporting of violations. We will tackle this issue using a three-pronged approach. First, we will see how Database level triggers can be used to both track and control logins to the database. Second, we will show how the DBA can track changes made to both the Database objects as well as to file system objects. Third, we will look at some SQL and scripts that can be used to report violations not only for logins but for database objects, file system objects and profile options as well.
Finally, we will briefly discuss some best practices that DBAs might want to follow in their E-Biz environments. This includes topics such as change control, code migration, database auditing, login trails, preservation of logging information etc.
Available Seats: 10
Presenter, Company: John Kanagaraj, Cisco Systems Inc
- Session 2
April 10, 2007 12:00 PM U.S. Eastern (New York) Time
AR Users: Everything you wanted to know about OM but were afraid to ask!
Abstract and Management Summary
Receivables users can improve their working knowledge of AR if they know more about setups or processes in Order Management that affect Receivables. In this session you will learn about cross-functional setups and functionality including credit checking, transaction types, accounting and more.
Each Oracle application is delivered with sufficient setups so that it could be used as a stand alone module. The setups that make applications work together and properly integrate when using more than one application, can be found among any or all of the integrated applications. Unfortunately, many users or even superusers only have access to their specific application and probably have not been trained on the other applications. This can lead to the lack of understanding or just a lack of knowledge about how things really work together.
For Receivables users this disconnect might be even more pronounced because many times there is a very definite line between what is a financial function versus what might be a Sales or Order Management responsibility. Of course this is a problem when some traditionally financial functions are only found in setups in the Order Management module. Consider credit checking; much of the real functionality in credit checking is located in Order Management setups. Many Order Management users know very little about how credit checking works or even that credit checking is buried within their setups. Many Receivables users are unaware that those setups even exist.
This session will provide details and examples for many of the Order Management and Accounts Receivables shared or Common setups. The presentation will identify several customer setups that have shared functions. It will outline how credit checking really works, including many features new to 11i, show what setups in Order Management can affect your transaction accounting and many more Order Management and Receivables setups and functionality issues.
Receivables users, project managers or even Order Management professionals should find value in this paper and presentation and acquire enough information to take back to their jobs to review their settings and begin the process to make improvements in their systems.
Available Seats: 1
Presenter, Company: Judy Vales, Tootsie Roll I
- Session 3
April 10, 2007 5:00 PM U.S. Eastern (New York) Time
Practical help for the “SOXed-in” Oracle Apps DBA
Currently, there is a great deal of confusion around terms such as “SOX compliance”, “IT Controls”, “Section 404”, “SOD” and “APD”. While IT folks at all levels are understandably apprehensive, “SOXed-in” Oracle Applications DBAs are doubly so! As holders of the “keys to the kingdom”, Apps DBAs are under intense pressure to conform to various controls as well as provide records of these controls on an ongoing basis. The objective of this paper is to provide some reasonable starting points for the hard pressed DBA to start working out some common issues that we have encountered while striving to conform to these standards and rulings. We will start briefly with an explanation of what these terms actually mean for the DBAs’ activities, and more importantly, show how these controls, checks and balances translates to scripts, triggers, alerts, reports and audit trails at the technical level.
The Oracle Applications’ AOL and FND layers stores a lot of information about the security, integrity and auditability of the financial data that is held within an Oracle E-Business Suite database. This includes information pertaining to all the access privileges required by users as well as organizational and structural information that defines what functions, forms and reports can be assessed using these privileges. This information often needs to be extracted for review during the initial discovery phases of a remediation, and the DBA is often tasked to provide this information in an easily usable format that can be manipulated using spreadsheets. Using scripts and SQL, we will look at how this control data is structured in FND tables and how it can be made available in a easily usable format, rather than rely on cumbersome, inflexible Oracle reports or even screen shots from Oracle forms.
Once discovery is complete, the DBA may be tasked with remediation which usually includes an en-masse change of responsibilities. Again, knowledge of underlying FND functions can come to the rescue and we will look at some examples of how this can be done.
Remediation is just half the story. The Apps DBA needs to monitor compliance in many forms including auditing, access control and reporting of violations. We will tackle this issue using a three-pronged approach. First, we will see how Database level triggers can be used to both track and control logins to the database. Second, we will show how the DBA can track changes made to both the Database objects as well as to file system objects. Third, we will look at some SQL and scripts that can be used to report violations not only for logins but for database objects, file system objects and profile options as well.
Finally, we will briefly discuss some best practices that DBAs might want to follow in their E-Biz environments. This includes topics such as change control, code migration, database auditing, login trails, preservation of logging information etc.
Available Seats: 10
Presenter, Company: John Kanagaraj, Cisco Systems Inc
| | April 24, 2007 |
|
- Session 1
April 24, 2007 9:00 AM U.S. Eastern (New York) Time
PeopleSoft Human Capital Management Version 8.9 Security Overview - Deltas
This session will discuss the delta's in v8.9 HCM Security. Topics for discussion are: Department Security, Flexible Row-Level Security, Security Sets, Access Types, and securing data for People without Jobs.
Other points of discussion will be the new Security Processes used to refresh security changes, how Permission Lists are affected by new Security Design, as well as lessons learned in upgrading to version 8.9.
Available Seats: 20
Presenter, Company: Julie Larson, Emerging Solutions
- Session 2
April 24, 2007 12:00 PM U.S. Eastern (New York) Time
What's Up Doc? Easy Data Health Checks for your Oracle Apps System
A variety of easy data checks can be automated to track the health of your Oracle Apps data. We check Oracle Apps specific data conditions in areas such as User Security, Profile Settings, Invalid Objects, Direct Customizations and Module specific data issues. Most of the checks apply to all E-Business Suite sites. We currently monitor for over 75 different data conditions and new checks can be added quickly. In many cases, the health checks have allowed us to detect conditions before they cause problems. In addition, these checks save us significant time in Production support and problem analysis. Get a jump start in implementing automated health checks in your environment by using the SQL statements provided
Available Seats: 1
Presenter, Company: Lynne Paulus, Fair Isaac Company
- Session 3
April 24, 2007 5:00 PM U.S. Eastern (New York) Time
PeopleSoft Human Capital Management Version 8.9 Security Overview - Deltas
This session will discuss the delta's in v8.9 HCM Security. Topics for discussion are: Department Security, Flexible Row-Level Security, Security Sets, Access Types, and securing data for People without Jobs.
Other points of discussion will be the new Security Processes used to refresh security changes, how Permission Lists are affected by new Security Design, as well as lessons learned in upgrading to version 8.9.
Available Seats: 25
Presenter, Company: Julie Larson, Emerging Solutions
|
|
