SELECT hca.account_number,
hcsu.site_use_id,
hca.cust_account_id
INTO l_customer_number,
l_cust_site_use_id,
l_cust_account_id
FROM hz_cust_accounts_all hca,
hz_cust_acct_sites_all hcas,
hz_cust_site_uses_all hcsu,
IBY_ACCOUNT_OWNERS IAO,
IBY_EXT_BANK_ACCOUNTS IEBA
WHERE hca.cust_account_id = hcas.cust_account_id
...
Friday, August 7, 2015
Tuesday, June 23, 2015
Oracle Apps : Steps to Implement Employee/Supervisor Approval Hierarchy
Purchasing-> Setup-> Organization-> Financial Options
Uncheck “Use Approval Hierarchies”
Purchasing-> Setup-> Purchasing-> Document Types
Click the update icon for specific document as in our case “Standard Purchase Order”
“Owner Can Approve” should be Unchecked.
“Default Hierarchy” should be left blank.
HRMS Manager-> People-> Enter and Maintain-> Find->Assignments
Select...
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 Manager-> People-> Enter and Maintain ->New
Click Assignment Button to Assign Job and Position
Assign Job and Position
Assign Employee to User
Go to System Administrator -> Security - > User
If Employee is not a buyer, We will get a pop-up as below
Press “Add Buyer” Button to make...
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';
Below is the API to apply hold using Standard Oracle API :
PROCEDURE inv_hold (p_invoice_id IN NUMBER,
p_reject_code IN VARCHAR2,
p_hold_val_status IN VARCHAR2,
...
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 = 'RTF'
AND a.template_code = 'XXXBITEMPLATE'...
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
WHERE poh.po_header_id = pora.po_header_id
AND pla.po_line_id = poll.po_line_id
AND poll.po_release_id = pora.po_release_id
AND poh.segment1 = :po_number
AND pora.release_num = :po_release_num
AND pla.line_num...
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.
BEGIN FOR I IN (SELECT fu.user_id, fu.user_name, furg.RESPONSIBILITY_APPLICATION_ID, ...
Tuesday, May 19, 2015
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 centralized table named FND_LOG_MESSAGES.
You can design and build your custom extensions in a manner that can easily be debugged. This can be done by calling Oracle delivered API’s in your custom code.
A program written in any technology, either form, report, PL/SQL, java concurrent program, OAF...
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 Build Path
Choose Add External JARs
Browse to find and select servlet-api.jar which should be present in ...\apache-tomcat-7.0.61\lib\
Click OK to update the build path.
OR
you can simply copy the servlet-api.jar present in ...\apache-tomcat-7.0.61\lib\ and copy that jar files into lib folder, which...
Subscribe to:
Posts (Atom)
