1.Overview This document explains about how to perform unit testing using selenium web driver in Oracle Apex. Selenium Web Driver is a web framework that permits you to execute cross-browser…
Read Moreselect MAX(CASE WHEN seq =1 THEN parent_lot_number END) parentlot1, MAX(CASE WHEN seq =2 THEN parent_lot_number END) parentlot2, MAX(CASE WHEN seq =3 THEN parent_lot_number END) parentlot3, MAX(CASE WHEN seq =4 THEN…
Read MoreSELECT ppf.person_id, ppf.person_number, paam.assignment_number, to_char(ptp.start_date,’YYYY/MM/DD’) startdate, to_char(ptp.end_date,’YYYY/MM/DD’) enddate, ptp.period_name, to_char(trunc(sysdate),’YYYY/MM/DD’) executiondatetime FROM pay_payroll_actions ppa, pay_payroll_rel_actions pra, pay_assigned_payrolls_dn apd, per_all_assignments_m paam, pay_time_periods ptp, pay_rel_groups_dn prg, per_all_people_f ppf, pay_all_payrolls_f py, pay_consolidation_sets pcs,…
Read MorePROCEDURE xxbom_explode_bom_for_abc(i_item_id IN NUMBER, i_organization_id number, i_num_so_line_id number) IS g_chr_excp_msg VARCHAR2(4000); g_chr_log_msg VARCHAR2(4000); g_dte_sysdate DATE := SYSDATE; g_num_elig_comp_exist NUMBER := 0; g_num_item_inc NUMBER := 0; v_num_boe_open_qty NUMBER; v_num_bill_sequence_id NUMBER; v_rec_inc…
Read MoreTransfer the CLOB variable to third party system using https protocol and java concurrent program. package xxpo.ebs; import java.io.IOException; import oracle.apps.fnd.cp.request.CpContext; import oracle.apps.fnd.cp.request.JavaConcurrentProgram; import oracle.apps.fnd.cp.request.LogFile; import oracle.apps.fnd.cp.request.ReqCompletion; import oracle.apps.fnd.util.NameValueType; import…
Read MoreThis blog is intended for Oracle Application DBA’s who have issues generating Integration Repository loader file (iLDT). Exposing Oracle E-Business Suite PL/SQL packages a web services requires the creation of…
Read MoreOracle Database 19C Timezone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179 This blog is intended for Oracle DBA’s who are tasked with patching the database. ISSUE:…
Read MoreOverview : It’s used to reprocess the Apex Login Page using Number Captcha. After the reprocessing The Login Page will ask the correct answer. If we enter the correct answer,…
Read MoreTable of Contents Contents Contents 2 Overview 3 Technologies and Tools Used 3 Use Case 3 Architecture 3 5.Conclusion6 1.Overview It is simple to combine the application pages into one page. When we employ the drawer idea. This new feature of Oracle Apex allows us to pull in several pages onto one page. 2. Technologies and Tools Used The following technology has been used to achieve the same. SQL Oracle Apex 3. Use Case We As an example, let’s look at a single modal dialogue page. and we can click the Page tab, choose Appearance, set the drawer page, assign the button, and simply drag the page. 4. Architecture Following steps explains in detail, Step 1: Create a region, give it a name, set the button left drawer, and create a region. Step 2: Next The dialogue page template can be chosen in the Appearance box when creating a modal dialogue page. Drawer Step 3: then the Main page was Collapisled by the Button Behavior table, which had been set to redirect to the page from the multiple pages.…
Read MoreTable of Contents Contents Contents 2 Overview 3 Technologies and Tools Used 3 Use Case 3 Architecture 3 Conclusion.6 1.Overview The new data package of feature offers it extremely easy for application deployment together with data underlining table, thus we can effortlessly migrate the apps from one instant to another. 2. Technologies and Tools Used The following technology has been used to achieve the same. SQL Oracle Apex 3. Use Case We can easily migrate the applications one instant to another along with data in under line table the new data package of feature makes an very easy for application deployment along with data underline table. I want to move the application quickly along with data in tables another instants. 4. Architecture Following steps explains in detail, Step 1: Go to the supported object first, then select the installation script. Step 2: After clicking create, choosing the database object, choosing the table, and entering the name and object type Step 3: type the name, choose the tables, and then click the table’s details.…
Read More