Monday 25 March 2013

How to find the text attachemnts attached to a Requisition Header

     /* Step:-1 -> Find the requisition */
     
      select b.REQUISITION_HEADER_ID from po_requisition_headers_all b where   trunc(b.CREATION_DATE)='25-MAR-2013'
     
      /*Step:- 2 - >   Find The document id (Here PK1_VALUE is the requisition_header_id) */
     
      select a.PK1_VALUE ,a.DOCUMENT_ID ,a.* from apps.FND_ATTACHED_DOCUMENTS a where a.PK1_VALUE =95355(requisition_header_id)
     
      /* Step :- 3 ->  Find the media_id */
     
      select a.MEDIA_ID ,a.* from fnd_documents a where a.DOCUMENT_ID=160936
     
      /*Step:- 4 -> Find the  Input Text in the requisition */
     
      select a.SHORT_TEXT,a.MEDIA_ID from fnd_documents_short_text a where a.MEDIA_ID=2;

Thursday 7 March 2013

How to attach multiple templates (.rtf) to a single Report


1.      Create your multiple RTFs.
2.     Now go to XML Publisher Administrator and create a Data Definition.


3. We need to create multiple templates against the same Data Definition.




       Similarly, you need to create multiple template against the same Data Definition ( e.g.           KCT000RCONA  here).


4.     Now run the Report from SRS window.







Submit the request and you will get output according to your selected template.







      


       






      


Tuesday 5 March 2013

SORTING AUTOCREATE DATA


At the time of Auto create if data are coming without maintaining any order you can sort them in order. The process is showing below.



HOW TO INCREASE NUMBER OF LINES IN APPROVAL NOTIFICATION

Put the number that you want to display in approval notification in the following profile option.
"PO: Notification Lines Display Limit"