Answer / anang

Yes We can create a synony for a trigger like this

Create or replace trigger test before insert on emp
begin
dbms_output.put_line('Hi');
end;
Create the trigger in scott schema

and connect to apps schema and create a synonym like this

create public synonym test for scott.test;

or

create synonym test1 for scott.test;

Answer / arun

We can't create synonyms on trigger

Answer / amit

Yes, We can create Public and Private Synonyms on Triggers.

Answer / avinash

I have created a trriger on CREATE,in which i m giving
execute immediate command for creating a synonym and using
dbms_job.submit .
it is not giving any error but its not creating any synonym
on the table...
code:

create or replace trigger bdesai.DR_CRA
after CREATE OR DROP on bdesai.schema
declare
l_str varchar2(255);
l_str1 varchar2(255);
l_job number;
begin
CASE ORA_SYSEVENT
WHEN 'CREATE' THEN
if (ora_dict_obj_type = 'TABLE') then
l_str := 'execute immediate "grant select on bdesai.'
||ora_dict_obj_name ||' to eqhub_developer";';
l_str1 := 'execute immediate "create or replace synonym
eqhub_developer'||'.'||ora_dict_obj_name ||' for
bdesai'||'.'||ora_dict_obj_name||'";';
DBMS_OUTPUT.PUT_LINE(replace(l_str,'"',''''));
DBMS_OUTPUT.PUT_LINE(replace(l_str1,'"',''''));
dbms_job.submit( l_job, replace(l_str,'"','''') );
dbms_job.submit( l_job, replace(l_str1,'"','''') );

END IF;
WHEN 'DROP' THEN
if ( ora_dict_obj_type = 'TABLE') then
l_str := 'execute immediate "revoke select on bdesai.'
||ora_dict_obj_name ||' from eqhub_developer";';
l_str1 := 'execute immediate "drop synonym
eqhub_developer'||'.'||ora_dict_obj_name||'";';
DBMS_OUTPUT.PUT_LINE(replace(l_str,'"',''''));
DBMS_OUTPUT.PUT_LINE(replace(l_str1,'"',''''));
dbms_job.submit( l_job, replace(l_str,'"','''') );
dbms_job.submit( l_job, replace(l_str1,'"','''') );
END IF;
END CASE;

end;
/

Answer / phani

I agress, we can create synonym for triggers. infact we can
create synonym for any object in the database. But, why
anyone need to create the synonym for any trigger. It is not
required at all.

For the Better understanding about the Oracle Applications.
I suggest you go through the following link.

http://alloracletech.blogspot.com/2008/08/oracle-applications-concept.html

Regards,
Phani

Answer / natthu matte

Yes we can create a synonym of trigger because it is a
database object like others,but here what is the use of
this synonym..? answere is nothing. u can not use the
functionality of trigger by using this synonym of trigger.

Answer / prasad

We connt create Synonym for Trigger.

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

what is po approval hierarchy?

1 Answers   Cap Gemini,

What is menu.

2 Answers   Accenture,

What is the interface?

3 Answers  

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

in procedure how to return a value

3 Answers  

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

What are triggers?

3 Answers  

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

Can u define exceptions twice in same block?

3 Answers