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

7 Benefits of Amazon Product Data Entry Services

An Optimized Creation, Processing and Maintenance of your Amazon Products’ E-catalog Gives you an Edge in the Competitive eCommerce Market.

When you upload your inventory on one of the world’s biggest online marketplaces, what strategy do you employ to survive the competition put forth by popular brands? You optimize your listings to enhance the discoverability of the product. Amazon Product data entry services ensures your product is available in the virtual…

Continue

Posted by Alvaro Dee on September 6, 2016 at 3:08am

Why you Should Include Push Notifications in your Mobile App?

Push notifications are a display of your application’s icon and a message in the status bar of your device. We stress the importance of including push notifications in your mobile application for three major reasons:-

  1. Push Notifications allow direct marketing to your clients: When a customer downloads your application and enables push notification, it gives you direct…

Continue

Posted by Alvaro Dee on August 23, 2016 at 10:50pm

Amazon Virtual Assistant Services for Efficient e-store Management

Virtual assistant (VA) is a term that has been buzzing around in the business world for quite some time now. Essentially, a VA is skilled administrator who takes care of your technical/creative business support activities while working offsite. If you already have a designated eCommerce store on Amazon seller central or wish to start one, an Amazon VA will help you manage the store and update it regularly with utmost precision.

Amazon VA creates and updates the…

Continue

Posted by Alvaro Dee on August 23, 2016 at 2:56am

What to Expect When Investing in Data Cleansing Services?

Why invest in data cleansing services?

Imagine a scenario- You are maintaining huge databases containing information about your potential customers and you are all geared up with next direct mailing campaigns. After promotional mailers have been sent, you realize the fact that the major part of your database actually contained supplier information.

Such blunders can happen anytime and can…

Continue

Posted by Alvaro Dee on July 25, 2016 at 11:30pm

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service