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