Friday, August 7, 2015

Query to Derive Customer Number, Site Use ID from Customer Bank Account Number

›
SELECT hca.account_number, hcsu.site_use_id, hca.cust_account_id INTO l_custo...
Tuesday, June 23, 2015

Oracle Apps : Steps to Implement Employee/Supervisor Approval Hierarchy

›
Purchasing-> Setup-> Organization-> Financial Options Uncheck “Use Approval Hierarchies” Purchasing-> Setup->...
Monday, June 22, 2015

Oracle Apps : Steps to implement Position Hierarchies

›
Create a User System Administrator -> Security -> User Assign Purchasing and HRMS Responsibility Create Employee HRMS Ma...
Tuesday, June 9, 2015

Oracle Apps : Apply AP Invoice Hold using API

›
The hold codes can be extracted from query below. SELECT *   FROM ap_hold_codes  WHERE hold_type = 'INVOICE HOLD REASON'; Belo...
Thursday, June 4, 2015

Query to Find Attached Template Name from Template Code

›
SELECT template_code, file_name   FROM xdo_templates_b a, xdo_lobs b  WHERE     b.lob_code = a.template_code        AND b.xdo_file_type ...
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...