Find Oracle API
Have to search for dependancies or search source code:
Application Utilities Lookups
-
select flv.security_group_id, flv.lookup_code, flv.meaning, flv.description
-
from fnd_lookup_types flt
Valueset
-
select
-
ffv.flex_value,
Java System Vars
Find java system vars
CodeDescription
System.getProperty("os.name")OS Name
System.getProperty("line.separator")EOL Character
System.getProperty("file.separator")File seperator / or \
http://docs.oracle.com/javase/tutorial/essential/environment/sysprop.ht…
Java Serializable Class Example
-
package metcarob.com.mediaorganiser.mainapp;
-
DBMS_SCHEDULER
This is a replacement for DBMS_JOBS
Known Profile Options
Profile options known about in Oracle
Profile Options
List Profile Option Values
-
SELECT
-
fpo.profile_option_id,
BPEL General Reference
Time stuff
10 Days = P10D
a week = P7D
a month = P1M - a month
One year, one day, one hour and one second = P1Y1DT1H1S
five minutes = PT5M
Expression for 30 secs in future = xp20:add-dayTimeDuration-to-dateTime(xp20:current-dateTime(),'PT30S')
(https://blogs.oracle.com/reynolds/entry/whats_the_time_mr_bpel)
c
access nth: /ns2:EMP_REF_VAR/ns2:Row[bpws:getVariableData('nCounter')]
JMS Adapter Recieve Property
-
<receive name="Receive" createInstance="yes"
-
partnerLink="RJMTesT_AQ_DeQ2_Sub2_JMS001"