Scripts Oracle

Oracle Applications:Checking Credit Card Number validity in Internet Expenses, iPayments using Luhn algorithm (modulus 10)

Posted by Jiltin     Tags: , 10 June, 2009    1,679 views    (1) Comment

Is there any method to spot check validity of the card number, prior to asking client to check with the credit card company? Team that follows LUHN10 ALGORITHM (http://en.wikipedia.org/wiki/Luhn_algorithm) for validating the checksum on the card numbers. If the checksum ends with 0 modulus of the checksum is congruent to zero then the number is valid (For e.g. 70 MOD 10 = 0). In general all the credit card brands follow this algorithm. As an illustration, if the account number is Read Full Article (Click here)...

Categories : 11i Scripts, Scripts Oracle, Scripts Unix Tags : ,

Oracle Applications: The Concurrent Jobs Ran Yesterday and Failed – SQL script & Unix Shell Script

Posted by Jiltin     Tags: 10 June, 2009    1,585 views    (0) Comment

I often use this script to find the concurrent jobs ran yesterday and Failed. You can also automate the script into unix shell or some oracle alerts. SELECT fu.user_name, fcpt.USER_CONCURRENT_PROGRAM_NAME, fcpt.description, fcp.CONCURRENT_PROGRAM_NAME, fcr.REQUEST_ID, round((fcr.actual_completion_date – decode (trunc(fcr.request_date),fcr.requested_start_date,fcr.request_date,fcr.requested_start_date))*60*24) Read Full Article (Click here)...

Categories : 11i Scripts, Scripts Oracle Tags :

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

Posted by Jiltin     Tags: , 12 May, 2009    2,901 views    (1) Comment

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 instead Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL, Oracle Applications, Scripts Oracle Tags : ,

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

Posted by Jiltin     Tags: , 8 May, 2009    2,081 views    (2) Comment

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 Read Full Article (Click here)...

Categories : 11i Scripts, Oracle Applications, Scripts Oracle Tags : ,

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

Posted by Jiltin     Tags: , 20 April, 2009    10,472 views    (10) Comment

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 to run this script. Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL, Scripts Oracle Tags : ,