Tuesday, July 17, 2012

Attach responsibility to user from backend

BEGIN

fnd_user_pkg.addresp(username =&gt
,resp_app =&gt 'SYSADMIN'

,resp_key =&gt  'SYSTEM_ADMINISTRATOR'

,security_group =&gt  'STANDARD'

,description =&gt 'Custom System administrator responsibility'

,start_date =&gt  Sysdate

,end_date = &gt Sysdate +100);

COMMIT;

END;

Monday, July 16, 2012

Passing Multiple Paramaters to the form from form personalisation

Type:Built In
Built In Type:Launch a Function
Function Code:
Function Name:
Parameters:
='XXINV_ORDER_NUMBER='


${item.order.order_number.value}

'

XXINV_ITEM_CODE='

${item.line.ordered_item_dsp.value}

' XXINV_ORDER_LINE_ID='

${item.line.ato_line_id.value}

' XXINV_ORIG_LINE_ID='

${item.line.line_id.value}

'

XXINV_CUST_ID='

${item.order.sold_to_org_id.value}

' XXINV_CUST_PART_NO='

'"'

${var.L_CHR_CUST_PART_NO.value}

'"'

Wednesday, July 11, 2012

Calling Form Function With Predefined Paramaters

Type:Built In
Built In Type:Launch a Function
Function Code:
Function Name:


Parameters='G_HEADER_ID = "'||:ORDER.HEADER_ID||'"'

Tuesday, July 3, 2012

Printing Problem in PDF format

https://kr.forums.oracle.com/forums/thread.jspa?messageID=9202118

cd $FND_TOP/resource




Vi pasta_pdf.cfg



Existing one - old vallue (Comment out this)

Preprocess= dftops {infile} {outfile}



Modified one - New value for pdf printing

preprocess=pdf2ps {infile} {outfile}

; semicolon is missing in preprocess.