July 2009 Blog Posts (10)

Oracle 32 bit to 64 bit conversion issues !!

Dear all,

I am facing a typical issue when trying to convert 32 bit .net application to 64 bit with upgrading oracle database from 32 to 64 bit in a 64 bit OS.When running the application it is showing me "Oracle.DataAccess.dll" compatability error. any of you friends can help me please?

Added by Rajib Bhowmik on July 29, 2009 at 5:41am — 2 Comments

Looking for Lodestar Billing Expert Developer/Production Support - Charlotte, NC

Our client's Transmission Billing area implemented Lodestar Billing Expert v 4.53 to replace two legacy systems and improve data quality. This position will provide technical support of the Billing Expert installation and the incoming interfaces. The technical support team is responsible for troubleshooting and resolving production issues, answering user questions, and developing fixes/enhancements as requested by the users. This position has the potential to be a long-term role with… Continue

Added by Amanda Harrison on July 28, 2009 at 12:24pm — No Comments

need help in varry and index and bulkbind exceptions

1 .how to use varry...can anyone help me out with good example .for right usage of varray...davance thanks.

2. how to use the index in a sql query so that your query has to optimised ....

3.can anyone explain with examples how to use the bulkbind and bulk collect exceptions

Added by sweetsarao on July 25, 2009 at 4:11am — 1 Comment

Opportunity for "Oracle Designer" (10g) professionals @ Capgemini India

Greetings!!



This is Jashan Joshi from Capgemini Recruitment Team.



We are currently looking for Oracle professionals having strong experience with Oracle Designer & Oracle 10g to work with us @ Bangalore.



You should also have strong knowledge on Oracle Forms & Reports.



Experience: 5+ years

Location: Bangalore

Remuneration: Best in the industry.



If you find this opportunity of your interest please send… Continue

Added by Jashan Joshi on July 20, 2009 at 12:25am — 1 Comment

Curiousity on Latent LOB Columns

I was doing some testing tonight, and discovered something curious on Oracle 11.1.0.7.0. Basically, if you add a CLOB column through an alter statement, drop the table, recreate the table, and try to alter the table again to add the CLOB column it's still there. It is like the table was never dropped, but DBMS_METADATA.GET_DDL and the DBA_LOB and DBA_SEGMENT views don't find it before you try to re-add the column. When you re-create it, you get an ORA-01430. After the error is thrown,… Continue

Added by Michael McLaughlin on July 16, 2009 at 11:57pm — No Comments

What is the effort, the pros and cons to migrate from Siebel 7.8 to Siebel 8.1 from an architecture stand point?

It is a difficult question and would need few months of study.

I have created a CRM Siebel architecture group to share on the upgrade to Siebel 8.1

As well, I would like to provide some highlights on the best pratices to the Oracle community.

I have put in place a small team looking at the various parts.
- ADF
- Siebel upgrade
- Database target architecture

Added by Xavier Callens on July 14, 2009 at 2:41am — No Comments

OAUG GL SIG - Please participate in short survey

Oracle General Ledger (GL) was the first Oracle Applications module launched more than 20 years ago. Release 12 has introduced "ground breaking" changes to the structure of this product that needs discussion and advertisement - not in the marketing sort of a way, but in a way that educates users about GL. Now, more than ever, GL users need a forum for free exchange of GL related information. Organizations upgrading or implementing GL have a host of unanswered questions. White papers and… Continue

Added by OCP Advisor on July 12, 2009 at 8:51pm — No Comments

MetaLink vs. My Oracle Support

Ever since the announcement came out, customers have been really vocal. Has your voice been heard? Leave a comment here. OTN has a thread going. Or, just VOTE here.



Chris Warticki is… Continue

Added by Chris Warticki on July 10, 2009 at 6:57am — No Comments

profile switch over

Hi,

I am working as an ERP consutant and have plans to learn other technology parallely. Can anyone please suggest what all things are there in oracle apps and how to start. My current profile is ' ERP administrator'. I have 6 yrs of experience. And how is scope of Oracle apps in North india.

Added by Harish on July 6, 2009 at 11:00am — No Comments

Data flow for Order to Cash cycle

Full article is avilable at my blog

Here you will get the details of column values getting updated at different stages and table joins information. >CLICK HERE



1. Order Entry

This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table.



* Enter… Continue

Added by Devendra Gulve on July 3, 2009 at 6:42am — 4 Comments

Blog Topics by Tags

Monthly Archives

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. 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

Badge

Loading…

Blog Posts

Join cases between related tables in data computing and analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.

Table structure:

The table emp stores the employee data table, in which the…

Continue

Posted by Jim King on August 25, 2014 at 1:35am

Oracle RAC Classes

Contact me for Oracle High Availability Training / Online Classes - Dubai shans.dba@gmail.com

Posted by Shanmugam on August 18, 2014 at 1:00am

Code Examples of In-Memory Grouping for more efficient data computing and analytics

It is convenient to realize some common in-memory grouping with esProc, such as, equal grouping, alignment grouping and enumeration grouping. They are to be illustrated with the following examples.

Equal grouping 

Grouping basis of equal grouping is certain fields (or computed columns derived from fields) within a data set. Each group is a subset of original data set.

Case description: Group sales orders by the year. …

Continue

Posted by Jim King on August 15, 2014 at 12:21am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service