How to Enable Personalization link for OAF Pages

System Administrator >> Profile >> System


FND: Personalization Region Link Enabled: Yes

Personalize Self-Service Defn: Yes

Disable Self-Service Personal: No

Utilities:Diagnostics: Yes

How to dump (export) whole table data.

SET UNDERLINE OFF
SET COLSEP ','
--That's the separator used by excel later to parse the data to columns
SET LINES 100 PAGES 100
SET FEEDBACK off
--If you don't want column headings in CSV file
SET HEADING off 
Spool ~\myresults.csv
--Now the actual query
SELECT * FROM YOUR_TABLE;
Spool OFF

How to check auto create approved PO without manual perform.

Make sure the four values are all return 'Y' to achieve auto create.



select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Should Workflow Create The Release?' Attribute 
from wf_item_attributes w 
where w.NAME = 'CONT_WF_FOR_AC_REL_GEN' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Is Automatic Creation Allowed?' Attribute 
from wf_item_attributes w 
where w.NAME = 'AUTOCREATE_DOC' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Is Automatic Approval Allowed?' Attribute 
from wf_item_attributes w 
where w.NAME = 'AUTO_APPROVE_DOC' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Send PO Autocreation to Background' Attribute 
from wf_item_attributes w 
where w.NAME = 'SEND_CREATEPO_TO_BACKGROUND' 
and w.item_type = 'REQAPPRV' 
order by 1

Set Item Attribute in workflow when customization

This package can change item attribute for specific order.

po_wf_util_pkg.SetItemAttrText (itemtype => 'REQAPPRV',

                                   itemkey  => '63-70',

                                   aname => 'AUTO_APPROVE_DOC',

                                   avalue => 'Y');

How to enable Examine of Diagnostics function

System Administrator >> Profile >> System

Profile: Utilities:Diagnostics

Set value = Yes

Profile: Hide Diagnostics menu entry

Set value = No

Validation Table Information - Where/Order By

Where/Order By


where AEPL.EU_ID = :$FLEX$.INV_SRS_CROSS_REFERENCE

     AND AEPL.SITE_USE_ID = DECODE (:$PROFILES$.ORG_ID,1577,275511,1579,262510)

     AND AEPL.INVENTORY_ITEM_ID = :LINES.ITEM_ID:NULL

How to control item attribute in oracle forms

set_item_instance_property or app_item_property.set_property

if :KD = 2 then
:PRESSURE_TEST := 'N';
SET_ITEM_INSTANCE_PROPERTY('CYL_CYLINDER_BASE_DATA.PRESSURE_TEST',CURRENT_RECORD, UPDATE_ALLOWED, PROPERTY_FALSE);
else
:PRESSURE_TEST := 'Y';
SET_ITEM_INSTANCE_PROPERTY('CYL_CYLINDER_BASE_DATA.PRESSURE_TEST',CURRENT_RECORD, UPDATE_ALLOWED, PROPERTY_TRUE);
end if;

How to see user's concurrent request

System Administrator >> Concurrent >> Requests

How to find concurrent request log.

How to find concurrent request log

1.
SELECT FCPP.CONCURRENT_REQUEST_ID REQ_ID,FCP.NODE_NAME,FCP.LOGFILE_NAME
FROM FND_CONC_PP_ACTIONS FCPP,
FND_CONCURRENT_PROCESSES FCP
WHERE FCPP.PROCESSOR_ID =FCP.CONCURRENT_PROCESS_ID
AND FCPP.ACTION_TYPE = 6
AND FCPP.CONCURRENT_REQUEST_ID = 14982925

2.