11i Scripts

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

Posted by Jiltin     Tags: , 10 June, 2009    177 views    (0) 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    221 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: Key Flex Field Structures & How to Retrieve Information.

Posted by Jiltin     Tags: , 18 May, 2009    510 views    (0) Comment

Here is some of quite commonly used AOL FND ( Foundation) tables and their usage. There are many other tables also in FND but here i am putting only few commonly used tables. for other table if needed we can dig further. FND_ID_FLEXS stores registration information about key flexfields. Each row includes the four–character code that identifies the key flexfield, the title of the flexfield (by which a user identifies theflexfield), the name of the combinations table that contains the key Read Full Article (Click here)...

Categories : 11i Scripts, General Ledger Tags : ,

Oracle Applications: Submitting Concurrent Request Using FND_CONCURRENT.WAIT_FOR_REQUEST Sample Code

Posted by Jiltin     Tags: , 15 May, 2009    460 views    (0) Comment

When submitting concurrent requests using PL/SQL, it is often desired to have the parent process wait until all the child processes have completed before completing itself. The following describes the function used to accomplish this. Refer Metalink 1021956.6: The following describes how to submit concurrent requests using PL/SQL and have the parent request ‘wait’ until each of the child processes have completed before it completes. Use the FND_CONCURRENT.WAIT_FOR_REQUEST Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL Tags : ,

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

Posted by Jiltin     Tags: , 12 May, 2009    330 views    (0) 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 : ,