Home » Applications » Oracle Fusion Apps & E-Business Suite » how to script uploading printer definitions into Oracle Applications?
how to script uploading printer definitions into Oracle Applications? [message #225104] Sat, 17 March 2007 10:57 Go to next message
yanbo1
Messages: 3
Registered: February 2007
Junior Member
I would like to know how to script uploading printer definitions into Oracle Applications. Is there anybody who has a ready script for this already? if not, any ideas about how to do this would be greatly appreciated. Thanks!
Re: how to script uploading printer definitions into Oracle Applications? [message #225128 is a reply to message #225104] Sun, 18 March 2007 02:08 Go to previous messageGo to next message
KARTHICK_narayan
Messages: 21
Registered: September 2006
Location: BAHRAIN
Junior Member

HI,

USE THESE TWO PACKAGES.


FND_PRINTER_PKG

FND_PRINTER_STYLES_PKG

extract ur printer info from ur legacy system to a custom table in oracle apps(using sql*loader) and then call this package in PL/Sql

regards
Karthick.
Re: how to script uploading printer definitions into Oracle Applications? [message #225648 is a reply to message #225128] Tue, 20 March 2007 13:12 Go to previous messageGo to next message
yanbo1
Messages: 3
Registered: February 2007
Junior Member
Thanks for your response! Could you please tell me why I got the following error and how to fix it?
SQL> exec fnd_printer_pkg.INSERT_ROW(X_PRINTER_NAME=>'ACCTBUD',X_PRINTER_TYPE=>'HPLJ4SI',X
_DESCRIPTION=>'Marion Accounting Plant 3');
BEGIN fnd_printer_pkg.INSERT_ROW(X_PRINTER_NAME=>'ACCTBUD',X_PRINTER_TYPE=>'HPLJ4SI',X
_DESCRIPTION=>'Marion Accounting Plant 3'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INSERT_ROW'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Re: how to script uploading printer definitions into Oracle Applications? [message #231321 is a reply to message #225648] Mon, 16 April 2007 08:59 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Provide a value for all parameters:
---
procedure INSERT_ROW (
X_ROWID in out VARCHAR2,
X_PRINTER_NAME in VARCHAR2,
X_PRINTER_TYPE in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER);
---
Note: You will need a variable for X_ROWID parameter
Previous Topic: Service Contracts - Extending Sublines (covered products)
Next Topic: What is different enhancement's between 11.5.3 to 11.5.10 in PO
Goto Forum:
  


Current Time: Sat Dec 10 22:51:14 CST 2016

Total time taken to generate the page: 0.05600 seconds