Use of system administrator request Groups and responsibility in Oracle Apps R12

System Administrator -> Request Groups and Responsibility:

When a concurrent program is created it should register in request groups. so that one can submit the report in the assigned responsibility.

For example:

One should register a report that should run in order management setup means.

First go to system administrator-> security->user->define->query->Order Management Setup

Then in the screen shot the Request Group name OM Concurrent Programs is there. Copy that Request group name and go to security->responsibility->request

Query the copied request group and add the concurrent program by choosing type as program and name as concurrent program name and the application whether that is standard or custom defined while creating a ccp.

Code with substr and instr in oracle apps r12

Code with substr and instr in oracle apps r12

select SUBSTR('XLOGIC HIBM-CHI',9,INSTR('XLOGIC HIBM-CHI','-',1)-9) from dual;

Value returns as IBM

To find the table name by using the column name

To find the table name by using the column name:

select * from all_tab_columns where Upper(column_name) like Upper('Payment%Method%');

Payment%Method% is the column name

for my use - unix send mail program with output attachment has uploaded in google drive

unix send mail program with output attachment has uploaded in google drive in rma transactions report folder. In qlogic_Send_mail.prog file contains the unix commands in which mail will take the body message from a file in one directory.