i have a table xyz withe three column
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 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.…Continue
Added by Uwe Hesse on September 29, 2011 at 8:01am — No Comments
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
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
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
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…Continue
Added by Mohamed Azar on September 27, 2011 at 7:05am — No Comments
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.…Continue
Added by Mohamed Azar on September 27, 2011 at 7:03am — No Comments
Added by Gökhan Atıl on September 26, 2011 at 1:08am — No Comments
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 (22.214.171.124.2 version).
In my previous article “RAC 126.96.36.199 Patch 12311357 – 188.8.131.52.2 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 (184.108.40.206.0). 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
Instance recovery occurs in two steps:
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
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: http://fcosfc.wordpress.com/2011/05/20/merge-or-upsert/
I hope it will be useful!
Added by Paco Saucedo on September 19, 2011 at 10:29am — No Comments
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…Continue
Added by Cyriel van Schaik on September 18, 2011 at 11:06am — No Comments
Added by Wissem EL KHLIFI on September 18, 2011 at 8:59am — No Comments
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
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 …Continue
Added by Cyriel van Schaik on September 18, 2011 at 7:40am — No Comments
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…Continue
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
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?…Continue
Added by Uwe Hesse on September 13, 2011 at 12:04pm — No Comments
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