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 MoreDescription: 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 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreIntroduction 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 More