September 2011 Blog Posts (27)

my sql query gives error

i have a table xyz withe three column

a   varchar2(20)

b   number;

d   date

in d i have data from 1998 to 2011 like last_day of each month 31-mar-1998

sql>select count(*) from  xyz;

error at line 1;

ora-01841:(full) year must be between -4713 and +9999,and not be 0

plz help me in this issue



Added by muhammad qasim khan on September 30, 2011 at 5:37am — No Comments

The Recovery Area: Why it is recommended

The Recovery Area was designed in the first place for customers who use Disk Storage as their primary backup media. Meanwhile, due to the ever decreasing price of Disk Storage, this should be the majority of customers. In spite of that, there seems to be some kind of reluctance to actually make use of the multiple benefits, the Recovery Area delivers.…


Added by Uwe Hesse on September 29, 2011 at 8:01am — No Comments

How to setup a catch all email address for Workflow Notifications

As you know Oracle E-Business Suite is having a lot of workflows which arrange things like PA Budget approvals, PO approvals and AP Invoice approvals. Also workflow will sent so called FYI or For Your Information notifications to users to inform them about special events happened in the system.

When you have activated also the Workflow Notification Mailer E-Business Suite is able to sent out also the notification by email to the enduser. Additionally, when enabled, a user is able…


Added by Cyriel van Schaik on September 28, 2011 at 12:30pm — No Comments

Task Name vs Long Task Name in Time and Labour and Project Management

When using Oracle Time and Labour for time entry together with Project Management you might run into the problem that your task names appear to be truncated within the timecard pages in Time and Labour. Also within several screens in Project Management this is happening.

Table PA_TASKS holds 2 columns...


Read more at Oracle EBS APPS Blog

Added by Cyriel van Schaik on September 27, 2011 at 1:38pm — No Comments

Extract project details with customer and specific key members

I got the requirement to build a new integration for Oracle Projects with an external system. For this I defined a custom view which extracts the required information from eBS.

The view extracts main project information for a specific project organization combined with the billing and shipping customer and address details and the names of the resources with specific roles on the project - in this case the Project…


Added by Cyriel van Schaik on September 27, 2011 at 11:31am — No Comments

Oracle 11gR2 two node Real application cluster installation step by step guide on linux using VMware Server

Here...If you would like switch on to RAC DBA, first you must know about RAC installation. you think It may difficult for me while installation, Not at all but sometimes. you may refer some installation document so in this case If you're searched in Google,  you can get a more installation document. then Why I was published, Answer is you can realized after reviewed my installation document. I hope This document style should be user friendly for you. In this document I demonstrated how do we…


Added by Mohamed Azar on September 27, 2011 at 7:05am — No Comments

Oracle EBS 12.1.1 three tier step by step installation guide on Linux

Yes I am still working as a Core DBA, not act like as a Apps DBA. But I got a some opportunity to work for EBS Environment. So here First I installed the three tier EBS 12.1.1 on Linux machine. In this document I just demonstrate How do we install Oracle EBS 12.1.1 on Linux machine. I hope It may very useful for who willing to learn EBS installation. Just review my installation document. Hope you're all like this document...

Download PDF Document here.…


Added by Mohamed Azar on September 27, 2011 at 7:03am — No Comments

Upgrading Oracle RAC Database to (Grid + DB)

A new patchset for Oracle 11.2 has been released. This patchset is a full installation of the Oracle Database software. So you don't need to install before installing You can read the complete list of new features of from here:

I downloaded the patchset and wanted to upgrade… Continue

Added by Gökhan Atıl on September 26, 2011 at 1:08am — No Comments

11gR2 RAC: Patch Set Update 3 Install


In this post, I am going to explain you how to successfully apply a Patch Set Update 3 (PSU 3) on the top of the Patch Set Update 2 ( version).

In my previous article “RAC Patch 12311357 – GI Patch Set Update and mutex patch – 4 Nodes on Redhat Linux”, I demonstrated how to apply the patch set update 2 on the top of patch set version 2 ( You may ask this question; what is difference between Patch Set and Patch…


Added by Wissem EL KHLIFI on September 24, 2011 at 4:05am — No Comments

SMON - How it will handle instance recovery

Instance recovery occurs in two steps:

1.Cache Recovery

2.Transaction Recovery


Cache recovery:

Changes being made to a database are recorded in the database buffer cache. These changes are also recorded in online redo log files simultaneously.

When there are enough data in the database buffer cache, they are written to data files.

If an Oracle instance fails before the data in

the database buffer cache are written to data files, Oracle uses the…


Added by Gogune Suresh Kumar on September 21, 2011 at 11:25pm — No Comments

Workplan Version Naming in Project Management - Copy Copy?

If you have enabled workplan versioning within your project templates or project you get the functionality of having multiple versions of your workplan. These versions can be rescheduled and progress updates can be done. When using Microsoft Projects (MSP) integration you'll import specific workplan versions to make changes.

If you enabled the option to automatically publish the workplan upon project creation from a project template you'll get a Working version and a Baselined…


Added by Cyriel van Schaik on September 20, 2011 at 4:58pm — No Comments


I'd like to share a study about using MERGE statements in PL/SQL UPSERT situations:


I hope it will be useful!

Added by Paco Saucedo on September 19, 2011 at 10:29am — No Comments

Get Request Group and Responsibility by Concurrent Program

It happens a lot when debugging any issue an user has with Oracle E-Business Suite a concurrent program is mentioned which seems to fail. You can relogin as that user to reproduce the error but it might also be handy if you know in which request group and it which responsibility this concurrent program is available. I always use the below SQL statement to get this information from the database. Filter on the concurrent request name or use the concurrent program short name (commented…


Added by Cyriel van Schaik on September 18, 2011 at 11:06am — No Comments

Interview with Ben Prusinski – Oracle ACE and Oracle Expert

Ben Prusinski is an Oracle Certified Professional with more than 12 years of full-time experience as a database administrator and has written numerous articles and white papers on database management. Ben is the author of two books on Oracle database technology: Migrate to Oracle: Expert Secrets and Oracle Debugging both from Rampant Tech Press. He is also one of the authors of :… Continue

Added by Wissem EL KHLIFI on September 18, 2011 at 8:59am — No Comments

Show relevant customers in Project Management assigned to the Operating Unit

When implementing Project Management across multiple operating units and using customers assigned to your created projects, for example to bill them your hours through Project Billing, you might run into the problem that an user from an operating unit will see ALL the customers available in Account Receivables. This user will also see the customers belonging to other operating units.

In Oracle E-Business Suite the customers are shared across all the operating units and customer…


Added by Cyriel van Schaik on September 18, 2011 at 8:53am — No Comments

How to create a SQL*Loader Concurrent Program

When building customizations for the Oracle E-Business Suite it might be needed to load data from external sources into specific tables. Tables might be seeded tables, i.e. Open Interface tables, or custom tables which you've added to a special customizations database schema.To load data from external sources into Oracle eBS you might consider using SQL*Loader....


Read more at …


Added by Cyriel van Schaik on September 18, 2011 at 7:40am — No Comments

11gR2 RAC: add Enterprise Manager Database Control to crs resources for automatic restart


Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources.

Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts.

These components can be easily added to the Oracle Restart using the srvctl add command.

The procedure of adding the Enterprise Manager database control as a…


Added by Wissem EL KHLIFI on September 18, 2011 at 2:47am — No Comments


During my present Exadata course in Munich, we have discussed Hybrid Columnar Compression (HCC) and how to estimate the size of tables after compression.

Added by Uwe Hesse on September 13, 2011 at 12:06pm — No Comments

DBA Job-Task Analysis Weighting Survey is out!

If you read this, chances are high that you are an Oracle DBA :-)

Would you like to help define the depth and scope of future Oracle Database training and certification?…


Added by Uwe Hesse on September 13, 2011 at 12:04pm — No Comments

Fine Grained Auditing and SYS_CONTEXT

For an Oracle Database, we have several ways to audit user activity. With this posting, we will take a closer look at Fine Grained Auditing (FGA), working together with the very useful standard function SYS_CONTEXT.

Added by Uwe Hesse on September 13, 2011 at 12:02pm — No Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…


Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…


Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…


Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…


Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service