Importing deposits using Lockbox
Changing Customer Name
Gift certificates in AR
Load fields which are missing in CUSTOMER INTERFACE tables
Increasing AutoInvoice Performance
AutoInvoice Interface not loading TAX Lines
AutoInvoice error : Data Not found
Update due date of an invoice
Lockbox Interface : Load Overpayment/Remaining Amount as On-Account
Handling Canadian and US tax together in one Set of Books
Lockbox Interface : Load Overpayment Remaining Amount as On-Account
Calculate VAT on Freight
Perodic Alert to e-mail AutoInvoice Error details
Create Tax only lines (TAX ONLY INVOICES)
Lockbox Interface to exclude tax and freight
AutoInvoice Error:Too many rows returned
Adding new segment in Chart of Accounts and Autoaccounting
Script to identify problems with AR_PAYMENT_SCHEDULE table
Closing Customer Calls
Script to list all the trasactions that doesn't have a valid code combination
Shell script to daily submit AutoInvoice with CONCSUB
Invoice Number Skipping Problem
How to Customize your dunning letters for a language change?
Oracle Project Accounting
Running
Refresh Project Summary in load balanced
Running
Update Project Summary Amounts in Load Balanced Batches
Oracle HR/Payroll
Function
to calculate and return Balances
Changing
Employee Number Generation from Manual to Automatic
How
To Add Form To Responsibility Menu
Oracle Order Entry
Invoices
with option to pick price from OE Price List
Usage
of S flags in SO_HEADERS and SO_LINES
Receivable
Interface Not Working
Adding
Custom Reports to Standard Document Sets in Order Entry
Cleanup SO_EXCEPTIONS
Table
Oracle Inventory
SQL
script to generate Item Cross References
SQL
query to display Items in a multi-org setup which have been created or
modified within the past 30 days, or which will be made effective at some
future date
Script
to load or convert Notes/Attachments associtaed with items
Coping
Items using Item Interface
Prevent
transactions in Master Inventory Organization
Application Object Library
Display
user defined messages from a registered PL*SQL program
Document Sequencing
Steps
to run a concurrent program from Database Trigger
Query
only GUI Forms
Steps
to Resolve Custom Table Alert Problem
Multi-Org
and Customization
Registering
Custom Applications on the 10SC Client
Register
shell scripts as host programs in Oracle Applications
SELECT
statement to find out all the active Responsibilities assigned to a
User
(Version 2.0)
Cut &
Paste Excel Macro (SC Version)
Cut
and Paste Excel Macro (NCA Version)
SQL
script to lists all the profile settings
E-mailing
Report Output to User (Method 1)
Script
to register and unregister Custom Tables and Columns
SQL
script to display status of concurrent programs ran on a particular date
SQL
script to list all the registered concurrent programs by Module
Script
to enable attachment on Customer Business Purpose Block in Accounts Receivable
E-mailing
Report Output to User (Method 2)
Preserving
Custom Menus During 10SC Upgrade
Moving
Menu from one Application instance to Another Application Instance
View other users
reports
Steps to register
a custom applications on the server
Complex
Queries In Oracle Application Forms
A
'Lookup' query to find cross-references to Lookup TYPE, CODE and MEANING
"FRM-40654:
Record has been updated" error when column is queried in a form
Display
Message/Exception on the Form from Database Trigger
Select
statement to find out status, duration, manager queue and other details
of concurrent program(s)
Oracle Applications DBA Script
Script
to create a data dictionary listing which combines the Oracle dictionary
with the Oracle Apps dictionary
SQL
script to display the oracle connections and perf stats
Script to
Reorganize Indexes
SQL
query which list owners and table names and then count the records in each
Script
to display status of all the Concurrent Managers
Removing Table Lock
SQL
Script to create control file for a table
Oracle Application Tuning
Regarding
the Tuning of Oracle 8i
Memory
Tuning Aspects
Regarding
the Pinning of the Objects in the Shared Pool
Giving
Access to Some of DBA Package to the NON-DBA Users
To
know Which Objects Belonging to a Particular Schema are Kept in Buffer
Pool
To
Query all the the Tables which are Cached Query the View DBA_TABLES
Set
the BufferPool_Keep Size Accordingly in the init.ora File
Transportable
Set of the Tablespaces
Getting
Random Population/Sample Using the DBMS_UTILITY Of the Oracle8i/9i
Powerful
OLAP Functions Introduced in Oracle9i Onwards
Using
the Java Stored Procedure in PL/SQL Procedures and Functions
Oracle Reports
Signal 11
Problem with Running Bit Map
Reports (Formatter Error)
Registering
a Report or PL/SQL program on Oracle Applications
Steps
to modify a seeded Oracle Applications Report
Generating
Acrobat/PDF output
Making
the custom reports Oracle Applications compliant
Oracle Miscellaneous
FTP concurrent program
SQL
function to validate credit card number
SQL
script to print record -wise data in a SQL *PLUS enviroment from a table
How
to display the column value adjacent to each other?
How
to Read Bar Codes in Oracle Forms
SQL.sql: A
query to write queries
How
to find the exact hrs,min,sec difference between two dates?
How
to select the one column per row in display?
Putting
a Descriptive Flexfield in a Form
Return to : Oracle
Database, SQL, Application, Programming Tips