Sample example for DataLoad - Part 1

Before, I provide sample example for DataLoad, would like to provide some background information on this Tool.

DataLoad

This is one of the very useful tool for end users/technical developers used across Oracle Ebusiness Suite for entering large number of records.Say for example, If you want to enter 1000's of records into Sales Order screen, then using the DataLoad tool will be much faster and quicker. The tool provides other functionality too. Please refer the DataLoad which provides more information. Free version of the tool is available at the site.

Creating Text form field in BI Publisher

This is a new post on BI Publisher - RTF development.

I was working on one of the RTF template changes as part of my fixes and I was looking for adding some conditions to the template.

Steps to modify CUSTOM.PLL

Here are the steps in short to modify CUSTOM.pll file - R12

Tool to compare two files - Beyond Compare

Here is a good tool, to compare two files, Beyond Compare. Trial version of the software is available.

Steps to create Invoice for a Service Contracts - Testing Data

Most of the time, when you are working with the service contracts and invoice, you might require to create some dummy test data in order to test Invoices reports.

Here are the steps to create an Invoice for a Service Contract in Oracle Applications(R12)

Error in BI Publisher : NoAvailableAreaException

I was trying to fix some issue in XML Publisher report and was doing some changes in Account statement RTF. Once after the changes,I  tried to upload the XML and preview the data in PDF in BI Publisher(MS-Word).

But, to my surprise I got following error :

okc_price_adjustment_pub.create_price_adjustment - API to create new price adjustment record

Here is sample snippet code for creating new price adjustment record for a Service Contract in R12

Fetch the line details for a given Service Contract.