WebADI_配置设定10_设定默认值Attribute Default Value（案例）

20150906 Created By BaoXinjian

一、摘要

---

6种默认值设定

1. Environment Parameters

OAUSER.ID / SYSDATE / DATABASE 常用的，

另外一些sob 的， 例如sob.chartofaccountsid, sob.periodsetname, sob.setofbooksid之类的，也不知还能不能用， 还没测

2. Constant

这个最简单，直接写个东西进去就行了。

3. Paramter

取值于Integrator中定义的Parameters List中的参数

4. SQL

这 个也简单，写个SQL 完事，结果多行的话，取第一行。

sql 里可包含$env$.userid, $env$.appid, $env$.respid 之类的环境变量， 还有$PROFILES$.default_org_id之类的取profile options的东东。

5. Profile Option

从字面上理解，是用来取配置文件中某个option的值，但我测了，不成功，不知是bug还是别的原因.

6. Lookups

不知干什么的，前两天无意看到有个标准的Integrator具然包含多个Interface， 而Interface 间的联接似乎就用这个。。。

因为此项在后台叫TABLELOOKUP... 多Interface的Integrator还不知怎么做，待研究.

 

2.1 Environment Parameters

---

1. 在页面上的例子

2. 在数据库中的例子

 

2.2 PARAMETERS

---

1. 在页面上的例子

 

2. 在数据库中的例子

PARAMETER    gl:budgetName
PARAMETER    gl:currency
PARAMETER    gl:ledgerName
PARAMETER    gl:organization
PARAMETER    gl:periodYear
PARAMETER    gl:updateMode

 

2.3 SQL

---

1. 在页面上的例子

 

2. 在数据库中的例子

SQL    SELECT $PARAM$.PER:India_Medical_Bill_Param FROM DUAL
SQL    SELECT $PROFILES$.PER_RI_WEBADI_BG_ID FROM DUAL
SQL    SELECT ACCESS_SET_ID FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = $PROFILES$.GL_ACCESS_SET_ID
SQL    SELECT ADB_FLAG FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID=:SOB_ID
SQL    SELECT AMS_ADI_UPLOAD_BATCH_S.nextval from dual
SQL    SELECT BUDGET_ENTITY_ID FROM GL_BUDGET_ENTITIES WHERE NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_ENTITY_NAME
SQL    SELECT BUDGET_VERSION_ID FROM GL_BUDGET_VERSIONS WHERE BUDGET_NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_NAME
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Pre-Tax Deductions'
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Supplemental Earnings'
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Taxable Benefits'
SQL    SELECT CLASSIFICATION_ID FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'US' AND CLASSIFICATION_NAME = 'Pre-Tax Deductions'
SQL    SELECT EGO_IPI_TRANSACTION_ID_S.NEXTVAL FROM DUAL
SQL    SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM DUAL
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'ASSET TYPE'
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'FADI_FEEDER_SYSTEM'
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'YESNO' AND LOOKUP_CODE = 'YES'
SQL    SELECT NAME FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = $PROFILES$.GL_ACCESS_SET_ID
SQL    SELECT OZF_RESALE_BATCH_NUMBER_S.NEXTVAL FROM DUAL
SQL    SELECT TO_CHAR(SYSDATE,'DD-MON-RRRR') FROM DUAL
SQL    SELECT TRUNC(SYSDATE) from dual
SQL    SELECT USERENV('LANG') FROM DUAL
SQL    SELECT USER_JE_SOURCE_NAME FROM GL_JE_SOURCES_V WHERE JE_SOURCE_NAME = $PROFILES$.GLDI_JOURNAL_SOURCE
SQL    SELECT fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE') FROM dual
SQL    SELECT fnd_profile.value('PER_BUSINESS_GROUP_ID') from dual
SQL    SELECT gcs_dimension_members_t_s.NEXTVAL FROM DUAL
SQL    SELECT gcs_entry_headers_s.NEXTVAL FROM DUAL
SQL    SELECT gcs_hier_members_t_s.NEXTVAL FROM DUAL
SQL    SELECT meaning FROM IGI_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N'
SQL    SELECT name FROM hr_operating_units WHERE organization_id = $PARAM$.orgId
SQL    SELECT name FROM hr_operating_units WHERE organization_id = $PROFILES$.DEFAULT_ORG_ID
SQL    Select $PARAM$.ORGANIZATION from dual
SQL    Select $PARAM$.test_param from dual
SQL    Select id_flex_structure_name from fnd_id_flex_structures_v where application_id = 101 and id_flex_code = 'GL#' and id_flex_num = $PARAM$.COA_ID
SQL    Select trunc(sysdate) from dual
SQL    select $PROFILES$.PER_RI_WEBADI_BG_ID from dual
SQL    select $PROFILES$.PQP_RI_INTERFACE_CODE from dual
SQL    select AMS_ADI_UI_INSTANCE_S.nextval from dual
SQL    select AMS_ADI_UPLOAD_BATCH_S.nextval from dual
SQL    select AMW_AUDIT_PROCEDURE_INT_S1.nextval from dual
SQL    select AMW_CONSTRAINT_INTERFACE_S1.nextval from dual
SQL    select ITA_SETUP_REC_INTF_S2.nextval from dual
SQL    select LEGISLATION_CODE from per_business_groups where business_group_id =$PROFILES$.PER_RI_WEBADI_BG_ID
SQL    select PA_FP_WEBADI_UPLOAD_INF_S.nextval from dual
SQL    select RESOURCE_NAME from jtf_rs_resource_extns_vl where user_id = $env$.userid
SQL    select amw_ap_interface_s1.nextval from dual
SQL    select amw_ctrl_interface_s1.nextval from dual
SQL    select amw_key_acc_interface_s2.nextval from dual
SQL    select amw_processes_interface_s2.nextval from dual
SQL    select amw_rcm_org_interface_s2.nextval from dual
SQL    select amw_risk_ctrl_interface_s2.nextval from dual
SQL    select country_name from jtf_loc_hierarchies_vl where location_type_code = 'COUNTRY' and location_hierarchy_id = fnd_profile.value('AMS_SRCGEN_USER_CITY')
SQL    select currency_code from gl_ledgers where ledger_id = $PARAM$.LedgerId
SQL    select fnd_profile.value('AMS_SRCGEN_USER_CITY') from dual
SQL    select fun_system_options_pkg.get_default_currency() from dual
SQL    select gcs_entry_headers_s.nextval from dual
SQL    select legislation_code from per_business_groups where business_group_id = $PROFILES$.PER_RI_WEBADI_BG_ID
SQL    select meaning from gl_lookups where lookup_type = 'GL_HIST_RATES_USAGE' and lookup_code = 'Standard'
SQL    select name from fnd_currencies_vl where currency_code = fnd_profile.value('AMS_DEFAULT_CURR_CODE')  and enabled_flag = 'Y'
SQL    select name from fnd_timezones_vl where upgrade_tz_id = fnd_profile.value('CLIENT_TIMEZONE_ID')
SQL    select name from gl_ledgers where ledger_id = $PARAM$.LedgerId
SQL    select ota_general.get_org_name($PROFILES$.PER_RI_WEBADI_BG_ID) from dual
SQL    select resource_id from jtf_rs_resource_extns where user_id = $env$.userid
SQL    select show_rate_type from gl_lookups_rate_type_v where rate_type = 'H'
SQL    select to_char(sysdate,'DD-MON-RRRR') from dual
SQL    select to_char(sysdate,'MM/DD/RRRR') from dual
SQL    select user_name from bne_integrators_tl where integrator_code = 'FUN_SINGLE_BATCH_INTG' and source_lang = userenv('LANG') and language = userenv('LANG')

 

2.4 Profile Option

---

1. 在页面上的例子

 

2. 在数据库中的例子

 

2.5 Lookups

---

1. 在页面上的例子

 

2. 在数据库中的例子

TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.BUSINESS_GROUP_NAME
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.P_DATE_EFFECTIVE
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.P_DATE_FROM
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.STYLE
TABLELOOKUP    $TABLE$.UP_VSET_VALUE.P_FLEX_VALUE
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.CURRENCY_CODE
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.OBJECT_NAME
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.PARENT_OBJECT_ID
TABLELOOKUP    $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_COST
TABLELOOKUP    $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_UNITS
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.ASS_ID
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.CAL_TYPE
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.CI_SEQUENCE_NUMBER
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.LOCATION_CD
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UNIT_CD
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UNIT_CLASS
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UOO_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.ALTERNATE_CODE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.ANONYMOUS_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.BATCH_DATE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.CAL_TYPE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.CI_SEQUENCE_NUMBER
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.COURSE_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.GRADE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.LOCATION_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.MARK
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.PERSON_NUMBER
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UNIT_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UNIT_CLASS
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UOO_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.USER_ID
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.ANONYMOUS_ID
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.BATCH_DATE
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.COURSE_CD
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.PERSON_NUMBER
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.PROGRESSION_OUTCOME_TYPE
TABLELOOKUP    $table$.INSERT_BATCH_LINES.P_DATE_FROM
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.HEADER
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.LAY_SEQ_NUM
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCE
TABLELOOKUP    $table$.gcs_hier_members_t.PARENT_VS_DISPLAY_CODE
TABLELOOKUP    $table$.upload_header.p_operating_entity_id

 

Thanks and Regards