Please follow to Add Services to a Single instance While the database is up, run the following as sys: alter system set service_names=’DB_DEFAULT_SERVICE, DB_HTML_DB, DB_DEV_SERVICE’ When you check lsnrctl it…
Read MoreIntroduction This blog explains how to reset the Oracle apps password from the backend. #Code# BEGIN FND_USER_PKG.UPDATEUSER (X_USER_NAME => ‘USERNAME’ , X_OWNER => ‘APPS’ , X_UNENCRYPTED_PASSWORD => ‘Pasword@123’ , X_PASSWORD_DATE…
Read MoreAdding Concurrent Manager is a crucial decision. Lots of things needs to be examined before adding new Concurrent Manager. One of the major area is resources.If you have less number…
Read Moreracle Workflow – Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] Oracle Order Management – Version 12.2.4 to 12.2.4 [Release 12.2] Information in this document applies to any platform. GOAL…
Read MoreWe are on Oracle Linux 6.5, Oracle Database 11.2.0.4, Oracle EBS 12.1.3 for all Self Service Application, under Oracle Application Manager, like – Workflow, License Manager, Patching and Utilities and…
Read MoreAPPLIES TO: Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. SYMPTOMS: E-Business Suite 12.1.3, IAS for Applications Technology…
Read MoreAPPLIES TO: Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1] Oracle Solaris on SPARC (64-bit) SYMPTOMS: Error in the Concurrent Manager Log File : ld.so.1: mail: warning: /usr/lib/extendedFILE.so.1:…
Read MoreSELECT men.* FROM( SELECT main_query.responsibility_name “Responsibility”, main_query.user_menu_name “Main Menu Name”, main_query.entry_sequence “Seq”, main_query.prompt prompt, main_query.user_function_name “Function”, main_query.func_descrip “Function Descrip”, main_query.sub_menu_name “SubMenu Name”, main_query.sub_seq “Sub Seq”, main_query.sub_prompt “SubPrompt”, main_query.sub_func “SubFunction”, main_query.sub_func_descrip…
Read MoreSELECT pov.segment1 supplier_number, povs.vendor_site_code supplier_site, pov.vendor_name supplier_name, poh.segment1 po_number, hrls.location_code ship_to_location, poh.currency_code, hrlb.location_code bill_to_location, poh.comments header_desc, poh.creation_date po_date, poh.authorization_status approval_status, pol.line_num po_line_no, pol.purchase_basis line_type, pp.segment1 project_code, pt.task_number task_code, expenditure_type, msib.segment1…
Read More/*Tax*/ FUNCTION add_gst_tax_req (p_req_id NUMBER) RETURN VARCHAR2 AS CURSOR c IS /* SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_organization_id, prla.destination_organization_id, prla.item_id FROM po_requisition_lines_all prla, jai_tax_det_factors jtd WHERE 1 = 1 AND prla.requisition_header_id =…
Read More