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

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 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

Monthly Archives

2016

2015

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

List Building: Reach Out to the Target Audience and Boost Your Marketing Efforts

An accurate, relevant and up-to-date database is the bedrock of a successful email marketing campaign. So it is crucial to create and maintain correct and updated mailing lists that help in reaching out to potential customers and converting them into buyers, thereby generating…

Continue

Posted by Alvaro Dee on April 25, 2016 at 10:43pm

Scope of Data Entry from Images and their Range of Service

We all know that a document's image is valuable only when the information it contains is digitized and stored in a suitable format. Scanned images data entry calls for great amount of accuracy as inaccurate data can influence the entire database. Also, image data entry is a very tedious and time consuming process. Hence, it is best to take the help…

Continue

Posted by Alvaro Dee on March 30, 2016 at 9:30pm

Packt publishing releases "Advanced Oracle PL/SQL Developer Professional Guide-Second edition"

I am pleased to inform you all that Packt publishing has released the book "Advanced Oracle PL/SQL Developer Professional Guide-Second edition" after my second stint with them. This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this…

Continue

Posted by Saurabh K. Gupta on February 26, 2016 at 12:57am

Routing Oracle AQ messages using Apache Camel in ServiceMix

I'm working in how to connect Oracle AQ JMS messaging with other systems, using Apache Camel in ServiceMix: https://fcosfc.wordpress.com/2016/02/06/routing-oracle-aq-messages-using-apache-camel-in-servicemix/

I hope it will be useful!

Posted by Paco Saucedo on February 13, 2016 at 2:37am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service