Oracle Financials Forums 
This is an email discussion group for ALL ORACLE FINANCIALS MODULES (General Ledger, Account Payable, Receivable...)  to share information and request assistance from  ORACLE PEERS around the world.   The discussion topics should be focused on All Oracle Financials related issues. 

Oracle Payables
Script to change check numbers at the table level
Match Credit Memo To Purchase Order
Prepayments Available To Particular Vendor
Account Payables Period Closing Process
Deleting Old Invoices From AP_INVOICES_ALL
Doing Payment Batches In R12

Oracle General Ledger 
Change Set of Books Name
Changing default GL account type
How Many Interface table in GL, AR, AP
Creditors Ledger After GL Posting
Invoice Data From Account Payables To General Ledger
Record Count And Total For Open and Closing Balance
Currency Translation GL R12
No Approval Rule And Approval from APPROVER

Cash Management
How Does Fund Transfer Work in R12

Oracle Receivables
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
Handling Canadian and US tax together in one Set of Books
Calculate VAT on Freight
Perodic Alert to e-mail AutoInvoice Error details
Create Tax only lines (TAX ONLY INVOICES)
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?

Lockbox
Importing deposits using Lockbox
Lockbox Interface : Load Overpayment/Remaining Amount as On-Account
Lockbox Interface : Load Overpayment Remaining Amount as On-Account
Lockbox Interface to exclude tax and freight
What Is Lockbox In AR

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
Script to load or convert Notes/Attachments associtaed with items
Coping Items using Item Interface
Prevent transactions in Master Inventory Organization

Oracle Applications DBA Script
Script create data dictionary combines Oracle dictionary with 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 E-Business Suite 11i: Implementing Core Financial Applications

Oracle General Ledger Guide

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 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
List Of Open Interfaces and API In R12
Using Asset Category Flexfield
Types Of User Exits In Oracle Apps

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
'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 find status, duration, and other details of concurrent program(s)

Windows
Schedule RMAN Jobs In Windows Server