Detailed Margin Report
1.Overview This document talks about getting the report of detailed sales margin by customer by invoice by item (both Invoice and credit memo). 2.Technologies and Tools Used The following technologies…
Read MoreHow to create and execute a bot using UI Path
What is RPA – Robotic Process Automation? RPA is software that can emulate actions typically performed by humans on a computer & can perform most of your repetitive tasks more…
Read MoreSales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected…
Read MoreBACKUP BASED DATABASE CLONING
Before cloning we have to take full database backup using RMAN Target / COMMAND: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Once completed,move the backup file to target server USING SCP BACKUP…
Read MoreSolution to not logged on error and up the database
Solution to not logged on error and up the database ORA-01012: not logged on error ERROR ERROR at line 1: ORA-01012: not logged on Process ID: 0 Session ID:…
Read MoreSWITCH OVER IN DATAGUARD
SWITCH OVER IN DATAGUARD CHECK THE FOLLOWING IN PRIMARY AND STANDBY STEP-1 STANDBY -Keep the database in mount state -keep the standby in MRP mode STEP-2 FIND THE…
Read MoreSmart Filters in Classic Reports
Introduction This document talks about how to use smart filters in classic reports. It provides users to filter the data easily and find the necessary records. It is used in…
Read MoreCreating Pie and Combination Charts in Oracle Apex 22.2
Introduction This document talks about how to create pie and combination charts in Oracle Apex 22.2. This will depict a clear picture to understand for users. Why we need…
Read MoreGenerating an Excel file and Sending an Email using Oracle Apex
Overview : The process of generating an Excel file and sending it as an email attachment using PL/SQL packages in Oracle Apex is a powerful solution for automating the task…
Read MoreAdvanced Customization of LOV Items in Oracle Apex
Overview : Oracle Apex is a powerful platform for rapid application development that enables developers to create dynamic web applications effortlessly. The advanced customization of LOV items in Oracle Apex…
Read More