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

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service