Oracle eBS經驗分享

Responsibility : Receivables User

Path: Setup--> System --> System Options

Today I meet a problem in Test env.

My intercompany ARs can't be produced.

我發現MMT 裡的交易Costed 都是No，造成Intercompany AR無法產生

原來是我們的測試區的 Cost Management被停掉

• Responsibility : Inventory Super User

• Path : Inventory / Setup / Transactions / Interface Managers

on line 'cost manager' - do Tools > Launch

Launch 完後 : Cost Manager Status = "Active" 就可以了！！

因Drop Shipment Order 可能因Item Default Buyer設定不同，造成一張SO產生的PR會拆單，

為了避免這種狀況發生，設定這個 Profile: OM: Population Of Buyer Code For Dropship Lines

<<以下是在測試環境 測試紀錄>>

資料來源：Symplik

在Oracle 11i及r12中，APPS的密碼藏於FND_USER table中的ENCRYPTED_FOUNDATION_PASSWORD欄位。只要你知道任何一個 FND User (即用戶帳號）的密碼，你就可以把 APPS 的密碼分解出來。而最簡單的帳號就是GUEST，因為每一個instance都有此內設帳號，而它的密碼預設為ORACLE。有些DBA會把更改這密碼，不過這密碼可以從以下query找出來：

SELECT 

B.PROFILE_OPTION_VALUE

FROM 

FND_PROFILE_OPTIONS A,

FND_PROFILE_OPTION_VALUES B

WHERE 

A.PROFILE_OPTION_NAME='GUEST_USER_PWD' AND

B.PROFILE_OPTION_ID=A.PROFILE_OPTION_ID; 

Foundation Hash是指用戶帳號、帳號密碼及APPS密碼互相衍生的亂碼:

SELECT ENCRYPTED_FOUNDATION_PASSWORD FROM FND_USER WHERE USER_NAME='GUEST';

-- 或其他你知道密碼的帳號來代替GUEST

然後把此亂碼放在 => http://web.symplik.com/APPSPassword_ZHT.jsp。

資料來源：Symplik

How to do that
Assuming the original login page is

http(s)://[APPL_TOP Server]:[port]/OA_HTML/AppsLocalLogin.jsp

For simplicity, this URL is represented by

[Apps URL]/OA_HTML/AppsLocalLogin.jsp

To goto the Apps Home Page (i.e. Navigator Page) without entering the username and password, you can use the URL:

[Apps URL]/OA_HTML/fndvald.jsp?username=[login name]&password=[password]

If you want to create another Login Page rather than using the the one provided by Oracle, you can include this HTML code in your page:

<form method="post" action="[Apps URL]/OA_HTML/fndvald.jsp">
  <input type="text" name="username" value=""/>
  <input type="password" name="password" value=""/>
  <input type="submit" name="login" value="submit" />
</form>

To launch any Form or OA Framework Page using direct URL, you must obtain the Form or page URL from the Navigator Page, as shown in here:

Move your cursor to the the link, right click, and select "Copy Shortcut"
For Forms, the shortcut looks like (this is the OM Sales Order Form):

javascript:launchForm('[Apps URL]/OA_HTML/RF.jsp?function_id=5522&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US&oas=129LdJJoQltOPAQwtQlOFQ..')

Just take the javascript function parameter, remove the last query string parameter, and it will look like:

[Apps URL]/OA_HTML/RF.jsp?function_id=5522&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US

For OA Framework Pages, copy the shortcut and it looks like (this is the Workflow Notification Page):

[Apps URL]/OA_HTML/RF.jsp?function_id=2043&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US&params=HjNYXS4MZviS3zdx5xBFd7eSJJ8O3MKDbqmDsTMdo7E&oas=FQvfEQgSdW25KedN-Jstpw..

Again, remove the last query string parameter and it will look like:

[Apps URL]/OA_HTML/RF.jsp?function_id=2043&resp_id=50349&resp_appl_id=660&security_group_id=0&lang_code=US

Next, you need to URLEncode this URL string, like using this page to do it:

[Apps URL]%2fOA_HTML%2fRF.jsp%3ffunction_id%3d2043%26resp_id%3d50349
%26resp_appl_id%3d660%26security_group_id%3d0%26lang_code%3dUS

Finally, the Direct URL for launching a Form or page will be:
[apps URL]/OA_HTML/fndvald.jsp?username=[username]&password=[password]&requestUrl=[urlencoded URL string]