OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to script uploading printer definitions into Oracle Applications?

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to script uploading printer definitions into Oracle Applications?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to script uploading printer definitions into Oracle Applications? [message #225104]

Sat, 17 March 2007 10:57

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!

Report message to a moderator

Re: how to script uploading printer definitions into Oracle Applications? [message #225128 is a reply to message #225104]

Sun, 18 March 2007 02:08

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.

Report message to a moderator

Re: how to script uploading printer definitions into Oracle Applications? [message #225648 is a reply to message #225128]

Tue, 20 March 2007 13:12

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

Report message to a moderator

Re: how to script uploading printer definitions into Oracle Applications? [message #231321 is a reply to message #225648]

Mon, 16 April 2007 08:59

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 07 19:37:54 CST 2024