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 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 MoreBreak Comma Separated String
1. Overview This document will be helpful to print comma separated string with the new line report 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case To display comma separated…
Read MoreInsert script with error log table
1. Overview This document will be helpful to insert data from intermediate table to source table with error log table 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case Load…
Read MoreAdd Shortcut key to Apex IG
1. Overview This document will be helpful to add shortcut key for Add row and filter in Interactive Grid. 2. Technologies and Tools Used The technology used is JavaScript 3.Architecture Steps…
Read MoreGenerate DDL By comparing 2 Schema.
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates scripts for missing…
Read MoreTable Alter Script by comparing 2 schema
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates alter scripts…
Read MoreProtect Row Update & Delete in IG
1. Overview This document will be helpful in protecting updation on a row based condition in Oracle apex interactive Grid. 2. Technologies and Tools Used Oracle Apex code. 3. Use Case In…
Read MoreExcel upload in Apex
1. Overview This document will be helpful to upload a excel file directly and view it as a report. 2. Technologies and Tools Used Oracle Plsql. 3. Use Case Customer wants to upload…
Read MoreMetadata Script
1. Overview This document will be helpful to generate DDL scripts of objects using Oracle Plsql. 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case To migrate Scripts from development…
Read More