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:budgetNamePARAMETER gl:currencyPARAMETER gl:ledgerNamePARAMETER gl:organizationPARAMETER gl:periodYearPARAMETER gl:updateMode
2.3 SQL
1. 在页面上的例子
2. 在数据库中的例子
SQL SELECT $PARAM$.PER:India_Medical_Bill_Param FROM DUALSQL SELECT $PROFILES$.PER_RI_WEBADI_BG_ID FROM DUALSQL SELECT ACCESS_SET_ID FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = $PROFILES$.GL_ACCESS_SET_IDSQL SELECT ADB_FLAG FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID=:SOB_IDSQL SELECT AMS_ADI_UPLOAD_BATCH_S.nextval from dualSQL SELECT BUDGET_ENTITY_ID FROM GL_BUDGET_ENTITIES WHERE NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_ENTITY_NAMESQL SELECT BUDGET_VERSION_ID FROM GL_BUDGET_VERSIONS WHERE BUDGET_NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_NAMESQL 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 DUALSQL SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM DUALSQL 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_IDSQL SELECT OZF_RESALE_BATCH_NUMBER_S.NEXTVAL FROM DUALSQL SELECT TO_CHAR(SYSDATE,'DD-MON-RRRR') FROM DUALSQL SELECT TRUNC(SYSDATE) from dualSQL SELECT USERENV('LANG') FROM DUALSQL SELECT USER_JE_SOURCE_NAME FROM GL_JE_SOURCES_V WHERE JE_SOURCE_NAME = $PROFILES$.GLDI_JOURNAL_SOURCESQL SELECT fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE') FROM dualSQL SELECT fnd_profile.value('PER_BUSINESS_GROUP_ID') from dualSQL SELECT gcs_dimension_members_t_s.NEXTVAL FROM DUALSQL SELECT gcs_entry_headers_s.NEXTVAL FROM DUALSQL SELECT gcs_hier_members_t_s.NEXTVAL FROM DUALSQL 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$.orgIdSQL SELECT name FROM hr_operating_units WHERE organization_id = $PROFILES$.DEFAULT_ORG_IDSQL Select $PARAM$.ORGANIZATION from dualSQL Select $PARAM$.test_param from dualSQL 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_IDSQL Select trunc(sysdate) from dualSQL select $PROFILES$.PER_RI_WEBADI_BG_ID from dualSQL select $PROFILES$.PQP_RI_INTERFACE_CODE from dualSQL select AMS_ADI_UI_INSTANCE_S.nextval from dualSQL select AMS_ADI_UPLOAD_BATCH_S.nextval from dualSQL select AMW_AUDIT_PROCEDURE_INT_S1.nextval from dualSQL select AMW_CONSTRAINT_INTERFACE_S1.nextval from dualSQL select ITA_SETUP_REC_INTF_S2.nextval from dualSQL select LEGISLATION_CODE from per_business_groups where business_group_id =$PROFILES$.PER_RI_WEBADI_BG_IDSQL select PA_FP_WEBADI_UPLOAD_INF_S.nextval from dualSQL select RESOURCE_NAME from jtf_rs_resource_extns_vl where user_id = $env$.useridSQL select amw_ap_interface_s1.nextval from dualSQL select amw_ctrl_interface_s1.nextval from dualSQL select amw_key_acc_interface_s2.nextval from dualSQL select amw_processes_interface_s2.nextval from dualSQL select amw_rcm_org_interface_s2.nextval from dualSQL select amw_risk_ctrl_interface_s2.nextval from dualSQL 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$.LedgerIdSQL select fnd_profile.value('AMS_SRCGEN_USER_CITY') from dualSQL select fun_system_options_pkg.get_default_currency() from dualSQL select gcs_entry_headers_s.nextval from dualSQL select legislation_code from per_business_groups where business_group_id = $PROFILES$.PER_RI_WEBADI_BG_IDSQL 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$.LedgerIdSQL select ota_general.get_org_name($PROFILES$.PER_RI_WEBADI_BG_ID) from dualSQL select resource_id from jtf_rs_resource_extns where user_id = $env$.useridSQL select show_rate_type from gl_lookups_rate_type_v where rate_type = 'H'SQL select to_char(sysdate,'DD-MON-RRRR') from dualSQL select to_char(sysdate,'MM/DD/RRRR') from dualSQL 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_NAMETABLELOOKUP $TABLE$.INSERT_BATCH_LINES.P_DATE_EFFECTIVETABLELOOKUP $TABLE$.INSERT_BATCH_LINES.P_DATE_FROMTABLELOOKUP $TABLE$.INSERT_BATCH_LINES.STYLETABLELOOKUP $TABLE$.UP_VSET_VALUE.P_FLEX_VALUETABLELOOKUP $table$.AMS_ADI_CAMPAIGNS_INTERFACE.CURRENCY_CODETABLELOOKUP $table$.AMS_ADI_CAMPAIGNS_INTERFACE.OBJECT_NAMETABLELOOKUP $table$.AMS_ADI_CAMPAIGNS_INTERFACE.PARENT_OBJECT_IDTABLELOOKUP $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_COSTTABLELOOKUP $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_UNITSTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.ASS_IDTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.CAL_TYPETABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.CI_SEQUENCE_NUMBERTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.LOCATION_CDTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.UNIT_CDTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.UNIT_CLASSTABLELOOKUP $table$.IGS_AS_AIO_INTERFACE.UOO_IDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.ALTERNATE_CODETABLELOOKUP $table$.IGS_AS_UG_INTERFACE.ANONYMOUS_IDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.BATCH_DATETABLELOOKUP $table$.IGS_AS_UG_INTERFACE.CAL_TYPETABLELOOKUP $table$.IGS_AS_UG_INTERFACE.CI_SEQUENCE_NUMBERTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.COURSE_CDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.GRADETABLELOOKUP $table$.IGS_AS_UG_INTERFACE.LOCATION_CDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.MARKTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.PERSON_NUMBERTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.UNIT_CDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.UNIT_CLASSTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.UOO_IDTABLELOOKUP $table$.IGS_AS_UG_INTERFACE.USER_IDTABLELOOKUP $table$.IGS_PR_SPO_INTERFACE.ANONYMOUS_IDTABLELOOKUP $table$.IGS_PR_SPO_INTERFACE.BATCH_DATETABLELOOKUP $table$.IGS_PR_SPO_INTERFACE.COURSE_CDTABLELOOKUP $table$.IGS_PR_SPO_INTERFACE.PERSON_NUMBERTABLELOOKUP $table$.IGS_PR_SPO_INTERFACE.PROGRESSION_OUTCOME_TYPETABLELOOKUP $table$.INSERT_BATCH_LINES.P_DATE_FROMTABLELOOKUP $table$.JTY_WEBADI_OTH_TERR_INTF.HEADERTABLELOOKUP $table$.JTY_WEBADI_OTH_TERR_INTF.LAY_SEQ_NUMTABLELOOKUP $table$.JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCETABLELOOKUP $table$.gcs_hier_members_t.PARENT_VS_DISPLAY_CODETABLELOOKUP $table$.upload_header.p_operating_entity_id
Thanks and Regards