How to Resubmit Unprocessed Transactions Stuck in the MTL_MATERIAL_TRANSACTION_TEMP Table

Pending Transactions may be resubmitted through the Pending Transactions screen or via sqlplus.

For screen resubmission:

Navigation Inventory>Transactions>Pending Transactions

 Click the checkbox under the "Submit" column to select specific rows.

 Click the Save icon

Add Concurrent program to request set from backend

FND_PROGRAM.ADD_TO_GROUP: The procedure is used to add a concurrent program to a request group. This procedure corresponds to the "Requests" region in the "Request Groups" window in System Administration.

Syntax:

procedure FND_PROGRAM.ADD_TO_GROUP

(program_short_name IN VARCHAR2,

program_application IN VARCHAR2,

request_group IN VARCHAR2,

group_application IN VARCHAR2);

Queries related to Security profile in Oracle apps MOAC

1.      If you do not know the security profile or operating unit profile option settings for your user, responsibility and application, you could use code similar to the following to get this information:

declare

  l_user_id fnd_user.user_id%type;

  l_resp_id fnd_responsibility.responsibility_id%type;

  l_appl_id fnd_application.application_id%type;

  l_appl_short_name fnd_application_vl.application_short_name%type;

  l_ou_value fnd_profile_option_values.profile_option_value%type;

  l_sp_value fnd_profile_option_values.profile_option_value%type;