| Problem in achieving AP customization [message #186286] |
Mon, 07 August 2006 05:35  |
deepayan
Messages: 51
Registered: December 2005
|
Member |
|
|
dear all,
I have to do some customizations in Oracle Payables.In Oracle Payables I have a DFF named 'Invoice Distribution' .I added two fields in this DFF.("From Date" & "To Date").Now I want that when I will give a particular value (say "Warranty amortization") in expenditure type field of the distribution form ,then this two("From Date" & "To Date") field will be mandatory.
How can I achieve this? Is it possible through custom pll.
Please help.I m new in oracle apps.Thanks in advance.
----------
Deepayan.
|
|
|
|
|
|
| Re: Problem in achieving AP customization [message #186663 is a reply to message #186286] |
Tue, 08 August 2006 23:25  |
deepayan
Messages: 51
Registered: December 2005
|
Member |
|
|
hi,
Finally I got the solution yesterday. I have made the fields mandatory by using custom pll. In custom pll I just added one condition when validationg record.
if (blockname.attribute is null) then
fnd_message.debug('please put dates');
Raise form_trigger_failure;
end if;
block name is the block where the DFF exists.you can get this by oracle application help->
attribute is column name of the field of the DFF.
this is working fine.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
