[英语]Oracle Applications 11i SQL Scripts.doc

Table of Contents  TOC \o 1-3 \h \z \u  HYPERLINK \l _Toc282599824 Script to Start and Stop the Application, Database Servers  PAGEREF _Toc282599824 \h 1  HYPERLINK \l _Toc282599825 Checking Credit Card Number validity in Internet Expenses, iPayments using Luhn algorithm (modulus 10)  PAGEREF _Toc282599825 \h 3  HYPERLINK \l _Toc282599826 The Concurrent Jobs Ran Yesterday and Failed – SQL script Unix Shell Script  PAGEREF _Toc282599826 \h 4  HYPERLINK \l _Toc282599827 Key Flex Field Structures How to Retrieve Information.  PAGEREF _Toc282599827 \h 5  HYPERLINK \l _Toc282599828 Submitting Concurrent Request Using FND_CONCURRENT.WAIT_FOR_REQUEST Sample Code  PAGEREF _Toc282599828 \h 6  HYPERLINK \l _Toc282599829 Production to Development Refresh/Clone Parameter Change SQL Script.  PAGEREF _Toc282599829 \h 7  HYPERLINK \l _Toc282599830 Simple Query to find FND_LOOKUP Values.  PAGEREF _Toc282599830 \h 9  HYPERLINK \l _Toc282599831 Sample Script to Debug the Procedure, Packages Running At Backend  PAGEREF _Toc282599831 \h 9  HYPERLINK \l _Toc282599832 Another SQL script to find the profile option values.  PAGEREF _Toc282599832 \h 10  HYPERLINK \l _Toc282599833 How do I see the debug messages either in log file or output file in oracle applications?  PAGEREF _Toc282599833 \h 11  HYPERLINK \l _Toc282599834 How To Add Responsibility to USER using pl/sql? – Oracle Applications  PAGEREF _Toc282599834 \h 11  HYPERLINK \l _Toc282599835 Here Is A Sample Unix / Linux Script That Checks The Payment Settlement File And Acknowledgement File  PAGEREF _Toc282599835 \h 12  HYPERLINK \l _Toc282599836 Steps To Register Shell Script As A Concurrent Program  PAGEREF _Toc282599836 \h 13  HYPERLINK \l _Toc282599837 GL Date Move for Lockbox Records – Oracle Applications tips – SQL  PAGEREF _Toc282599837 \h 14  HYPERLINK \l _Toc282599838 How to secure login with oracle SQL*Plus with a password On UNIX and