http://www.idevelopment.info/ is maintained by Jeffrey M. Hunter. He is a DBA and software engineer graduated from Stanislaus State University in Turlock California with a Bachelor’s degree in Computer Science. He is Oracle Certified Professional, Java Development Certified Professional, Read More

Here is the script I often used to find the sql script using oracle trace utility for oracle applications forms, reports. Change the user id, password and database name to suit your environment. Download TKprof shell script #!/bin/sh #*********************************************** # Script Read More

Algorithm for the Luhn Formula LUHN Algorithm in C# (Validate Credit Card) Credit Card validation LUHN algorithm using C LUHN Algorithm - Validate credit card - in PHP Validate the credit card (plsql code)! Here’s how the algorithm for the Luhn formula works. Starting with a given credit Read More

This script provides an sample, and then the practical example to connect to oracle database, extract data like excel sheet and attach it with an email list. First connecting is done with “sqlplus -s $FCP_LOGIN” in silent mode.Then EOF marks the begining of sql statement and another Read More

Credit cards are loaded through interfaces. Oracle application, by default, accepts any value as this varchar2 format. However, the credit cards should be listed as a continuous number without any space or dashes or any special chars. We can try to eliminate these at source using filter in Read More

User needs the daily credit card failure report to follow-up with customers. This will attach the generated excel sheet and send the email to the list of users. This is registered as unix host concurrent Program in oracle applications. This can also be simply modified as a crontab report. This Read More

Lockbox is a service provided by banks by which your company gets the customers payments directly to a lockbox interface tables and creates receipt for the payments deposited into your account. If you have an Auto Lockbox, the bank records the information that you request such as check number, Read More

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: * The speed of Read More

Long back, around 2001, I download the script from http://www.gt.ed.net/keith/plsql/. This link is dead as of date. They are working plsql scripts that I have tested long back. Introduction MD4 and MD5 are one-way hashing algorithms designed to create compact, fixed-length (256 bit) digital Read More

/* Description: This script current period status of application (oracle 11i) Author: Jay Gopalakrishnan / Jiltin Input: &&Chart_of_accounts_id,&&application_id */ Download the code SELECT gls.name, gps.closing_status FROM apps.GL_PERIOD_STATUSES gps, Read More

/* Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications Backend query is always faster than front end query Author:      Jay Gopalakrishnan / Jiltin Input:       none */ Download the Read More

– – Description: For any customer number, this gives credit card or bank account number (oracle 11i) – Author:      Jay Gopal / Jiltin – Input:       &&Cust_number – Download the Read More

/* Description: This script will find the credit card number for an invoice number (oracle 11i) Author:      Jay Gopa l/ Jiltin Input:       &&inv_no */ select rc.customer_name customer, rct.trx_number invoice_number, apa.bank_account_id, apa.bank_account_name Read More

The customer needs an automatic notification, like an alert, whenever a shipment goes through. A trigger is put in place to insert a shipment record in a custom table for better performance. A concurrent job - unix shell script is designed to run every 15 minutes to pickup the details and Read More

A receipt can have one of the following statuses: Approved: This receipt has been approved for automatic receipt creation. This status is only valid for automatic receipts. Confirmed: The customer has approved the application of this receipt and their account balances have been updated within Read More

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 Read More

I am not the author of this plsql. Just reproduced from the source site. The original copyright and credit goes to the Author. Send e-mail messages and attachments from PL/SQL From Oracle8i release 8.1.6 one can send e-mail messages directly from PL/SQL using either the UTL_TCP or UTL_SMTP Read More

I am not the original creator of this plsql procedure. Just used this script three years before, and stored at my local computer. Unable to locate the source website. Hence, sharing it with you. The copyright and credit goes to the Read More

AP010 Executive Project Strategy AP010 Invitation Memorandum AP010 Session Planning Checklist AP020 Application Overview Customization AP020 Invitation Memorandum AP020 Project Team Orientation Plan AP020 Session Planning Checklist AP030 Project Team Learning Plan AP040 Project Team Learning Read More

Credit: Posted in October 12th, 2007 by Atul in apps In Oracle Applications professional Users can access professional forms via Appletin web browser.  This Form Applet must run with in Java Virtual Machine (JVM) and Oracle bundles its own JVM as Oracle Jinitiator.  This Jinitiator is Read More