At my client site, this is another program that found to be slow. List of sql causing performance bottleneck are listed below.
Saturday, April 28, 2012
Payment Process Request Program is SLOW
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
During my work, sometimes I come across some information that I am sure to forget in a given time period. So I started this blog to post such information for future use. If it is of any use to you, please let me know.
Posts
Followers
Categories
- Accounts Payable (28)
- Accounts Receivable (18)
- API Examples (1)
- Can You Please answer these Questions (1)
- DBA Tips for developers (22)
- Example Scripts (4)
- FND (Application Object Library) (54)
- How to Debug (11)
- Linux (2)
- Oracle Alert (1)
- Oracle Analytic (1)
- Oracle and XML (3)
- Oracle Forms (7)
- Oracle General Ledger (3)
- Oracle Inventory (4)
- Oracle Magzine Articles (2)
- Oracle Order Management (14)
- Oracle Payments (22)
- Oracle Pricing (7)
- Oracle Projects (4)
- Oracle Purchasing (3)
- Oracle Reports (3)
- Oracle Support (2)
- Python Programs (1)
- Ready for Delete (2)
- References (4)
- Release 12 Upgrade (7)
- Self Service (1)
- SQL Developer (2)
- Sql Examples (4)
- SQL Hints (1)
- Sqlplus Tricks (15)
- Trading Community Architecture (19)
- Workflows (2)
- XML Publisher (8)
- zGeneral (6)
- zMy Thoughts (4)
- zQ (1)
Total Pageviews
Popular Posts
-
Contact point such as Phone, Email or UL can be attached to a customer at multiple levels such as Customer itself, Customer's Address o...
-
This simple script shows how to use FND_PROFILE.save function. This could be of some use when you need to save multiple profile options for ...
-
Bank Account can be associated with Supplier at following levels 1. Supplier 2. Supplier site 3. Party Site 4. Party Site + Org This query c...
-
SET SERVEROUTPUT ON size 1000000 DECLARE l_req UTL_HTTP.req; l_resp UTL_HTTP.resp; l_buffer VARCHAR2(32767); l_body VARCHAR2(327...
-
This query can give details of a Oracle Application Responsibility and list of menus and functions that are excluded from that responsibil...
-
DECLARE l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type; l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type; l_co...
-
Bank and Bank branches are stored in HZ_PARTIEES. Bank and Bank Branches have PARTY_TYPE value as ORGANIZATION. Bank_id and bank_branch_...
-
This is a simple table. I saved this query to remind myself that phone, fax and email entered on Supplier Address region are stored in hz_c...
-
DECLARE l_coa_id gl_sets_of_books.chart_of_accounts_id % TYPE; l_ccid gl_code_combinations.code_combination_id % TYPE; l...
-
I have a custom pl/sql program that applied credit memos and receipts to invoices and debit memos. At the end of program i wanted to see wha...
No comments:
Post a Comment