Change label on RF Mobile GUI

SQL query to find it -->
SELECT r.region_object_type rObj,
  ritl.attribute_code attrCode,
  ri.DEFAULT_VALUE_VARCHAR2 fAttr,
  ritl.attribute_label_long attrLbl
FROM ak_region_items_tl ritl,
  ak_region_items ri,
  ak_regions r
WHERE ritl.attribute_code   = ri.attribute_code
AND r.region_application_id = ritl.region_application_id
AND r.region_code           = ritl.region_code
AND r.region_application_id = ri.region_application_id
AND r.region_code           = ri.region_code
AND ritl.attribute_label_long like 'Airbill';

Go to AK Developer responsibility.

Open form Define Attributes.

Find the old label and change it with new label.

Restart the MWA listener.

Thanks to:
http://www.apps2fusion.com/at/ss/337-msca-ak-repository-oracle-mobile-web

Testing Wireshark HTTP request and response

Testing Wireshark HTTP request and response

Call PLSQL package.function() from shell

OUTPUT_RESPONSE=`sqlplus -s $FCP_LOGIN << EOSQL
!
set term off
set head off
set pages 0
set feedback off
set serveroutput on

declare
retcode NUMBER:=0;
begin
retcode := XXYH_XML_PARSER.PARSE('$SOURCE_CODE', '$l_get_response', $FCP_REQID, $PARENT_REQUEST_ID, '$PROD', '$FEED', '$ACTION','','','','','','','');
dbms_output.put_line(retcode);
end;
/
exit;
!

EOSQL
`

Get Responsibility Name and Resp Application Short Name in Shell

# -----------------------------------------------------
# Get Resp Name
# -----------------------------------------------------

RESP_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT RESP.responsibility_name
  FROM fnd_responsibility_vl RESP
      ,fnd_concurrent_requests REQ
 WHERE RESP.responsibility_id = REQ.responsibility_id
   AND REQ.request_id         = $FCP_REQID
   AND rownum = 1
/
!
`

RESP_APPL_SHORT_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT FAPP.application_short_name
  FROM fnd_application FAPP
      ,fnd_concurrent_requests REQ
 WHERE FAPP.application_id = REQ.responsibility_application_id
   AND REQ.request_id      = $FCP_REQID
   AND rownum = 1
/
!
`

Trace file details for Concurrent Request

SELECT request_id  request_id, 
      oracle_Process_id Trace_id, 
      req.enable_trace trace_flag, 
      decode(oracle_process_id, null, 'No trace file generated',
      dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc') trace_file_name, 
      prog.user_concurrent_program_name concurrent_program_name, 
      execname.execution_file_name|| execname.subroutine_name executable_name, 
      decode(phase_code,'R','Running') 
      ||'-'||decode(status_code,'R','Normal') concurrent_program_status, 
      ses.sid||','|| ses.serial# SID_serial, 
      ses.module module
from fnd_concurrent_requests req, 

     v$session ses, 

     v$process proc, 
     v$parameter dest, 

     v$parameter dbnm, 

     fnd_concurrent_programs_vl prog, 
     fnd_executables execname 
where req.request_id = 26784178 
and req.oracle_process_id=proc.spid(+) 
and proc.addr = ses.paddr(+) 
and dest.name='user_dump_dest' 
and dbnm.name='db_name' 
and req.concurrent_program_id = prog.concurrent_program_id 
and req.program_application_id = prog.application_id 
and prog.executable_application_id = execname.application_id
and prog.executable_id=execname.executable_id; 

Steps to Enable Audit Trail in Oracle Applications

Steps to Enable Audit Trail in Oracle Applications by Sachin Dixit

Sample BULK collect example

set serveroutput on;

declare
cursor get is
select * from all_objects
where rownum <= 100
and object_type = 'TABLE';

TYPE t_get IS TABLE OF get%ROWTYPE;
l_get t_get;

j number:=0;
begin

open get;
 loop

  FETCH get BULK COLLECT INTO l_get LIMIT 20 ;
  EXIT WHEN l_get.count = 0;
 
    for i in 1 .. l_get.count loop
     j := j+1;
     dbms_output.put_line ('table_name('||j||')    '|| l_get(i).object_name);
    end loop;
   
 end loop;
close get;

exception
  when others then
dbms_output.put_line ('error : '||sqlerrm);
end;