May 2009 Blog Posts (10)


Hi guys

We have a AR receipt with maturity date. But after cheqeue goes to bank, bank informs us that there is no money in customer account . Now we need to have this accounting:

Unsetteled Receipts Account Dr
Remmittance Account Cr

How can I have it in R12?

Thanks alot

Added by Elaheh Tahmaseb Bakhtiari on May 26, 2009 at 4:45am — No Comments

My Blog:

Added by Christian Trieb on May 20, 2009 at 6:03am — No Comments

Opened a new Oracle Blog in Blogger

I have opened a new Oracle blog at
Kindly give back your comments on it.

Added by Subramanian Kaushik Gurumoorthy on May 14, 2009 at 1:59pm — No Comments

Oracle Applications: Production to Development Refresh/Clone Parameter Change SQL Script

Big companies that follow Process oriented project management team, with multiple projects executed at phased manner, may face challenges during database refresh from production system to development or test systems. Many programs customized to connect to external systems such as lockbox servers, payment processing servers and other boundary server systems.

After every refresh, it is imperative to change the development systems to point to null or Development external test servers… Continue

Added by Jiltin on May 14, 2009 at 8:06am — No Comments

Oracle Applications - Simple Query to find FND_LOOKUP Values.

Oracle Applications - Simple Query to find FND_LOOKUP Values.






Added by Jiltin on May 11, 2009 at 10:00pm — No Comments

Oracle Applications Script : Sample Script to Debug the Procedure, Packages Running At Backend

For mission critical operations with big - complex PLSQL packages, we may need to know the path or the way the data is processed. In such case, it is very hard to debug the flow. I had such situation many times and it is easy to implement a simple solution using a debug log table for future review purpose. Make sure you delete or purge the table often and also create a proper index on this table to avoid performance issues later. This procedure can be global or inside a package. With oracle… Continue

Added by Jiltin on May 11, 2009 at 9:30pm — No Comments

ORACLE CC&B conversion expert is available online to resolve problems of conversion

- Data Analysis and Conversion (CorDaptix CIS SPL) or ( Oracle CC&B)
Leader of conversion team assigned to implement SPL CIS (also known as CorDaptix or PeopleSoft CIS) ERP package or ORACLE CC&B, for 1.9 million customers. The process required analyzing, converting and cleansing the data before loading, and at ends it for accuracy.

Any problems you are facing in conversion from Legacy system to Oracle CC&B software, I am available for free help.

Added by SYED AKMAL IMTIAZ on May 11, 2009 at 5:27am — 2 Comments

Urgent Opening for Oracle Apps Consultant with OAF & Work Flow

Title: Sr. Oracle Apps Consultant with OAF and workflow.

Experience: 5+Yrs

Location: Hyderabad, India


* Working Experience in OAF

* Working Experience in Work Flow.

* Working Experience in Forms & Reports.

* Should have very good communication skills.

Interested candidate send your resumes to

Feel free to get in touch with me for more information about this… Continue

Added by Chaitanya on May 10, 2009 at 9:11am — No Comments

Ever wonder "what if this database contains my data ?"

Hemant K Chitale asked this pertinent question on the OTN forum the other day. His text in full:

"When you see a forums posting about missing datafiles , errors in recovery, SQLs returning the wrong results because they haven't been correctly written and tested .... etc etc ... do you ever wonder "what if this database…

Added by APC on May 2, 2009 at 1:20am — 1 Comment

migration of database to different platforms

oracle 10 g has introduced the feature of tdb(transport database)

in this database can be converted from one platform to other

the min. req. for the conversion is version should be same on both the platform

2.check the prerequitise before migration

3.check for the external objects(just run a script )

4.create transport scriipt(which contains inf. req. for conversion)

5.use the parameter db_files_convert to convert the file

6.change the format… Continue

Added by abhishek singh on May 1, 2009 at 7:41am — 1 Comment

Monthly Archives











Oracle Community On

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



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service