Follow the steps given below to call APEX application from EBS, Step 1: Create an Oracle Apex Application and go to Shared Components => Application Items, then create the following items, Application Items Scope: Application Session…
Read MoreFade Out Alert Message In Oracle Apex The fadeOut() method gradually changes the opacity, for selected elements, from visible to hidden (fading effect). Note: Hidden elements will not be displayed at all (no longer affects the layout of the page). Syntax: $(selector).fadeOut(speed) speed Optional. Specifies the speed of the fading effect. The default value is 400 milliseconds Possible values: · milliseconds · “slow” · “fast”…
Read MoreAP invoice should not be selected by any other PPR The payment schedule’s relevant date should be between the PPR’s Pay From and Pay Through dates. The relevant date…
Read MoreTTK Healthcare is an established name in the Indian healthcare industry with a leading presence in consumer products, pharmaceuticals, bio-medical devices, foods and maps. TTK Healthcare and Doyensys share a…
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 MoreBy using batch mode and COA setups with separator defined in system custom Web ADI been developed in EBS application and integrated with custom template using PO interface. Pre-…
Read MoreData Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high…
Read MoreDBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.…
Read More