Here is sample piece of code, for the API OKS_AUTH_UTIL_PUB.COMPUTE_PRICE_MULTIPLE_LINE in Service Contracts.
Monday, 28 March 2011
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:
Below are the steps to be followed:
Thursday, 24 March 2011
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
API : ego_item_pub.process_item, update the Item Attributes
Wednesday, 23 March 2011
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.
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.
Monday, 21 March 2011
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 :
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.
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.
Sunday, 20 March 2011
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
FNDLOAD apps/<pwd>@<oracle instance> 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MSG_TO_UPLOAD.ldt CUSTOM_MODE=FORCE
Friday, 18 March 2011
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 :
Following are the steps to be followed :
Subscribe to:
Posts (Atom)