The social network for Oracle people

April 2009 Blog Posts (18)

How old is that E-Business Suite clone, really?

In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.

Added by John Piwowar on April 30, 2009 at 6:53pm — No Comments

How to I see the debug messages either in log file or output file in oracle applications?

When you register a concurrent programs, such plsql packages, you can display the debug outputs either at output file or log file or both depending on the api you use. There are two functions from fnd_file packages that can be used to display the debug messages.

fnd_file.put_line(FND_FILE.LOG,"This is logfile test");

fnd_file.put_line(FND_FILE.out,"This is output test");

by
Jiltin

Added by Jiltin on April 24, 2009 at 6:59am — No Comments

function query

hi all...
i wanted a querey which returns the data on the basis of comparision of two table columns having case sensitive data.

test.name2 = 'HaMiDaBdUlLaH'
test1.name1 = 'HAMID'

i issued the query
select * from test,test1 where upper(test1.name1) like '%'||upper(test.name2)||'%';

but nothing happened. Can anyone help me with that...?

Added by Zeeshan Ali on April 22, 2009 at 10:09pm — 3 Comments

Back and blogging again

It's been a long time since I did anything on this site. I've been taking a break from cyberspace. The forums and the blog were getting too much, on top of my work. But I think I've got my work-life balance back under control (famous last words). Anyway, I've started blogging again, and participating in the forums.

But really I'm just updating this because the last message I posted here was so negative. Blogger did sort out the problem, so that's cool.

I feel better now… Continue

Added by APC on April 21, 2009 at 8:54am — 2 Comments

Wow. The news just gets better

Well. Oracle and Sun. A great software company with a company that has top notch hardware and an OS like no other. I'm really excited about the possibilities.

Added by Jake Ramirez on April 20, 2009 at 10:05pm — 1 Comment

How To Add Responsibility to USER using pl/sql? - Oracle Applications

If you have the Apps Password, its quite easy to create a FND_USER for yourself by using the API. I find this script very useful when development environment gets cloned from Production(that is when i do not have FND_USER in Production).

Please note that:-

1. You will be allocated System Administrator by this script. Hence you can assign whatever responsibilities that you desire latter, after logging in.

2. The password will be set to oracle

3. You need apps password… Continue

Added by Jiltin on April 20, 2009 at 12:00pm — No Comments

Where IT is going

Thought I'd share something that came down the pike. I really think it's not going to be so much about the systems but rather what we do with the data. Where is data management most needed? Energy? Healthcare? Yes, Yes and Yes

http://www2.computer.org/portal/web/buildyourcareer/careerwatch/hotsectors

The writing is on on the wall. IT is getting more focused and Healthcare, Energy and Infrastructure is where it will be.. Thoughts?

Added by Jake Ramirez on April 15, 2009 at 8:52pm — No Comments

Locks on oracle database & Oracle applications Processing.

In a single-user database, the user can modify data in the database without concern for other users modifying the same data at the same time. However, in a multiuser database, the statements within multiple simultaneous transactions can update the same data. Transactions executing at the same time need to produce meaningful and consistent results. Therefore, control of data concurrency and data consistency is vital in a multiuser database.

* Data concurrency means that many users can… Continue

Added by Jiltin on April 15, 2009 at 8:05am — No Comments

Validate the credit card (oracle 10 g plsql code)

The Luhn algorithm or Luhn formula, also known as the “modulus 10″ or “mod 10″ algorithm, is a simple checksum formula used to validate a variety of identification numbers, such as credit card numbers and Canadian Social Insurance Numbers.

Recently, Oracle has stopped validating the credit card numbers as there is match for Authorization of credit card. However, this rudimentary mod-10 LUHN algorithm is still valid and valuable for us to check.

Hence, I started creating… Continue

Added by Jiltin on April 14, 2009 at 12:30pm — No Comments

Oracle Applications Steps To Register Shell Script As A Concurrent Program

There are two methods to handle, one with symbolic link another without symbolic link.

step 1: Place the .prog script under the bin directory for your applications top directory.

For example, call the script SHELLDEMO.prog and place it under $XXCUS/bin

step 2: Make a symbolic link from your script to $FND_TOP/bin/fndcpesr

For example, if the script is called SHELLDEMO.prog use this:

ln -s $FND_TOP/bin/fndcpesr SHELLDEMO

This link should be… Continue

Added by Jiltin on April 14, 2009 at 8:17am — No Comments

GL Date Move for Lockbox Records - Oracle Applications tips - SQL

Few companies have streamlined their operations to avoid GL_Date move. Moving GL date is very common fix in many companies, especially during the month end activities. Here is one of the requirements in which we need to move the gl_date of the lockbox records before creating the lockbox records.

The lockbox data is sent by banks very late evening. In addition, loading errors and the records errors are being fixed at night. However, General ledger period will be closed by 12 midnight.… Continue

Added by Jiltin on April 14, 2009 at 7:59am — No Comments

Oracle Applications Steps To Register Shell Script As A Concurrent Program

Added by Jiltin on April 13, 2009 at 10:12pm — No Comments

Oracle - PLSQL - compiler directives summary.

Scope of the Blog: Learners and Mid level programmers.

A compiler directive, data embedded in source code by programmers to tell compilers some intention about compilation. A compiler directive often tells the compiler how to compile; other source code tells the compiler what to compile. We have 4 PL/SQL compiler directives

1)AUTONOMOUS_TRANSACTION.

2)RESTRICT_REFERENCES

3)EXCEPTION_INIT.

4)SERIALLY_REUSABLE.

AUTONOMOUS_TRANSACTION:

A… Continue

Added by Jiltin on April 13, 2009 at 2:00pm — No Comments

Oracle 10gR2 RDBMS for Mac OS X (Intel) has arrived!

Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!

A quick note: I don't have any installation instructions in the post linked above, but here are some good resources:…

Continue

Added by John Piwowar on April 11, 2009 at 5:00pm — No Comments

Automating Data Auditin

Data auditing provides enterprises with the tools to classify data based on its sensitivity, define policies at the database level that determine how that data should be managed, and automatically monitors and logs any changes to application… Continue

Added by lorryins on April 8, 2009 at 2:09am — No Comments

Higher productivity and a positive impact to your organization

Every kind of storage is bound to overflow sometime or the other; it also applies to software industries. Companies that have large storage data, which would also be needed for future trend analysis, reduce retrieval speed. Such companies can opt for data archiving solutions. Data archiving is built on the concept of preserving data through classification and storage, helps in improving throughput.…

Continue

Added by lorryins on April 8, 2009 at 1:48am — No Comments

Via Twitter, an interesting regexp_replace puzzle

Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) question on Twitter, and I found myself thinking, "hey, I bet I could actually answer that!" So I did. Then I thought about my answer a bit more, and decided to write a blog post to expand upon my original 140-character response.

Added by John Piwowar on April 3, 2009 at 9:30am — No Comments

Here are the excerpts of the Oracle 11g new password algorithm.

Here are the excerpts of the Oracle 11g new password algorithm. You can see the complete disclosure of the password algorithm and the history of tracing

Nothing to panic!: Research results suggest that SHA1 has, at most, 69 bit strength, significantly less than the 80 bits, but still no easy matter to attack with current technology. SHA-1 is secure and stronger than previous algorithm. According to wikipedia you can find a collision for SHA-1 in 2 to the power of 69 operations. This… Continue

Added by Jiltin on April 3, 2009 at 9:26am — No Comments