Assigning Concurrent Program to a Responsibility in R12.1.3

Steps to add request set/Program to responsibility in oracle apps R12.1.3

 Example :-

Responsibility name :- General Ledger Super User 

Add below two program to this responsibility.

a. GL Cost Journal Program

b. GL Revenue Journal Program

1. Find the Request Group of the Responsibility

Responsibility: System Administrator > Security > Responsibility > Define

2. Search for the Responsibility(General Ledger Super User) with which the Concurrent Program needs to be run. 

 Copy the request group name.

3. Add the Concurrent Program/Request Set to the Request Group

Responsibility: System Administrator > Security > Responsibility > Request

Search the request Group name for attaching the concurrent Program

Request group :- GL Concurrent Program Group

Application :- General Ledger

Add below both concurrent program and save it.

a. GL Cost Journal Program

b. GL Revenue Journal Program

I hope both concurrent program has been reflected on responsibility (General Ledger Super User).

 

How to Enabled and Disabled Triggers in oracle 11g.

Ques :- How to Enabled and Disabled Triggers in oracle 11g?

# Enabling Triggers steps.

You enable a disabled trigger using the ALTER TRIGGER statement with the ENABLE option. 

To enable the disabled trigger named trigger01 on the SUJEET table, enter the following statement:

ALTER TRIGGER trigger01 ENABLE;

To enable all triggers defined for a specific table, use the ALTER TABLE statement with the 

ENABLE ALL TRIGGERS option. To enable all triggers defined for the SUJEET table, 

Enter the following statement:

ALTER TABLE SUJEET ENABLE ALL TRIGGERS;

# Disabling Triggers steps.

Consider temporarily disabling a trigger if one of the following conditions is true:

An object that the trigger references is not available.

You must perform a large data load and want it to proceed quickly without firing triggers.

You are loading data into the table to which the trigger applies.

You disable a trigger using the ALTER TRIGGER statement with the DISABLE option. 

To disable the trigger trigger01 on the SUJEET table,

 Enter the following statement:

ALTER TRIGGER trigger01 DISABLE;

You can disable all triggers associated with a table at the same time using the ALTER TABLE statement 

with the DISABLE ALL TRIGGERS option. For example, to disable all triggers defined for the SUJEET table, 

Enter the following statement:

ALTER TABLE SUJEET DISABLE ALL TRIGGERS;