How to Install Oracle Forms & Reports 11g | DB 11g | Windows 10 part 3

Today we are going to Install Oracle Forms and Reports 11g with Database 11g in Windows 10 InshaAllah. part 3 HD

Patreon:   / omarbaig  

a. Navigate to "Data Blocks, EMPLOYEES, come to Triggers", Right Click on "Triggers", come to "SmartTriggers" & select "WHEN-NEW-RECORD-INSTANCE", assign this code
BEGIN
NAVIGATION_CONTROLLER;
END;
hit "compile" button.
b. Right Click on "Next" button, Right Click & select "SmartTriggers" & select "WHEN-BUTTON-PRESSED", assign this code
NEXT_RECORD;
hit "compile" button & close it.
c. Right Click on "Back" button, Right Click & select "SmartTriggers" & select "WHEN-BUTTON-PRESSED", assign this code
PREVIOUS_RECORD;
hit "compile" button & close it.
d. Right Click on "First" button, Right Click & select "SmartTriggers" & select "WHEN-BUTTON-PRESSED", assign this code
FIRST_RECORD;
hit "compile" button & close it.
e. Right Click on "Last" button, Right Click & select "SmartTriggers" & select "WHEN-BUTTON-PRESSED", assign this code
LAST_RECORD;
hit "compile" button & close it.
f. Save Form by clicking "Ctrl+S" or hit "Save" button.
g. Come to "File" tab & select "Exit"
h. Press "Windows+R" type "Regedit" & hit "OK" button.
i. Navigate to "HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE", come to "KEY_OH1290047565", select "FORMS_PATH" press "End" button, press ";", copy path
where "OBLibrary" is available "D:\Oracle_Forms_and_Reports_11g\11g_Project\Libraries" & paste it to "FORMS_PATH", & press "OK" button.
j. Open "Form Builder" again, come to "File" tab & select "Open", select "OBForm"
k. Come to this path "C:\11gR2\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config", take backup of "default" file then open it, come to "FORMS_PATH" press "End" button, press ";", copy path where "OBLibrary" is available & paste it accordingly,
save & close it.
l. Press "Ctrl+J", provide credential (hr/hr@orcl1111)h & hit Connect button.
m. Press "Ctrl+R" (in my case it is not finding web browser, Navigate to "Edit" & select "Preferences", Click "Runtime" tab, hit "Browse" button & assign Web Browser Location & hit "OK" button)

Creating Report
a. Come to "Oracle Classic Instance - asinst_1" & open "Start Reports Builder"
b. Check will remain on "Use the Report Wizard" & hit "OK" button.
c. Hit "Next" button.
d. Check will remain on "Create both Web and Paper Layout" & hit "Next" button.
e. Check will remain on "Tabular" & hit "Next" button.
f. Option will be "SQL Query" hit "Next" button.
g. Design Query from your choice, my Query will be
SELECT *
FROM employees e
WHERE e.salary BETWEEN :R_SALARY_FROM AND :R_SALARY_TO
& hit "Next" button.
h. Provide credential (hr/hr@orcl1111)h & hit Connect button.
i. Press "OK" button.
j. Click on "Move all items to target" button, hit "Next" button.
k. Click on "Salary", hit "Sum" button then hit "Next" button.
l. Hit "Next" button.
m. Option will be "No template" hit "Next" button. (You can use other option as well)
n. Hit "Finish" button.
o. Provide values for both Parameters and hit "Enter" button.

Search Tags:
Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Email through Oracle Apex 20.1 4K, Email through Oracle Apex 19.2 4K, Email through Oracle Apex 19.1 4K, Email through Oracle Apex 18.2 4K, Email through Oracle Apex 18.1, HOW TO SEND EMAIL USING ORACLE APEX, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, Create Setup Page in an Oracle APEX 20.1, Create Setup Form in an Oracle APEX 20.1, How to Create Setup Page in an Oracle APEX 20.1, How to Create Setup Form in an Oracle APEX 20.1, Create Master Detail Page in an Oracle APEX 20.1, Create Master Detail Form in an Oracle APEX 20.1, How to Create Master Detail Page in an Oracle APEX 20.1, How to Create Master Detail Form in an Oracle APEX 20.1, How to Create Dashboard in Oracle APEX, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Create Page Navigation, How to Create Link, How to Create Interactive Grid, Oracle APEX - Interactive Grid, Intro to Interactive Grid in Oracle APEX, HOW TO CREATE BUTTON IN ORACLE APEX, How to Create Button - Oracle APEX 20.1, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, Oracle APEX - Complete Guide to Dynamic Actions, Oracle APEX 20.1 - Format all Forms, Oracle APEX Installation, How to Install Android Studio on Windows 10, install android studio, Oracle APEX 20.2, Oracle APEX 20.2 Installation, install jdeveloper 12.2.1.4, install jdeveloper 12.2.1.3, install iReport 5.6.0, How to Install iReport 5.6.0 in Windows 10, Oracle APEX 21.1, Oracle APEX 21.1 Installation, How to Install Oracle APEX 21.1, How to install Oracle Database 18c Express Edition, How to install Oracle Database 19c, How to Install Oracle Forms & Reports 11g in Windows 10

#OmarBaig #OracleFormsReports11g #OracleFormsReports11gInstallation