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. 

• Script to enable attachments for a custom Form in PO
• Example of Extract Query
• Roles and Responsibilites: New Purchase Module

• 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
• Sample Code Supplier Outbound Interface AP

• 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

• How Does Fund Transfer Work in R12

• 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
• Refund Customer the Payment
• Cannot Re-Open AR Period

• 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

• Running Refresh Project Summary in load balanced
• Running Update Project Summary Amounts in Load Balanced Batches

• Function to calculate and return Balances
• Changing Employee Number Generation from Manual to Automatic
• How To Add Form To Responsibility Menu

• 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

• Script create data dict 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 records
• Script to display status of all the Concurrent Managers
• Removing Table Lock
• SQL Script to create control file for a table

• 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
• Which Objects Belonging to a Particular Schema are Kept in Buffer Pool
• 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 tDBMS_UTILITY Of Oracle8i/9i
• Powerful OLAP Functions Introduced in Oracle9i Onwards
• Using the Java Stored Procedure in PL/SQL Procedures and Functions

• Introduction To Oracle Financials
• Oracle Financials Faqs
• Default Value In Text Filed Through Personalization
• Oracle Financials Questions And Answers #1
• Oracle Financials Questions And Answers #2

• Oracle Apps Interview Questions #1
• Oracle Apps Interview Questions #2
• Oracle Apps Interview Questions #3
• Oracle Apps Interview Questions #4

• 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 Forms Personalization FAQ

• 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

• FTP concurrent program
• SQL function to validate credit card number
• SQL script to print record wise data in a SQL *PLUS enviroment from 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

• 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 find out active Responsibilities assigned to User Ver 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 enable attachment on Customer Biz Purpose Block in Accounts Recv
• E-mailing Report Output to User (Method 2)
• Preserving Custom Menus During 10SC Upgrade
• Moving Menu from one App 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 find cross-references to Lookup TYPE, CODE and MEANING
• FRM-40654: Record has been updated error when column queried in a form
• Display Message/Exception on the Form from Database Trigger
• Select statement find status, duration, other details of concurrent program(s)

• Schedule RMAN Jobs In Windows Server

• RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL and AR_PAYMENT_SCHEDULES_ALL
• Using Fndload Transfer AOL Objects From Instance
• AR_RECEIVABLES_TRX_ALL and AR_RECEIVABLE_APPLICATIONS_ALL

Return to : Oracle Database, SQL, Application, Programming Tips