oracle accounting,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 ;