How To Collect Diagnostic Data to Troubleshoot Create Accounting in Oracle Assets?

Applies to:

Oracle Assets - Version: 12.0.0
Information in this document applies to any platform.
FAACCPB - Create Accounting - Assets
XLAACCUP - Accounting Program

Goal

How to collect diagnostic data to troubleshoot Create Accounting in Oracle Assets ?

Solution

1. Prepare the test case by entering problem transaction (ie transfer, unplanned depreciation, etc).

2. Set Profile Options:
SLA: Enable Diagnostics = YES
FND: Debug Log Enabled = YES
FND: Debug Log Level = Statement
FND: Debug Log Module = %

3. Run Create Accounting with parameters:
- Accounting mode: Draft
- Report: Detail
- Include User Transaction Identifiers: Yes

4. Collect FND Debug log (extract in csv/xls format) :
- make sure to provide request id of Accounting Program not Create Accounting - Assets.

--debug for concurrent request Accounting Program
SELECT tcon.TRANSACTION_TYPE, tcon.TRANSACTION_ID,tcon.component_type,
MESSAGE_TEXT, substr(module,1,70)
FROM fnd_log_messages msg,
fnd_log_transaction_context tcon
WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
AND tcon.TRANSACTION_ID = &request_id
ORDER BY tcon.TRANSACTION_CONTEXT_ID desc, LOG_SEQUENCE;


5. Run Transaction Object Diagnostics Report
- make sure you enter Accounting Program Request Id parameter

6. Generate Asset Trace of the Asset encountering the problem

Note: For releases pre-R12.1, if you don't already have it, make sure the version with FATRACE - SLA Subrequest is available in your system. This version is delivered via  Patch 6741301

7. Extract package body depending on the problem journal:

a) for issues with Transaction journal :

set pages
spool FA_XLA_EXTRACT_TRX_PKG.pls
select text from dba_source
where name = 'FA_XLA_EXTRACT_TRX_PKG'
and type = 'PACKAGE BODY';
spool off

b) for issues with Depreciation journal :

set pages
spool FA_XLA_EXTRACT_DEPRN_PKG.pls
select text from dba_source
where name = 'FA_XLA_EXTRACT_DEPRN_PKG'
and type = 'PACKAGE BODY';
spool off


c) for issues with Deferred depreciation journal :

set pages
spool FA_XLA_EXTRACT_DEF_PKG.pls
select text from dba_source
where name = 'FA_XLA_EXTRACT_DEF_PKG'
and type = 'PACKAGE BODY';
spool off

8. Provide versions of seeded Application Accounting Definition (AAD):
adident Header $FA_TOP/patch/115/import/US/FAXLAAAD.ldt

9. Get the Application Accounting Definition (AAD) package body definition from database. This applied only for cases when there's a problem specific to :
- incorrect Account Combination generated by Account Derivation Rule (ADR)
- ADR failing to generate Account Combination

- the following needs to be run from SQL Plus session under APPS:

(Note: 'XLA_00140_AAD_C_%' should be changed to 'XLA_00140_AAD_S_%' for seeded AAD)

 

set termout off
set pages
variable pkg_name varchar2(50)
begin
select object_name
into :pkg_name
from dba_objects
where object_type = 'PACKAGE BODY'
and object_name like (select distinct 'XLA_00140_AAD_C_%' || r.product_rule_hash_id || '_PKG' pkg_name
from xla_product_rules_tl t
, xla_product_rules_b r
where name = '&AAD_name'
and r.product_rule_code = t.product_rule_code
and r.amb_context_code = 'DEFAULT');
end;
/
spool AADpkg.pls
select text from dba_source
where type = 'PACKAGE BODY'
AND name = :pkg_name
/
spool off

All the information collected using above steps needs to be seen as one concise picture to troubleshoot the problem you're encountering with Create Accounting in Oracle Assets.

Make sure the content uploaded contains following:
- Output file of Create Accounting - Assets
- Log file of Create Accounting - Assets
- Log file of Accounting program
- FND Debug log (Step #4)
- Output of Transaction Object Diagnostics Report
- Output of Generate Asset Trace
- Output of FATRACE - SLA Subrequest
- Extract of applicable package bodies (Steps #7, #9)

References

Note 402842.1 - How To Run An Asset Trace?

Keywords

XLAACCUP ; FAACCPB ; CREATE~ACCOUNTING ;