OKS_AUTH_UTIL_PUB.COMPUTE_PRICE_MULTIPLE_LINE API in Service Contracts

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

Custom QA Check for Service Contracts

Here is new post on how to add Custom QA Check for Service Contracts.

Below are the steps to be followed:

ego_item_pub.process_item

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 the Item Attributes

OE_ORDER_HEADERS, OE_ORDER_LINES

Execute the below SQL query in SQL Developer or TOAD in APPS Instance.

Query :

  1. Select * from OE_ORDER_HEADERS
  2. Select * from OE_ORDER_LINES


You notice that these queries do not fetch any records. Ofcourse, these are views derived from their base tables OE_ORDER_HEADERS_ALL,OE_ORDER_LINES_ALL

So, what you do in order to fetch all the records? Ofcourse, the above query may not be of use,but when you are working on complex queries with joins and working on SQL Developer,you need to verify the records.

Form Personalization window goes beyond the current screen in Service Contracts

Hi All,

I was working on the form personalization for Price Adjustment in Service Contracts and I did find some strange issue which made me wonder, and took much of time in analysing this.

Here goes the details about this issue :

Defaulting a value in Contract Lines DFF in Service Contract form.

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 with the value.
This can be achieved through the use of CUSTOM.PLL.

This is just a sample piece of code, to be added to the CUSTOM.PLL, which can modified according to the requirements.

FNDLOAD Command - for Updating an existing message

Here is a FNDLOAD upload command for updating an existing message.

FNDLOAD apps/<pwd>@<oracle instance> 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MSG_TO_UPLOAD.ldt CUSTOM_MODE=FORCE

Calling Stored procedure through Forms Personalization

Here is my first post, Calling stored procedure through Forms Personalization in Oracle apps for the user entered values.

Following are the steps to be followed :