Saturday, July 5, 2008

Debug Validate Application Accounting Definition error

1. Please set these profile options:

FND: Debug Log Enabled - Yes
FND: Debug Log Module - %
FND: Debug Log Level - Statement

2. Then run the Validate Application Accounting Definitions concurrent program with the following parameters:
Ledger: Pick the ledger
Uncompiled status only: Yes
Application: Assets
Application Accounting Definition Owner: User

3. Re-run the query with the last Validate Application Accounting Definitions run request ID:

set pagesize 0
set linesize 300

SELECT log_sequence, message_text,substr(module,1,100)
FROM fnd_log_messages msg, fnd_log_transaction_context tcon
WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
AND tcon.TRANSACTION_ID=
ORDER BY LOG_SEQUENCE;

This will now return the full debug.

No comments: