OracleAppsToday

All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks

Monday, April 13, 2015

How to use plsql collections in select statment

›
Step 1 : Declare Collection type Globally For Example:  Test_Coll can be declared globally as "TYPE  Test_Coll IS TABLE OF INTEGER...
Friday, April 3, 2015

How to send Concurrent Program output as an Email

›
There are two Methods to send Concurrent Program Output as Email Method 1: The printer styles have to be configured to execute a shell s...
1 comment:
Friday, March 27, 2015

Oracle Apps R12 Query to Find Payment against Invoice

›
SELECT b . segment1 vendor_number ,        b . vendor_name vendor_name ,        c . vendor_site_code ,        c . pay_group_look...
Wednesday, January 28, 2015

Query to find the parent request id recursively

›
SELECT request_id,   description FROM fnd_concurrent_requests WHERE NVL (request_type, 'X')        = 'M'   CONNECT BY PR...
Wednesday, November 19, 2014

Credit Card Validation Oracle EBS R12

›
Introduction Have you ever encountered the below validation failure for credit card in EBS R12. Validation failed for the field - Credi...
Tuesday, November 18, 2014

Query to find Credit Card Type in EBS R12

›
To Check the Valid Credit Card Type in R12. Execute the query below. SELECT lookup_code,       meaning,       enabled_flag,       star...
1 comment:
Sunday, November 9, 2014

Types of Invoice Class in AR Transaction

›
Invoice : A document that you create that lists amounts owed for the purchases of goods or services, any tax, freight charges and payment te...
6 comments:
Monday, October 27, 2014

Cash Flow Statements : Accounting Basics Day 9

›
Introduction Cash flow statement provides considerable information about what is really happening in a business beyond that contained in...
1 comment:
Friday, October 17, 2014

Query to derive Qualifier Attribute and Context from Modifier Name

›
Query : SELECT    c.list_line_no "Modifier Line No",   b.name "Modifier Name",   b.description  "Modifier Desc...
Wednesday, October 15, 2014

The Treatment given to Adjusting entries

›
Below is the chart to identify how adjusting entities are marked in accounting. Click here to go back to Accounting Basics Day 8...
‹
›
Home
View web version

About Me

Unknown
View my complete profile
Powered by Blogger.