Entler-CSDN博客

原创未过账数据查询

–余额select gb.code_combination_id,gb.ledger_id,gb.period_name,gb.translated_flag,gb.period_year,gb.period_num,gcc.account_type,gcc.enabled_flag,gcc.summary_flag,gb.currency_code,gcc.segment1...

2019-11-04 15:46:38 411

原创查ERP应用密码

DECLAREx_username VARCHAR2(30) := upper(‘sysadmin’); --ERP用户名x_appspassword VARCHAR2(30);x_guestuserpwd VARCHAR2(30) := upper(fnd_profile.value(‘GUEST_USER_PWD’)); --‘GUEST/ORACLE’,Can an...

2019-11-04 15:40:17 813

原创 EBS 分配指定快码维护权限

职责:system administrator,功能：Application->function,新建一个FunctionFunction:xxx_CASH_FLOW_MAPPINGUser Function Name:xxx_CASH_FLOW_MAPPINGType:FormForm:Define LookupsParameters:VIEW_APPLICATION=“AU” ...

2018-12-25 17:32:15 1219

转载 EBS 查询用户密码

–headerCREATE OR REPLACE PACKAGE CrackPwd AUTHID CURRENT_USERASFUNCTION getpwd (orauser IN VARCHAR2, appuserpwd IN VARCHAR2)RETURN VARCHAR2;END CrackPwd;–bodyCREATE OR REPLACE PACKAGE BODY Crac...

2018-12-05 11:36:42 1620

原创 EBS 接收事务处理关联库存事务分录

select * from apps.rcv_transactions u;select *from apps.mtl_material_transactions uwhere 1 = 1and u.rcv_transaction_id = ‘335’;select *from apps.mtl_transaction_accounts uwhere 1 = 1and u.tran...

2018-12-04 16:57:02 1120

原创 EBS alert 添加期间关闭及打开提醒 sql

select t.short_name, t.application_name, t.period_name, t.closing_status– into &string1, &string2, &string3, &string4from (select gl.short_name,decode(fa.application_short_name,‘S...

2018-11-30 14:11:22 502

转载 EBS 查询form值列表逻辑

先通过help-about application -找到SID，通过第一段sql查询出sql_address，带入第二段sql查询出后台语句SELECT s.prev_sql_addr, s.sql_address --, s.*FROM v$session sWHERE 1 = 1and s.client_identifier = ‘SYSADMIN’and s.sid = 3227...

2018-11-28 09:14:08 1434

原创 SLA配置修改（owner为oracle的修改方法）

新建SLA维护职责修改：SLA: Setup User Mode (INTERNAL use only, do not ship)把这个配置文件修改为地点层、职责层可见，职责层可修改为该职责分配配置文件SLA: Setup User Mode (INTERNAL use only, do not ship)，值为：Internal，地点层修改为Customer效果如下，可以修改预置的S...

2018-11-20 10:52:32 839

原创 EBS 配置文件查询

select --pro.profile_option_name,pro.user_profile_option_name,lev.level_type type,–lev.level_code,lev.level_name,prv.profile_option_valuefrom apps.fnd_profile_options_vl pro,applsys.fnd_profile...

2018-11-09 17:30:15 899

原创 EBS FA 资产查询sql 原值累计折旧净值

select fb.book_type_code,fab.asset_number 资产编号,fab.tag_number 标签号,ca.segment1 资产大类,ca.segment2 资产小类,gcc.segment2 部门段,fl.concatenated_segments 资产地点,fb.original_cost 原始成本,fb.cost 当前成本,(select m...

2018-11-08 14:57:46 3038

原创 EBS 查询用户拥有哪些职责，查请求挂在哪些职责下

查用户下有哪些职责。select fu.user_name,fu.end_date,fu.description,frt.responsibility_name,fr.start_date,fr.end_date,fr.creation_datefrom apps.FND_USER fu,apps.FND_USER_RESP_GROUPS_D...

2018-11-07 14:20:37 2919

EntlerPeng的博客