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

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

/* 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

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

select gls.name, gps.closing_status from apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls where 1=1 and gps.start_date <= sysdate and gps.end_date >= sysdate and gps.set_of_books_id = gls.set_of_books_id and gps.set_of_books_id >= &Set_of_books_id and Read More

How do I obtain CCID ( code combination id) / Chart of Account data for General Ledger select substr(gl.code_combination_id,1,5) ccid, substr(gl.segment1,1,5) , substr(gl.segment2,1,8) , substr(gl.segment3,1,5) , substr(gl.segment4,1,5) , substr(gl.segment5,1,5) , substr(gl.segment6,1,5) Read More

————————————————————————- —     Author : Jayasankar Read More

————————————————————————- —     Author : Jayasankar Read More

————————————————————————- —     Author : Jayasankar Read More

————————————————————————- —    Author : Jayasankar Read More

Just run this sample sql changing the patch number (3061831) in sqlplus or Toad. select distinct rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4) from ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d, ad_applied_patches e where Read More