Tuesday, May 26, 2015

Query to drill down from PO header to shipment

›
SELECT poll.*   FROM po_headers_all poh,        po_releases_all pora,        po_lines_all pla,        po_line_locations_all poll  WHE...
Thursday, May 21, 2015

How To Disable/End Date/ Delete Responsibilities of a User from Backend/API

›
Below is the query. Please not Responsibilities cannot be deleted in Oracle Apps from a User. It can only be Disabled or End Dated. BEG...
Tuesday, May 19, 2015

Query to Find Database Version in Oracle

›
select * from v$version; Output:
Wednesday, May 13, 2015

FND DEBUG / FND LOG MESSAGES

›
What is FND Debug Log ? It helps you pinpoint the cause of error in standard Oracle Code, by making debug messages to appear in a centra...
Tuesday, April 28, 2015

Debug : javax.servlet.http.httpservletrequest cannot be resolved

›
You can do either of the following to resolve this error. Right-click the project tab, click Properties. Choose Build Path -> Java B...
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...