Oracle Applications

Last week, i had issue where I wanted to display the Header column information in all the pages in BI publisher. The output was displayin...

Here is a snippet of code which tells about the mandatory columns needed to insert the data into BOM Interface tables.

Here is a sample script which uses standard Oracle API pa_proj_template_setup_pub.create_project_template to create Project template in Proj...

Here is a sample example of Create Task API used in R11i. This example shows how to create a Open task and assign it to a employee.

I was looking for one of the funtion in XML for my requirement in RTF in order to display based on the length of the string. Here goes tha...

While doing one of the forms personalization in Service contracts in Price Adjustment screen, I have encountered this strange behavior of th...

Here is sample method of ending dating the Price List line for a Item in Service Contracts using API : qp_price_list_pub.process_price_list ...

Here is a  sample anonymous PL/SQL block which will reset the Oracle Apps frontend password for a given user from backend

Here is a small snippet of XML tags which tells you how to add  if - else condition in XML Publisher RTF template.

The following example will show you, how to set the Discount for the Service Contract Lines and how to price the Service contract lines.

This is last part of the DataLoad example.

In my last previous post, we have successfully created a DataLoader script file. This post will resume loading data from that script to the ...

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

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 looki...

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

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

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 ...

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 ...

Here is sample snippet code for creating new price adjustment record for a Service Contract in R12 Fetch the line details for a given Serv...

Here is sample piece of code, for the API OKS_AUTH_UTIL_PUB.COMPUTE_PRICE_MULTIPLE_LINE in Service Contracts.

Here is new post on how to add Custom QA Check for Service Contracts. Below are the steps to be followed:

Here is an example of updating the attributes of an Item using the API ego_item_pub.process_item. API : ego_item_pub.process_item, update ...

Execute the below SQL query in SQL Developer or TOAD in APPS Instance. Query :   1. Select * from OE_ORDER_HEADERS   2. Select * from O...

Hi All, I was working on the form personalization for Price Adjustment in Service Contracts and I did find some strange issue which made m...

Hi All, Here is a topic on defaulting a value in Contract Lines DFF in Service Contract form, whenever the Ship To Account is entered...