【正文】
a Debug in Receivables in ? ? How to run a Payables Concurrent Program in Debug Mode? ? How to generate a debug file in OM? ? How to Generate and Return the PO Document Approval Manager Trace Debug Data ? How to Generate Receiving Transaction Debug Statements in and R12? ? How To Debug WIP? ? How to get Debug Information for Inventory Material Transaction? How to get Forms Level Trace and FRD? What is FRD? ? FRD is Forms Runtime Diagnostics ? The Forms Runtime Diagnostics (FRD) logging mechanism was introduced in Forms , and is a key tool for investigating and debugging Forms problems. When enabled, it logs every user action, every trigger that fires, every forms builtin called, and value changes (deltas) of Forms items How to get Forms Level Trace and FRD? 1. 在用戶層設(shè)置 profile option 39。 . update the value of ICX: Forms Launcher for the user to be play=record=collectlog=/tmp/ = 2. 用戶重新登錄系統(tǒng),并獲得啟用 Form Runtime Diagnostics的提示信息 . 3. 完成測(cè)試后,在應(yīng)用服務(wù)器的下列路徑 $FORMS60_TRACE_PATH找到 debug文件 Note: the default directory for $FORMS60_TRACE_PATH is $ORACLE_HOME/forms60/log. $FORMS_TRACE_DIR How to get Forms Level Trace and FRD? How to get Forms Level Trace and FRD? ? FRD log output How to get Forms Level Trace and FRD? ? 在 Form中啟用 Trace Forms level trace is SQL trace generated before the transaction is saved on a form. It is enabled from the form and captures SQL code related to the execution of the form. This should be used when the error occurs on the form BEFORE clicking on the save. Typically these are FRM or APP errors but there could be other varying error messages. 啟用步驟 : Navigate to the point in the application right before you are experiencing the problem. Turn trace on by: Help Diagnostics Trace Trace with Binds (May require password) A popup message with trace file location and name will be displayed. Note the filename and path. Duplicate the error and then stop immediately afterwards. Help Diagnostics Trace No Trace 生成的 Trace file存在在數(shù)據(jù)庫服務(wù)器 user_dump_dest對(duì)應(yīng)的目錄中 ,可使用下列 SQL找到具體路徑 select value from V$PARAMETER where name like 39。 使用 tkprof命令解析 Trace信息 : tkprof filename.trc filename.out explain=found username/password example: tkprof explain=apps/apps How to get Forms Level Trace and FRD? How To Get FND Debug? ? 切換到系統(tǒng)管理員職責(zé) : ? Navigate : System Administrator Profile = System ? 在用戶層查找 FND profile options for User who is submitting the process to debug. ? User: User submitting the process ? Profile: FND:%Debug% ? 在用戶層設(shè)置下列 Profile values并保存 ? FND: Debug Log Enabled :Yes ? FND: Debug Log Level : STATEMENT ? FND: Debug Log Module : % How To Get FND Debug? How To Get FND Debug? ? 執(zhí)行操作前,執(zhí)行下列 SQL, SELECT MAX(log_sequence) from fnd_log_message。 ? ,在日志中檢查輸出信息 。UTL_FILE_DIR39。 ,執(zhí)行下列 SQL查看 Debug輸出 : SELECT , FROM FND_LOG_MESSAGES LOG Where user_id = user_id and log_sequence max_logsequence ORDER BY 。UTL_FILE_DIR39。 Order 工作臺(tái) From go to Tools Debug and get note message(. The log file is XXX). How to generate a debug file in OM? ? B. 在并發(fā)請(qǐng)求中獲得 debug 信息 : 在用戶層設(shè)置 profile option OM: Debug Level to 5. Debug信息將生成并發(fā)請(qǐng)求的 log文件 . 在并發(fā)請(qǐng)求的 log文件中查看 debug信息 Navigate to View Requests Relevent Request_id (button). Click View Output Save file as . How to Generate and Return the PO Document App