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 – How to find the receipt stuck in between stages?

Posted by Jiltin     Tags: , , , 9 January, 2009    727 views    (0) Comment

Many times, the receipts are stuck in between stages. If these are noticed, all the receipts are stuck, and invoices many not be closed. Here is the sql to find the receipt stuck in between stages. This is working code, verified in oracle 11i financial applications /***************** Author: Jay ******************/ SELECT  ab.org_id,         ab.name,         ab.batch_applied_status ,         ab.batch_date,       Read Full Article (Click here)...

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