Monday 30 May 2011

Mandatory columns needed to insert data into BOM Interface tables.

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

Tuesday 24 May 2011

Project template creation in PA using standard API.

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

Monday 23 May 2011

Sample example of Create Task API in CRM

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.

Tuesday 17 May 2011

Count characters in a value in XML Tag in XML(BI Publisher)

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 that function, which is used to count the number of characters in a string in XML Publisher RTF.

Monday 16 May 2011

Error in Price Adjustment screen : Invalid value for the field ADJUSTMENT_NAME

While doing one of the forms personalization in Service contracts in Price Adjustment screen, I have encountered this strange behavior of the form. The form personalization is related to defaulting the value of the Modifier Number field, whenever the user navigates to the Price Adjustment screen in R12. Following which, I have raised a SR with Oracle and fix was provided for the issue.

This topic is related to that behavior in Price Adjustment screen.

Saturday 14 May 2011

End dating the Price List line in Service Contracts using the API qp_price_list_pub.process_price_list

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


Script to reset Oracle Apps frontend User ID Password

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

Thursday 5 May 2011

if - else condition in XML Publisher

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


Wednesday 4 May 2011

Setting Discount to Service Contract Lines

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

Tuesday 3 May 2011

Sample example for DataLoad - Part 3

This is last part of the DataLoad example.


Monday 2 May 2011

Sample example for DataLoad - Part 2

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