ebmentors.blogspot.com
EBMentors: December 2010
http://ebmentors.blogspot.com/2010_12_01_archive.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Sunday, December 26, 2010. Oracle Applications - Intro and Concepts. Note: Below notes written, keeping in view for system administration and APPs DBA activities. 1- Oracle Application Architecture:. Or services) is a process or group of processes that runs on a single machine. Server supports data-intensive programs that run in the background. Mediating the com...
ebmentors.blogspot.com
EBMentors: February 2011
http://ebmentors.blogspot.com/2011_02_01_archive.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Wednesday, February 2, 2011. Form Personalization (Release 12). Feature allows you to declaratively alter the behavior of Forms-based. Including changing properties, executing builtins, displaying messages, and adding. For each function (a form running in a particular context based on parameters passed to it), you. Can specify one or more Rules. The Condition is...
networkedblogs.com
DBMentors | NetworkedBlogs by Ninua
http://www.networkedblogs.com/blog/dbmentors
DBMENTORS IS A SOLUTION ORIENTED GROUP, STARTED BY A TEAM OF QUALIFIED AND COMMITTED PROFESSIONALS WITH VAST EXPERIENCE IN IT INDUSTRY. THE TEAM HAS IN-DEPTH TECHNICAL AND DESIGN EXPERTISE WITH HIGHEST STANDARDS OF PROGRAMMING QUALITY. Invite Friends to Follow. Written by 1 Author. Followed by 4 People. Http:/ dbmentors.blogspot.com/. No posts have been published yet. This site uses BitPixels previews.
ebmentors.blogspot.com
EBMentors: Form Personalization (Release 12)
http://ebmentors.blogspot.com/2011/02/form-personalization-release-12.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Wednesday, February 2, 2011. Form Personalization (Release 12). Feature allows you to declaratively alter the behavior of Forms-based. Including changing properties, executing builtins, displaying messages, and adding. For each function (a form running in a particular context based on parameters passed to it), you. Can specify one or more Rules. The Condition is...
ebmentors.blogspot.com
EBMentors: January 2011
http://ebmentors.blogspot.com/2011_01_01_archive.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Wednesday, January 19, 2011. After creating your business group, you define other organizations within your business group and classify them, for example as HR Organization, Company Cost Center, Bargaining Unit, GRE, and many others. Responsibility: US HRMS Manager or US Super HRMS Manager. Create a Business Group. 7- Select United States as the legislation code...
ebmentors.blogspot.com
EBMentors: Multidimensional data analysis with SQL
http://ebmentors.blogspot.com/2011/05/multidimensional-data-analysis-with-sql.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Wednesday, May 11, 2011. Multidimensional data analysis with SQL. Using advanced SQL features, you can even perform multidimensional data analysis as well, enabling you to answer complex analytical questions. CREATE USER usr IDENTIFIED BY usr;. GRANT connect, resource TO usr;. CREATE TABLE salespersons (. Emp id VARCHAR2(10) PRIMARY KEY,. CREATE TABLE regions (.
ebmentors.blogspot.com
EBMentors: BI
http://ebmentors.blogspot.com/p/bi.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Introduction to Oracle BI Intelligence Suite. Analytic functions by Example. Multidimensional data analysis with SQL. Subscribe to: Posts (Atom). Multidimensional data analysis with SQL. Analytic functions by Example. Riyadh, Saudi Arabia. Ejada Systems Ltd. Riyadh KSA (Current), Netsol Techenologies Pakistan, Ministry of Railways Pakistan.
ebmentors.blogspot.com
EBMentors: BI Intro
http://ebmentors.blogspot.com/2011/05/bi-intro.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Monday, May 2, 2011. Subscribe to: Post Comments (Atom). Multidimensional data analysis with SQL. Analytic functions by Example. Riyadh, Saudi Arabia. OCP DBA 8i/10g/11g, OCP Apps DBA, OCP Developer, Oracle Certified Expert, RAC and GI 11gR2, SCJP, mySAP FI/CO solution consultant. View my complete profile.
ebmentors.blogspot.com
EBMentors: Database Adminisration
http://ebmentors.blogspot.com/p/dba.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Managing Files - Generating Product Files. Adding New Off-Cycle Products. Adding and Maintaining NLS Languages. Compressing, Archiving and Deleting Files. Using System Resources Efficiently. Validating the APPS Schema. Recreating Grants and Synonyms. Pre-Allocating Space for Packages and Functions. Listing Objects in the Shared Pool. Subscribe to: Posts (Atom).
ebmentors.blogspot.com
EBMentors: Analytic functions by Example
http://ebmentors.blogspot.com/2011/05/analytic-functions-by-example.html
This blog related to Oracle EBusiness Suite topics for Apps DBA, and System Admin. Please see my other blog for Oracle posts (DB,RAC) DBMentors. Tuesday, May 3, 2011. Analytic functions by Example. The general syntax of analytic function is:. Function(arg1,., argn) OVER ( [PARTITION BY . ] [ORDER BY . ] [ window clause ] ). Window clause is like "ROW? How are analytic functions different from group or aggregate functions? And its result. Query-1. Returns departments and their employee count. Most imp...