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 MoreOracle 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 MoreSending 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 MoreHow 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 MoreReport 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 MoreRegion Interface – Shipping
Description: The post and steps describe the process of Region Interface – Shipping to create the country, state, city, and area Pincode with the help of interface and base tables.…
Read MoreParsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms
Description: In some cases, we get a comma-separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…
Read MoreMTL Material Transactions Interface
Description: This blog explains the technical approach for creating an automated interface to accept user-supplied material transactions from External Systems and to import these transactions to Oracle as Material Transactions.…
Read MoreHow to programmatically close PO using PO_ACTIONS API
Introduction This post is about to close PO using PO_ACTIONS API programmatically. PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass P_ACTION parameter value…
Read MoreSplit by count excel report in Oracle BI Publisher 10g
Introduction To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step 2: Go…
Read More