OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Orracle EBS implementation (oracle EBS R12)

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

Orracle EBS implementation [message #535990]

Sun, 18 December 2011 15:09

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi experts,

our company is going to implement oracle E- Business suite R12 on one of unix flavor eihter Sun solaris or HP-unix or IBM AIX,
so i am searching for which unix flavor is more compatible, less of bugs & bottle necks . i am searching a lot on internet about comparison sheet for R12 implementation on one of unix flavor but i don't get any web site or link which assist us about this, so please any ideas or link quick sharing will be higly appreciated. thanks

Best Regards

Report message to a moderator

Re: Orracle EBS implementation [message #542018 is a reply to message #535990]

Fri, 03 February 2012 17:28

sanchezdba
Messages: 1
Registered: February 2012
Location: Northridge

Junior Member

Have you guys considered a split implementation? Where your DB would be in a Sun server or HP server and your application will be running on a couple of Linux Servers? I've done multiple implementations and this is by far the one that I see the best performance in. The middle tier runs great in Linux.

Report message to a moderator

Re: Orracle EBS implementation [message #551386 is a reply to message #542018]

Tue, 17 April 2012 14:59

marvSQL
Messages: 13
Registered: February 2008
Location: JAMAICA

Junior Member

Hi,
my company is currently using oracle E- Business suite 11i on solaris 9(UNIX).
the company is upgrading to oracle E- Business suite R12 on a solaris 9(UNIX).

There is a custom form that compiled perfectly on the existing 11i environment,
but when the form is compiled in the R12 environment it produces an error:

Compiling procedure DISPLAY_ALERT...
Compilation error on procedure DISPLAY_ALERT:
PL/SQL ERROR 201 at line 4, column 4
identifier 'CALL' must be declared
PL/SQL ERROR 0 at line 4, column 4
Statement ignored

the error is caused by CALL in display_alert.The display_alert procedure is:

procedure display_alert(MESSAGE_TEXT in VARCHAR2, ALERT_RESPONSE out VARCHAR2) is
begin
   :GLOBAL.MESSAGE_TEXT := MESSAGE_TEXT;
   call('ALERT',NO_HIDE,DO_REPLACE);
   default_value('N','GLOBAL.ALERT_RESPONSE');
   ALERT_RESPONSE := :GLOBAL.ALERT_RESPONSE;
   erase('GLOBAL.ALERT_RESPONSE');
end;

The procedure CALL was found in a package called 'PACKAGE app_form'. The package is apart of the library APPCORE.pll.
this APPCORE.pll is in the AU_TOP/resource directory on the server.

i modified the code in the display_alert and qualified the 'call' to 'app_form.call' and recompiled it in the R12 environment:

procedure display_alert(MESSAGE_TEXT in VARCHAR2, ALERT_RESPONSE out VARCHAR2) is
begin
   :GLOBAL.MESSAGE_TEXT := MESSAGE_TEXT;
   app_form.call('ALERT',NO_HIDE,DO_REPLACE);
   default_value('N','GLOBAL.ALERT_RESPONSE');
   ALERT_RESPONSE := :GLOBAL.ALERT_RESPONSE;
   erase('GLOBAL.ALERT_RESPONSE');
end;

the form was compiled without any errors!!

my question is...is there an environment variable that i can set so that the form can see the procedure 'CALL' directly instead of referencing it with 'app_form.call' ?

because there seem to be one on the 11i environment that i dont know of

Report message to a moderator

Previous Topic:	Table Name ?
Next Topic:	custom form attached libraries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 06:22:39 CST 2024