Apps To Fusion

...
written by Ashwini , June 23, 2008

Thanks Anil.

Buitin type- execute procedure
written by Josephin , June 25, 2008

Hello Anil, I am a consulatnt in USA and my client wants the sysadmin user form to be personalizied. Whenver for an user a new responsibility is added or an existing responsibility is end dated , an email has to be sent out. I have tried using Builtin type to be execute procedure. But I am getting syntax errors.

In the following syntax:

='declare
v_field_value VARCHAR2(200) ;
begin
plsql_package.procedurenameHere ;
end'

what shuld be v_field_value and also I am not sure plsql_package.procedure to name it for my procedure. Please help as I am a beginer. Thanx much.

using Stored function to be used in a forms personalization
written by Sean Mark , June 30, 2008

Hi Anil,
I'm new in using Forms Personalization just want to ask some questions regarding this..

when I put this in the argument column an error occurs when apply now button is pressed

= ' declare
xx_output BOOLEAN;
begin
xx_output := XX_FLAG_HEAT_FUNC ( :GME_BATCH_STEPS.BATCHSTEP_ID, :GME_BATCH_STEPS.BATCH_ID, :GME_BATCH_STEPS.ROUTINGSTEP_ID);
end'

could not be evaluated because of error ORA:01403 no data found..

the output on this function is just Boolean (TRUE or FALSE).

Please advise on this..
Thanks.

Sean

...
written by Anil Passi- , June 30, 2008

Hi Sean

I have never used ":" in for this purpose.
Please refer to the sample posted in this article and copy paste & modify the same to work for your field/procedure.

Thanks,
Anil Passi

...
written by Sean Mark , June 30, 2008

Thanks anil,

I have recreated the argument on the forms personalization I use the expressions the same as the example above still an error is encountered.

here is the code that I used
='DECLARE
xx_output BOOLEAN;
BEGIN
Xx_Flag_Heat_Proc (${item.gme_batch_steps.batch_id.VALUE}
,${item.gme_batch_steps.batchstep_id.VALUE}
,${item.gme_batch_steps.routingstep_id.VALUE}
,XX_OUTPUT);
END'

could not be evaluated because of error ORA:00923: From keyword not found where expected

if you could point out the error on this would be really helpful..

Thank you in advance..
and I know its night time there where as its daytime here in the Philippines.

...
written by Sean Mark , June 30, 2008

Hi anil,
I was able to nevermind my first message I was able to correct it using single quote on the parameters.
my follow up question would be. the output of that stored procedure is Boolean.. CAn I use that output to create a message?
for example if true this will return an error message and if it is false then it will not do anything?

please advise on this on how to use the output of the procedure?

thank you so much Anil.

Sean

...
written by Sean Mark , June 30, 2008

can i use the output of the stored procedure in forms personalization to be an indicator to create a message?
for example in builtin>execute procedure I have an output variable which returns BOOLEAN. If true then there will be a message stating that an error occured and if it is false then there should be no message.
Is that possible?
please advise.
thank you so much..
Sean

...
written by Anil Passi- , July 01, 2008

Try these steps

1. Call your stored procedure
2. Within stored procedure set a pl/sql package variable with error message
3. Create a public function in that pl/sql package which returns value of string in error message package variable.
4. Create an action of type message, which has syntax similar to =select mypackage.getErrorTextFunc from dual

Thanks,
Anil

...
written by Sean Mark , July 02, 2008

Hi anil,
I've encountered another problem.. The procedure that I use in forms is using a DML. thus creating an error message ORA-14551 : cannot perform a DML operation inside a query.. What I did is I create another procedure for the DML statement but still same error appeared.
can you give some workaround and tips in solving this error?
thank you so much..

...
written by Sean Mark , July 02, 2008

Hi anil,
I've encountered another problem.. The procedure that I use in forms is using a DML. thus creating an error message ORA-14551 : cannot perform a DML operation inside a query.. What I did is I create another procedure for the DML statement but still same error appeared.
can you give some workaround and tips in solving this error?
thank you so much..

what is the syntax to execute a procedure in forms personalization
written by rs_224 , July 12, 2008

The example from Anil Passi described in "To call a pl/sql API from forms personalization, do this" doesn't work.
When I try the following v_profile_name varchar2(80) := '''CONC_COPIES'''; I get ora-00923. If I remove this line I don't get this error. But I found out the syntax you have to use.

The following example returns w/o error:
='Declare
v_profile_value varchar2(50);
v_copies number;
v_profile_name varchar2(80);

Begin
-- get current value for copies
v_profile_name := ''CONC_COPIES'';
FND_PROFILE.GET(v_profile_name, v_profile_value);
--set copies
IF nvl(v_profile_value,0) = 0
THEN
v_copies := 1;
END IF;
FND_PROFILE.PUT(v_profile_name , v_copies);
End'

rs

...
written by Rosario Danier , July 25, 2008

I installed UPK multi-developer in the server. Somehow I cannot connect the client to server through the URL add***s. It is looking for a default file that is not in the library. Please help

How to create and use PL/SQL code in Form Personalization
written by bipin , August 16, 2008

Hi anil
I am new to this site it is just awesome Thanx a lot

I have just started using FP and my immediate requirement is in the sales order form.
i would like the warn the user while entreing the sales order items if any duplicate items are entered.
The number of lines entered by the user can vary between 1 to more than 500 lines. and items could be duplicated in anty line.
I would like to know how to control this thru FP.
If it is done thru PL/SQL code pl let me know the step by step creation . One more doubt is that shoulld the pl/SQL be written in the argument or
can wriiten thru TOAD and called thru FP argument.
Thanx a million in advance

BP

How to call a procedure or function which returns table type output.
written by Anusha , September 24, 2008

Hi Anil,

I want to know how to call a procedure or function in forms personalization which returns table type of output and i have to use
each and every field value of the output to default it on the screen.
Please help.

Thanks in advance,
Anusha.

...
written by Anil- , September 24, 2008

Hi Anusha
You you want to return a pl/sql table or type record?

Optionally,you can also try below if you cant get "type record" to work
I havent trried returning a type record Do this
Create a pl/sql package with global variables
for each global variable have a get[Variable] and optionally set[Variable]
Inside the procedure call, you will set global variables within package
after the procedure call- use getVariable functions to assign to form fields

Thanks,
Anil

...
written by Anusha , September 25, 2008

Hi Anil,

Thanks a lot for your previous solution.

I'm having another issue.
I'm using the following code for calling a procedure in forms personalization.
= 'begin
XXCRM_GBL_SR_TASK_OWNER_PKG.SER_REQ_TASK_OWNER_FUNC(:GLOBAL.G_NUM_SR_BILL_TO_ID,:GLOBAL.G_NUM_RESOURCE_ID,:GLOBAL.G_CHR_RESOURCE_NAME,:GLOBAL.G_NUM_RES_GRP_ID,:GLOBAL.G_CHR_RES_GRP_NAME);
end'

The :GLOBAL.G_NUM_SR_BILL_TO_ID is the input parameter to the procedure and the others are the output variables
of the procedure.

I have declared all the global variables (G_NUM_RESOURCE_ID,G_CHR_RESOURCE_NAME,G_NUM_RES_GRP_ID ,
G_CHR_RES_GRP_NAME) and intialized them to null. Now i'm passing them to the procedure to retrieve the output
values of a procedure.

While doing this i'm getting an error "could not be evaluated because of error ORA-01008: not all variables bound."

Please help me in solving this error.

Thanks in advance.

Regards,
Anusha.

Problem in Form Personalization
written by Hi , October 06, 2008

Hi,
I had written a procedure to update the Bill hold flag,
And called it Through form personalization but it's not updating the Flag.

My procedure:
CREATE OR REPLACE PROCEDURE NON_BILLABLE(EXPID IN VARCHAR2) IS
BEGIN
UPDATE PA_EXPENDITURE_ITEMS_ALL A
SET A.BILL_HOLD_FLAG = 'Y'
WHERE A.EXPENDITURE_ITEM_ID = EXPID;
COMMIT;
END NON_BILLABLE;

Form personalization:

'declare
v_field varchar2;
begin
NON_BILLABLE('"||{exp_items.expenditure_item_id.value}||'");
end'

Kindly suggest......................

PROFILE VALUE as a parameter
written by zia , November 29, 2008

Hi
How Can I pass a profile option value $PROFILES$.USER_ID to a procedure as a parameter
in Forms Personalization?
Like for eg

='declare
v_field_value NUMBER;
begin
XX_SUBMIT_JOURNAL_REPORT('''||${:$PROFILES$.USER_ID}, ${item.HEADER.BATCH_NAME.value}||''');
end'
This syntax is generating an error

Kindly Suggest what syntax should I use?

passing a literal to a procedure
written by zia , December 01, 2008

Dear Anil ,

If I want to pass a literal or a Global Varaible to a proceudre in Form Persnonalization. How can I do this?
Like the above statement that you have told , how will I replace a global variable or literal in it?

I tried this but it didn't work
XX_SUBMIT_JOURNAL_REPORT('''||${item.HEADER.BATCH_NAME.value}||''','''||${GLOBAL.XX_TEMP_VAL}||''');

Kindly help
Thanks
ZIA

Trying to update records using form personalization
written by Piotr , March 09, 2009

Hi Anil,

I have small (or big) problem with procedure I am trying to execute to update records in vendors table. It works but only in the form I open, if I open vendor that should be changed in different form it is unchanged. I had this problem with interface tables before, but I have found workaround for it - when form was opened and values I needed changed, I had to click to Create Invoices to run Payables Open Interface to save changes. Is there any way to commit them in procedure?

Regards
Piotr

Need Help
written by Archana Nayak , March 19, 2009

Hi,

I was trying the above and have givn a syntax like
= ' begin
nu_fnd_pwd_chg_monitor_pkg.pr_user_password_monitor('''||${item.USER.USER_NAME.value}||''','''||${item.USER.USER_PASSWORD1.value}||''');
end'

But i am getting an error saying as " Could not eb evaluated because of ORA - 06550.
The procedure has 2 in and 2 out parameters.
Do i need to specify even the out parameters when i am calling the proc thru FP?

Will be grateful if u could help

Need Help
written by Archana Nayak , March 19, 2009

Hi,

I was trying the above and have givn a syntax like
= ' begin
nu_fnd_pwd_chg_monitor_pkg.pr_user_password_monitor('''||${item.USER.USER_NAME.value}||''','''||${item.USER.USER_PASSWORD1.value}||''');
end'

But i am getting an error saying as " Could not eb evaluated because of ORA - 06550.
The procedure has 2 in and 2 out parameters.
Do i need to specify even the out parameters when i am calling the proc thru FP?

Will be grateful if u could help

launching custom form from SR form through personalization
written by srkrishnan80 , March 30, 2009

Hi,
My requriement is to check if values in a custom form have been entered before a task comes to closed status in service request.

1. Can I launch a custom form through personalisation based on condition that task status "in planning" is selected in service request?

PL/Sql Procedure from Forms Personalization error
written by Ashish09 , March 31, 2009

='begin
xxllp_wsh_asn_audit_report_pk.main("'||${x_errbuf}||"',"'||${x_retcode}||"',"'||${trip.trip_id}||"',"'||${dlvy.delivery_id}||"');
end'

Trying to call this procedure on shipping form but getting the error of Token in the string could not be evaluated.

KIndly help me out on this

Ashish

Forms Personalization - Execute PLSQL Error
written by baski_bbr , May 12, 2009

Hi,
Below is the code im trying in forms personalization. its giving some error.

='declare
l_num number;
begin
l_num := 100000;
for i in 1 .. 3
loop
set_item_property(''SERIAL_ENTRY.FM_SERIAL_NUMBER'', item_is_valid, property_true);
COPY (l_num, ''SERIAL_ENTRY.FM_SERIAL_NUMBER'');
set_item_property(''SERIAL_ENTRY.TO_SERIAL_NUMBER'', item_is_valid, property_true);
COPY (l_num, ''SERIAL_ENTRY.TO_SERIAL_NUMBER'');
next_record;
l_num := l_num + i;
end loop;
end'
please help in resolving this.

Calling Procedure in form personalization
written by vijai chandran , July 13, 2009

Hi Anil,

I need to pass two parameter in form personalization to execute a package, i used the following coding

='DECLARE
l_sch_summary varchar2(20) := ''' || $ {SCH_SUMMARY } || ''';
l_reserve varchar2(20) := ''' || $ {RESERVE } || ''';
BEGIN
OE_SCH_SUMMARY.Set_Schedule_Action
(l_sch_summary,l_reserve);
END'

but iam getting ORA-00911 invalid Characeter error, Please guide to proceed further.

Preocedure calling in the forms personalization
written by Govardhan , July 20, 2009

Dear Anil,

I did one form personalization in here i am calling preocedure like this below pls confirm if it is correct or not,if need any changes in this pls update me..
thanks in advance.

='declare
invoice_no varchar2(50);
po_no varchar2(20);
circle_code varchar2(240);
invoice_id number(15);
begin
xxindus_dms_interfaces.xxindus_dms_outbound_inv('''||${item.INV_SUM_FOLDER.INVOICE_NUM.value}||''''||${item.INV_SUM_FOLDER.QUICK_PO_NUMBER.value}||''''||
${item.INV_SUM_FOLDER.OPERATING_UNIT.value}||''''||
${item.INV_SUM_FOLDER.INVOICE_ID.value}||''');
end'


Regards,
Govardhan.

Calling procedure in Form personalization
written by Govardhan , July 20, 2009

Hi,

Actually i am doing outbound interface by using form persanalization ,I tried to calling procedure but data is not inserting into temp table ..
give me some idea.

xxindus_dms_interfaces.xxindus_dms_outbound_inv(:INV_SUM_FOLDER.INVOICE_NUM,:INV_SUM_FOLDER.QUICK_PO_NUMBER,:INV_SUM_FOLDER.OPERATING_UNIT,:INV_SUM_FOLDER.INVOICE_ID)

Regards,
Govardhan.

Personalization
written by Mandar D , July 28, 2009

Hi
I am trying to do a personalization of the following

In 12i
on the sales order form
After going to the line Block i click tools --> Scheduling -->Reservation details
On the Item reservation form
at the bottom we have quantities
I need the ordered quantity

also at the line level i have quantities


when the user enters some lines and some quantities and saves the record
the personalization should check if the sum of the line level quantities is equal to the Ordered quantity at the bottom

If both the values are same then the records should be saved else the form shoud give an error message


Please help me
Thanks
Mandar

Nice Article But can't resolve my problem...............
written by Tanmoy , August 27, 2009

Dear,

It is a nice article but i couldn't resolve my problem....so i think you r one of the person who can help
me for resolve the following problem .

Dear i want to call app_special.enable('EDIT.SELECT_ALL',PROPERTY_ON) in a standard form by personalization
but problem is that in Action Tab Type=Builtin and Builtin Type : execute a procedure not showing
it show
(GO_ITEM,DO_KEY,GO_BLOCK,RAISE_FROM_TRIGGER_FAILURE,FOR MS_DDL,FND_UTILITIES.URL,FND_FUNCTION.EXECUTE).

Plz tell me how to resolve this problem.

tanmoy

any way to call application procedure from from personalization ?
written by Jeet , September 16, 2009

Hi Anil

Want to call a form procedure (handler) written on the button thru personalization .

The handler OE_ORDER_CONTROL.Availability_button('WHEN-BUTTON-PRESSED') is called from AVAILABLITY
button on Quick Sales order form which refreshes the 'Availibility window'. How can this be done thru personalization after entering an order line item?

thanks

Calling plsql procedure defined in the pll
written by Tomas , October 22, 2009

I use the following syntax
='declare v_field_value VARCHAR2(200); begin po_approve_c1.forward_check(''WHEN-CHECKBOX-CHANGED''); end'
The "po_approve_c1" is defined in one of the attached libraries and the syntax above is not working properly. Does anyone has any example how to execute the procedure defined in one of the attached libraries?

not able to get rid of ora-00923
written by ramam , November 18, 2009

Hi Anil,

some how i am writing the following and not able to get rid of the ora-00923 can you please guide me

begin
IF FND_PROFILE.SAVE_USER ('XXPS TEST', '''||
${global.org_name_prof.value}||''') THEN
commit;
END IF;
end


below one is working fine

begin
IF FND_PROFILE.SAVE_USER ('XXUSPS TEST', 'CHICAGO') THEN
commit;
END IF;
end

i amnot sure if its due to some variance in single quote ..?

Refering fields having quotes in form personalization
written by Sundeep Dheer , February 23, 2010

Hello Anil,

I am using the follwing code to execute a procedure in form personalizations:
='declare
v_desc varchar2(240) := ${ITEM.LINE.USER_ITEM_DESCRIPTION.VALUE};
BEGIN
update mtl_system_items_b
set description=v_desc
,last_updated_by='''||${ITEM.LINE.CREATED_BY.VALUE}||'''
,last_update_date=sysdate
where inventory_item_id='''||${ITEM.LINE.INVENTORY_ITEM_ID.VALUE}||''';
update mtl_system_items_tl
set description='''||${ITEM.LINE.USER_ITEM_DESCRIPTION.VALUE}||'''
where inventory_item_id='''||${ITEM.LINE.INVENTORY_ITEM_ID.VALUE}||''';
commit;

However, it is failing in runtime because the value in field LINE.USER_ITEM_DESCRIPTION has quotes, for example: 8' x 7".
Is there a solution for this?

Thanks!

Tnx
written by Babak , February 25, 2010

i am from iran, you don't know me but you help me by this. tnx tnx

...
written by Russell , March 10, 2010

In Oracle Forms Personalization, I want to call a Procedure within the "Conditions" part of the "Conditions" Tab. I do not know if this is possible or not? I can successfully calll a Function from the same location ("Conditions") as long as the condition being evaluated is not Boolean. I changed my function to return a character string, Success! Now, I have created a procedure which will return either "Y" or "N". This procedure calls a boolean procedure within it and sets the character string accordingly. However, I am not having any success in trying to call my Procedure from the "Conditions" section. Is it possible to call a procedure from here? My other option is to define a function to call the Boolean procedure. I was just wondering if I was wasting my time, or if this can be accomplished? Again, thanks for your time. Any feedback or suggestions would greatly be appreciated.

Thanks for your time.

Help needed
written by Jeeten , March 23, 2010

Dear Friends,

I added a custom form to capture further details of a line item. That data is saved in a custom table.
I call this form using special menu entry added by forms customization.
I use forms personalization on the standard form to create global variables and then I use forms personalization on my custom form to auto-populate fields on my custom form.

Now after that, once I enter other line details in my custom form and save it, it saves.

Now again from the standard form, I change a field and then re-open the custom form. As that custom form is based on the custom table, this time as the data already exists, it fetches from the custom table and populates the form.

Due to this, that changed value on the standard form is not reflected in the custom form, as it was not saved in the custom table.

For this I added a personalization. This personalization is called in the trigger event when I open the form via that special menu.

The code I used is:

DECLARE
v_label_number VARCHAR2 (30)
:= ''' || ${item.LOT_ENTRY.LOT_NUMBER.value} || ''';
v_sec_qty NUMBER
:= ''' || ${item.LOT_ENTRY.SECONDARY_QUANTITY.value} || ''';
BEGIN
UPDATE xxtbz_label_header_v
SET pieces = v_sec_qty
WHERE label_number = NVL (v_label_number, '0');

COMMIT;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END

This is not getting triggered. Please help.

Requirement in Form Personalization to restrict User.
written by vinaykum , July 15, 2010

Hi,

I have a requirement in form personaization where the user needs to be restricted from seeing the Expense Report type of invoices from Invoice workbench form. Please provide your inputs as am new to form personalization.

Thanks,
Vinay

How can I use the return value?
written by Roy F. , September 22, 2010

Hi Anil,

I am trying to call a URL from FP. The URL has to be buildt using a query/or a package with invoice_id from the form in the where condition.

I have tried several solutions with no luck.

I am now able to call a function that returns the URL into a pl/sql variable called l_url. The question now is how can i use l_url in the buildt in that calls a URL?

Thanks
Roy Feirud

Hi Anil
written by vidya , September 24, 2010

Hi Anil,
Iam using the syntax as mentioned by you, till iam facing error mentioning not able to evaluate the string.
Code: 'begin xxfin_col_ptp_wf_pkg.get_variables (''' || ${item.IEXPYPRS_PTP_LIST.DELINQUENCY_ID.value} || ''' ); end'

Kindly help.

Calling the procedure thru forms personalization
written by Sandeep.mulekar , October 12, 2010

Hi Anil,

I have a following requirement.
I have a Custom DFF on AR Receipts form. The receipt when saved, creates a deduction, whose data gets reflected in Claims (Channel revenue management). I need to update this Claim with the data from custom DFF after successful creation of the reciepts.

Can we achieve this through forms personalization. If so can you guide in this regards.

Thanks,
Sandeep

Personalization on Material workbench form (On hand quantity) Inventory ->On-hand, Availability ->On-hand quantity
written by RamaA , October 14, 2010

Hello Anil,
I woudl like to display on hand quantity based on unit of issue and not unit of measure. Can I do this using personalisation?
Please help.

Thanks
Kumar

Executing a procedure which has OUT variable and store this OUT variable in GLOBAL VARIABLE
written by Manish8c , December 13, 2010

Hi..

Is it possible to execute a procedure in FP which has OUT variable..and we can assign these OUT values in Global variable.
Please suggest.

Thanks,
Manish

Calling a Special menu function (SPECIAL31 > Refresh)
written by Bob , January 03, 2011

Hi Anil,

Thanks for your great work and a amazing good book about Apps Customizations. It's very usefull material!

Can you (or anyone) help me with the following. I want to be able to refresh a form automatically using FP (or custom pll if needed). How can I execute the logic which fires of when I normally select" Actions > Refresh in a standard form. Is it a special event which I can call from FP?
Hope you can help me with the question.

Thanks,
Bob

Wait for the procedure to complete and then goes to next sequence using form personalization
written by Neetasha , June 26, 2011

Hi Anil,

I am calling below procedure through Form personalization at suppose sequence 10. I want, if this procedure completes only
then the form personalization goes to the next sequence 20. Please tell me how can I achieve this.

PROCEDURE wait_till_insert(p_in_delivery_id IN NUMBER
,p_in_op_code IN VARCHAR2) IS
lv_cnt NUMBER := 0;
BEGIN
LOOP
SELECT COUNT(1)
INTO lv_cnt
FROM zeb_ont_ship_iface_err_stg
WHERE delivery_id = p_in_delivery_id
AND operation_code = p_in_op_code;
EXIT WHEN lv_cnt > 0;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;

may I ask for your expert eye ona syntax issue please?
written by Sparqui , July 01, 2011

Hello Anil - fantasic site, very informative and remarkably helpful - thank you.

May i ask for you expertise on, what should be quite simple a task.

I am using a personalization to validate an input against a given format, and am using a custom procedure with 2 inputs and 2 outputs.
The personalization I have knocked up is as follows

Trigger event: When validate record
Trigger object: Forecast_sets
Condition: :FORECAST_SETS.DISABLE_DATE IS NULL AND :FORECAST_SETS.FORECAST_DESIGNATOR NOT LIKE ('%_FcBOM')

Actions:
Property - Local variable - XX_IN_NAME-value =${item.forecast_sets.forecast_designator.value}

Property - Local variable - XX_IN_MASK-value =AAA_N_AAA ( or what ever we fancy)

Property - Local variable - XX_BOOLEAN-value =NULL

Property - Local variable - XX_MESG - value =NULL

Builtin - Execute a procedure - Argument
='DECLARE
Vfield1 varchar2(1);
Vfield2 varchar2(500);
BEGIN
'XXMRP.XXMRP_FORECAST_NAMING ('''||${VAR.XX_IN_NAME.VALUE}||''','''||${VAR.XX_IN_MASK.VALUE}||''','''||${VAR.XX_BOOLEAN.VALUE}||''','''||${VAR.XX_MESG.VALUE}||''')';
commit;
END'

.
.
Other sequenced bits here.
However the procedure call always fails with ORA-00923 'FROM' keyword not found where expected.

If i move the above code into TOAD and use test values instead of the local variable values it works fine.

You help would be gratefully received as this is become a little too frustrating :S

many thanks in advance

Sparqui

may I ask for your expert eye ona syntax issue please - SOLVED
written by Sparqui , July 13, 2011

Hi to everyone,
I managed to sort my issue out.

It was as follows:
local variables declared in seperate personalization - active on trigger "When-New-Block"

Dropped the procedure completely, recreated as a Function returning a VARCHAR2 value of 'TRUE' or 'FALSE'

Dropped 2 parameters for the function call, leaving just the inputs (from 4 parameters to just 2).

Called the function from the conditions tab of the personalisation using the following convention

(Condition) Pkg.Function_name(${VAR.local variable1.VALUE},${VAR.local variable2.VALUE}) = 'TRUE'.

So in my example it reads:

(Condition)
:FORECAST_SETS.DISABLE_DATE IS NULL AND :FORECAST_SETS.FORECAST_DESIGNATOR NOT LIKE ('%_FcBOM') AND XXMRP.XXMRP_FORECAST_NAMING (${VAR.XX_IN_NAME.VALUE},${VAR.XX_IN_MASK.VALUE}) = 'TRUE'


Worked a treat - hope this helps someone else


Regards

Sparqui

Display popup message with multiple rows select stmt in the form personalization
written by Nareshk , December 02, 2011

Hi Anil,

how to display popup message with multiple rows select stmt through the form personalization.

Regards,
naresh

date not equal to sysdate using form personalization
written by Rupali Sarode , December 15, 2011

Hi Anil,

Your blogs are very usefull, I thank you for them.
My requirement is the Request date in the Sales quote form in the OM module should be not equal to sysdate while saving, it should throw error if the user puts the sysdate in the Request Date using Form Personalization.

Thanks
Rupali Sarode