Monday 3 June 2013

provide output of the script rcv11i_sa.sql.



Attached the Rcv11i sql .
Parameters 
Source Doucmnet type - RMA 
Document number - 76000888.
Release number - Enter 
operating Unit ID - 467
Include ROI Tables summary - Enter 
Include ROI Group ID - Enter 
Output Destination - UFD 
Destination Directory - ................

Above details will provided by user or who raised a request to execute above script.

==============

1)Download script from support.oracle.com
2)Move the file to server.
3)Connect to apps schema and execute the script.
4)it will generate an output file give it to user. 



SQL> show user
USER is "APPS"
SQL> select name from v$database;

NAME
---------
EBSOLTP1

SQL> @rcv11i_sa.sql


Source Document Type?

Possible Source Document Types:
================================================================
PO: Purchase Order,
PR: Purchase order release (blanket or scheduled release),
RQ: Requisition,
RMA: Return Material Authorization,
IOT: Inter-organization Transfer, inter-organization Shipment


Source Document Type?


Please enter source document type [PO, PR, RQ, RMA, or IOT]: RMA


Please enter Document Number (PO Num, RQ Num, RMA Num, or Shipment Num): 76000888


Please enter Release Number (or just press ENTER if not applicable):

Include ROI tables summary query? [Y]es, [N]o, [O]nly summary: [N]


For ROI summary query, enter GROUP_ID (or just press ENTER for null group_id):


Output Destination?

Possible Output Destination:
================================================================
SO: Serveroutput (as a spool file to current directory),
UFD: In directory specified in utl_file_dir DB parameter (when applicable)



UTL_FILE_DIR directories:
------------------------

- /u01/erpcsf/temp
- /u01/erpapp/comn/temp
- /u01/custom/gl/in
destination directory: /u01/erpcsf/temp


Please, concisely describe the issue (press ENTER to finish your statement):

RUNNING (script may take minutes to run...)



Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$

No comments:

Post a Comment