Oracle ebs ap表结构,oracle,ebs,r12,常用表表结构总结之ap.docx
oracle,ebs,r12,常用表表结构总结之ap
EBSR12install(ap/db在同一台机器) ip: os:redhatlinuxx64 [root@siotest1ftptest]#lvcreate-nebstest-L280GVolGroup00 [root@siotest1ftptest]#/dev/VolGroup00/ebstest [root@siotest1ftptest]#mount/dev/VolGroup00/ebstest/ebstest/ [root@siotest1/]#useradd-Goinstalltebsora [root@siotest1/]#useradd-Goinstalltebsapp [root@siotest1/]#passwdtebsora [root@siotest1/]#passwdtebsapp [root@siotest1ebstest]#pwd /ebstest [root@siotest1ebstest]#mkdirtebsdb [root@siotest1ebstest]#mkdirtebsapp [root@siotest1ebstest]#chowntebsdb [root@siotest1ebstest]#chowntebsapp [root@siotest1ebstest]#ll total24 drwx------2rootroot16384Jun1715:15lost+founddrwxr-xr-x2tebsappoinstall4096Jun1715:27tebsappdrwxr-xr-x2tebsoraoinstall4096Jun1715:27tebsdb 1设置系统配置文件：PersonalizeSelf-ServiceDefn FND:PersonalizationRegionLinkEnabled 2、重新登录系统，点击右上角“个性化页” 3、选择完整视图 4、展开"TableLayout:(topTableLayoutContainer)"then "RowLayout:(tableLayoutRow)"then "CellFormat:(worklistResponsibilityLeftCell)"，选择个性化 5.、在地点层更改为TRUE。 6、把前面设置的系统配置文件改回原有设置，重新登录系统，界面如下： ORACLEEBS常用表 XX-09-2511:21 callfnd__INITIALIZE(1318,50583,401) selectfnd_('ORG_ID')FROMDUAL select*fromhr_operating_unitshouwhere_id=204--fnd select*fromfnd_application select*fromfnd_application_tlwhereapplication_id=101 select*fromfnd_application_vlwhereapplication_id=101----值集 select*fromfnd_flex_value_sets select*fromfnd_flex_values select*fromfnd_flex_values_vl ----弹性域 SELECT*FROMFND_ID_FLEX_STRUCTURES_VL—键弹性域 select*fromfnd_id_flexs select*fromfnd_id_flex_structureswhereid_flex_code='GL#'select*fromfnd_id_flex_segmentswhereid_flex_code='GL#'andid_flex_num=50671 select*fromfnd_profile_options_vl select*fromfnd_concurrent_programs程序表 select*fromfnd_concurrent_requests请求表 select*fromfnd_concurrent_processes进程表 --inv select*fromorg_organization_definitions库存组织 select*frommtl_parameters组织参数 select*frommtl_system_items_bwhereinventory_item_id=171andorganizati
Oracle ebs ap表结构,oracle,ebs,r12,常用表表结构总结之ap.docx
oracle,ebs,r12,常用表表结构总结之ap
EBSR12install(ap/db在同一台机器) ip: os:redhatlinuxx64 [root@siotest1ftptest]#lvcreate-nebstest-L280GVolGroup00 [root@siotest1ftptest]#/dev/VolGroup00/ebstest [root@siotest1ftptest]#mount/dev/VolGroup00/ebstest/ebstest/ [root@siotest1/]#useradd-Goinstalltebsora [root@siotest1/]#useradd-Goinstalltebsapp [root@siotest1/]#passwdtebsora [root@siotest1/]#passwdtebsapp [root@siotest1ebstest]#pwd /ebstest [root@siotest1ebstest]#mkdirtebsdb [root@siotest1ebstest]#mkdirtebsapp [root@siotest1ebstest]#chowntebsdb [root@siotest1ebstest]#chowntebsapp [root@siotest1ebstest]#ll total24 drwx------2rootroot16384Jun1715:15lost+founddrwxr-xr-x2tebsappoinstall4096Jun1715:27tebsappdrwxr-xr-x2tebsoraoinstall4096Jun1715:27tebsdb 1设置系统配置文件：PersonalizeSelf-ServiceDefn FND:PersonalizationRegionLinkEnabled 2、重新登录系统，点击右上角“个性化页” 3、选择完整视图 4、展开"TableLayout:(topTableLayoutContainer)"then "RowLayout:(tableLayoutRow)"then "CellFormat:(worklistResponsibilityLeftCell)"，选择个性化 5.、在地点层更改为TRUE。 6、把前面设置的系统配置文件改回原有设置，重新登录系统，界面如下： ORACLEEBS常用表 XX-09-2511:21 callfnd__INITIALIZE(1318,50583,401) selectfnd_('ORG_ID')FROMDUAL select*fromhr_operating_unitshouwhere_id=204--fnd select*fromfnd_application select*fromfnd_application_tlwhereapplication_id=101 select*fromfnd_application_vlwhereapplication_id=101----值集 select*fromfnd_flex_value_sets select*fromfnd_flex_values select*fromfnd_flex_values_vl ----弹性域 SELECT*FROMFND_ID_FLEX_STRUCTURES_VL—键弹性域 select*fromfnd_id_flexs select*fromfnd_id_flex_structureswhereid_flex_code='GL#'select*fromfnd_id_flex_segmentswhereid_flex_code='GL#'andid_flex_num=50671 select*fromfnd_profile_options_vl select*fromfnd_concurrent_programs程序表 select*fromfnd_concurrent_requests请求表 select*fromfnd_concurrent_processes进程表 --inv select*fromorg_organization_definitions库存组织 select*frommtl_parameters组织参数 select*frommtl_system_items_bwhereinventory_item_id=171andorganizati