EBS Technical

Useful SQL Queries – Oracle EBS

Description:  To enhance performance, aggregate and analytic functions can each perform in parallel: multiple processes can simultaneously execute all of these functions. These capabilities make calculations, analysis, and reporting easier…

Read More

Useful Discoverer Queries

Description: One of the distinct steps is to find if all the necessary columns are available in the EUL, and this can be visually done through scanning the Business Areas…

Read More

Setting the VO query dynamically in OAF

Description: Generally, while creating the View Objects, we define a query to it. While rendering the OAF page, these view objects get executed (either by framework or by the java…

Read More

Sending E-mail with Excel Attachment Using UTL_SMTP

Description: The utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. The generic code is given to send e-mail with excel…

Read More

Performance Issue – Hierarchical query LEVEL

Description: A parts hierarchy, particularly the case of parts in a kit with the kit/assembly having multiple levels. Another example is parts succession, where older parts are replaced by newer…

Read More

Oracle Test Manager

  Description: Oracle Test Manager is an easy to use tool that allows you to organize and manage your overall testing process. It provides a single unified platform for sharing…

Read More

Oracle OpenScript

                                             Oracle OpenScript Description: OpenScript is the next-generation environment for developing Oracle Application Testing Suite scripts for Web application testing.   Features: 1)Scripting Workbench 2) Test Modules 3)Graphical/Tree View Scripting…

Read More

Sending E-mail with Excel Attachment Using UTL_SMTP

Description: The utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. The generic code is given to send e-mail with excel…

Read More

How to query BI bursting

Description:   One of the very good features of Oracle BI Publisher is its ability to burst and send the reports to multiple users simultaneously. Using BI Publisher’s bursting feature, we can split a single batch report into individual reports to be delivered to multiple destinations. We can apply a different template,…

Read More

Report Builder Components

 Description: Report Builder is a report creation tool which allows users to create, manage, and publish reports to SQL Server Reporting Services. We can also create shared datasets with the…

Read More