ACCESSWebADI_配置设定10_设定专擅认同值Attribute Default Value(案例)

20150906 Created By BaoXinjian

ACCESS 1一、摘要


6种暗许值设定

  1. Environment Parameters

OAUSER.ID / SYSDATE / DATABASE
常用的,

别的一些sob 的,
例如sob.chartofaccountsid, sob.periodsetname,
sob.setofbooksid之类的,也不知还是能无法用, 还没测

  1. Constant

那几个最简便,直接写个东西进去就行了。

  1. Paramter

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

  1. SQL

那 个也简单,写个SQL
完事,结果多行的话,取第壹,行。

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

  1. Profile Option

从字面上掌握,是用来取配置文件中某些option的值,但本身测了,不成事,不知是bug依旧其余原因.

  1. Lookups

不知缘何的,前两日无意看到有个规范的Integrator具然包括多少个Interface,
而Interface 间的连通就像就用那些。。。

因为此项在后台叫TABLELOOKUP…
多Interface的Integrator还不知如何做,待探究.

ACCESS 2

 

ACCESS 32.1
Environment Parameters


  1. 在页面上的事例

ACCESS 4

  1. 在数据库中的例子

ACCESS 5

 

ACCESS 62.2
PARAMETERS


  1. 在页面上的事例

 

  1. 在数据库中的例子

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

 

ACCESS 72.3
SQL


  1. 在页面上的事例

 

  1. 在数据库中的例子

    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’)

 

ACCESS 82.4
Profile Option


  1. 在页面上的例子

 

  1. 在数据库中的例子

ACCESS 9

 

ACCESS 102.5
Lookups


  1. 在页面上的例证

 

  1. 在数据库中的例子

    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

ACCESS 11

相关文章