摘要：客户可以通过Help > Diagnostics > Custom Code > Personalize，来对Form做个性化的设置。如何通过脚本来查看Form做了哪些个性化SELECT * FROM FND_FORM_CUSTOM_RULES WHERE form_name = 'INVTOMAI';--Input your Form NameSELECT * FROM FND_FORM_CUSTOM_ACTIONS WHERE RULE_ID IN (SELECT ID FROM fnd_form_custom_rules WHERE form_name
阅读全文
摘要：Oracle Apps Script to create a new User Login Account--CREATE a new user account DECLARE p_user_name VARCHAR2 (200) := 'PTIAN'; p_owner VARCHAR2 (200) := NULL; p_unencrypted_password VARCHAR2 (200) := 'welcome'; p_session_number NUMBER ...
阅读全文
摘要：1.Using script to submit INV Manager to process MMTT/*
* When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for * these variables. The values can be obtained by logging into Inventory * reponsibility and from menu Help->Diagnostics->Examine, select block as *
阅读全文
摘要：Transaction Type = Transaction Source Type + Transaction Actioneg.Move Order Issue = Move Order + Issue From StoresBelow is the script to check Txn Type, Txn Source Type, Txn Action(Lookups)--Txn Type
SELECT TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID
阅读全文
摘要：Looking on how to check long running concurrent request in Oracle Apps 11i or R12? Here’s the overview of the SQL query script to detect the session information of each program.First you need to get the listing of running concurrent request in Oracle Apps 11i or R12. You can use the SQL query script
阅读全文
摘要：知道Form执行文件的名字情况下，如何来查找对应的功能名称SELECT a.form_name||' : '||nvl(b.description, b.user_form_name)
FROM APPS.FND_FORM a, APPS.FND_FORM_TL b
WHERE a.form_id = b.form_id
AND a.form_name IN ('INVTTMTX');Output:INVTTMTX : Perform miscellaneous transactions知道功能名称的情况下，如何来查找对应的fmx名称SELECT a.form_
阅读全文
摘要：系统版本信息装了哪些模块，以及版本信息select 'Current Application Release: '||ver||' ('||bug||')' "Description" from (
select x.* from
(select 1 seq, '1939818' bug,'11.5.0' pv,'11.5.6' ver from dual
union select 2,'2123967','11.5.0','11.5.7&
阅读全文
摘要：How to Re-Compile All Invalid for Oracle EBS Package/Package Bodyset serveroutput on size 1000000 declare
sql_statement varchar2(200);
cursor_id number;
ret_val number; CURSOR cur_invalid IS
select object_type, owner, object_name
from sys.dba_objects o
where o.status = 'INVALID'
and o.object
阅读全文
摘要：列出所有Scheduled Concurrent Programselect r.request_id, p.user_concurrent_program_name || case when p.user_concurrent_program_name = 'Report Set' then (select ' - ' || s.user_request_set_name from apps.fnd_request_sets_tl s where s....
阅读全文
摘要：脚本用于Backorder有问题Delivery Detail（比如关联的Move Order丢失...），可以backorder Delivery后，再重新Pick Release；如果不想要这个订单了，可以Backorder后，Cancel销售订单，并通过NOTE:1322105.1来删除多余的Reservation。UPDATE wsh_delivery_assignments
SET delivery_id = NULL, parent_delivery_detail_id = NULL, last_updated_by ...
阅读全文
摘要：订单的关闭是自动的，在所有行工作流结束（Close或者Cancel）后0.5天，订单头也将在Workflow Background Process的推动下关闭。还有另外一种说法：you can wait until month-end and the “Order Flow – Generic” workflow will close it for you.所以造成了很多时候订单行已经关闭了，但订单头还是处于Booked状态，这个时候如果你想Close订单头，你可以手动运行Workflow Background Process来关闭订单，也可以使用脚本来close Order Header.脚
阅读全文
摘要：如果忘记了EBS登陆页面的链接怎么办,如果你还可以访问数据库，有尝试用下边两个SQL来查看登陆页面链接方法1：SELECT home_url FROM icx_parameters;output like:http://xxx.com:8001/OA_HTML/AppsLogin
方法2：SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id F...
阅读全文
摘要：rem -----------------------------------------------------------------------
rem Filename: appinfo.sql
rem Purpose: Script to display status of all the Concurrent Managers
rem Author: Anonymous
rem ----------------------------------------------------------------------- set head on column O...
阅读全文
摘要：原文:http://oraqa.com/2006/12/27/how-to-determine-which-patches-have-been-applied/There are two tables that contain information about patches applied to your Oracle E-Business Suite applications:AD_APPLIED_PATCHEScontains the list of patches that weredirectlyapplied.AD_BUGScontains the list of all the
阅读全文
摘要：EBS PO Approve Scriptdeclare x_po_head_id number ;
begin select po_header_id
into x_po_head_id
from po_headers_all where
segment1 = '&ponumber'
and org_id = &org_id; update po_headers_all
set authorization_status = 'APPROVED',
approved_flag = 'Y',
approved_date = sysd
阅读全文
