Report error

[Roshan]

Hi,

reports are completed in error. I cannot find any errors in the log.

image863.png
l1430470_SUNLimited_Yash.l1430470_SUNLimited_Yash
+---------------------------------------------------------------------------+
Subledger Accounting: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

XLAACCPB: Create Accounting
+---------------------------------------------------------------------------+

Current system time is 23-MAR-2016 10:13:11

+---------------------------------------------------------------------------+

XDO Data Engine Version No: 10.1.3.4.2
Resp: 51072
Org ID : 125
Request ID: 1430470
All Parameters: P_APPLICATION_ID=222:P_SOURCE_APPLICATION_ID=222:P_DUMMY=Y:P_LEDGER_ID=2075:P_PROCESS_CATEGORY_CODE=:P_END_DATE="2016/03/23 00:00:00":P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE=F:P_DUMMY_PARAM_2=Y:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=N:P_TRANSFER_TO_GL_FLAG=Y:P_DUMMY_PARAM_3=Y:P_POST_IN_GL_FLAG=Y:P_GL_BATCH_NAME=:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Receivables:P_APPLICATION_NAME=Receivables:P_LEDGER_NAME=Sun Ltd Ledger:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Final:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=No Report:P_TRANSFER_TO_GL=Yes:P_POST_IN_GL=Yes:P_INCLUDE_ZERO_AMT_LINES=No:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=:P_SECURITY_INT_2=:P_SECURITY_INT_3=:P_SECURITY_CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLUDE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:DebugFlag=N:P_USER_ID=1363:ScalableFlag=N:P_LAUNCH_BALANCE_PROGRAM=Y:P_LAUNCH_BAL_PROGRAM=Yes
Data Template Code: XLAACCPB
Data Template Application Short Name: XLA
Debug Flag: N
{P_ACCOUNTING_REPORT_LEVEL=No Report, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Final, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=N, P_GL_BATCH_NAME=, P_END_DATE=2016/03/23 00:00:00, P_SECURITY_INT_3=, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=, P_LAUNCH_BAL_PROGRAM=Yes, P_POST_IN_GL=Yes, P_TRANSFER_TO_GL=Yes, P_TRANSFER_TO_GL_FLAG=Y, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=1363, P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=No, P_DUMMY_PARAM_3=Y, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=Y, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=, P_ENTITY_ID=, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=2075, P_POST_IN_GL_FLAG=Y, P_APPLICATION_ID=222, P_INCLUDE_USER_TRX_ID_FLAG=N, P_APPLICATION_NAME=Receivables, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=Sun Ltd Ledger, P_LAUNCH_BALANCE_PROGRAM=Y, P_SOURCE_APPLICATION_ID=222, P_CREATE_ACCOUNTING=Yes, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=, P_SOURCE_APPLICATION_NAME=Receivables, P_INCLUDE_ZERO_AMOUNT_LINES=N, P_ACCOUNTING_MODE=F}
Calling XDO Data Engine...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
23-MAR-2016 10:21:47 - FND: Debug Log Enabled : No
23-MAR-2016 10:21:47 - Beginning of the Report
23-MAR-2016 10:21:47 - Starting of the Parent Thread
Starting main program for the source application = 222
23-MAR-2016 10:21:47 - Dynamic conditions built
23-MAR-2016 10:21:47 - Event Applications Determined
23-MAR-2016 10:21:47 - Security Context Set
23-MAR-2016 10:21:47 - Session Identifier Set
23-MAR-2016 10:21:47 - Setup for the ledger and Event applications Read
23-MAR-2016 10:21:47 - executing preaccounting hook
arp_xla_extract_main_pkg.preaccounting()+
  p_application_id    :222
  p_ledger_id         :2075
  p_process_category  :
  p_end_date          :23-MAR-16
  p_accounting_mode   :F
  p_valuation_method  :
  p_security_id_int_1 :
  p_security_id_int_2 :
  p_security_id_int_3 :
  p_security_id_char_1:
  p_security_id_char_2:
  p_security_id_char_3:
  p_report_request_id :
arp_xla_extract_main_pkg.preaccounting -
event key = 7217-1430470
23-MAR-2016 10:21:47 - preaccounting hook executed successfully
23-MAR-2016 10:21:47 - Pre-Accounting steps performed
23-MAR-2016 10:21:47 - Queue Created = XLA.XLA_1430470_DOC_Q
23-MAR-2016 10:21:47 - Queue Created = XLA.XLA_1430470_COMP_Q
23-MAR-2016 10:21:47 - Queue Started = XLA.XLA_1430470_DOC_Q
23-MAR-2016 10:21:47 - Queue Started = XLA.XLA_1430470_COMP_Q
23-MAR-2016 10:21:47 - Global Context Initialized
23-MAR-2016 10:21:47 - Calling sequencing batch_init
23-MAR-2016 10:21:47 - Returned from sequencing batch_init
23-MAR-2016 10:21:47 - Begin enqueue
23-MAR-2016 10:21:47 - Ready to Enqueue documents in the queue
23-MAR-2016 10:21:47 - Ready to Enqueue documents in the queue
23-MAR-2016 10:21:47 - Spawning unit processors
23-MAR-2016 10:21:47 - Unit processors spawned
23-MAR-2016 10:21:51 - Ready to Enqueue documents in the queue
23-MAR-2016 10:22:51 - Enqueueing completed
23-MAR-2016 10:22:51 - Waiting for Unit Processor requests to complete
23-MAR-2016 10:22:51 -  Child Threads completed
23-MAR-2016 10:22:51 - Global Context cleared
23-MAR-2016 10:22:51 - Queue stopped = XLA.XLA_1430470_DOC_Q
23-MAR-2016 10:22:51 - Queue stopped = XLA.XLA_1430470_COMP_Q
23-MAR-2016 10:22:51 - Queue dropped = XLA.XLA_1430470_DOC_Q
23-MAR-2016 10:22:51 - Queue dropped = XLA.XLA_1430470_COMP_Q
23-MAR-2016 10:22:51 - Calling sequencing batch_exit
23-MAR-2016 10:22:51 - Returned from sequencing batch_exit
23-MAR-2016 10:22:51 - Executed post-accounting routine
23-MAR-2016 10:22:51 -  Accounting Program completed successfully
23-MAR-2016 10:22:51 - executing postaccounting hook
event key = 7217-1430470
23-MAR-2016 10:22:51 - postaccounting hook executed successfully
- Accounting Time = 64.19 secs
- Transfer Time   = 0 secs
23-MAR-2016 10:22:51 - End of the Report
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
2015


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-MAR-2016 10:22:59

+---------------------------------------------------------------------------+


Thanks,
Roshan

[Roshan]

This request finished with an error and produced the following completion message: The journal entry cannot be saved.  Please inform your system admiministrator or support representative that:

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01502: inde

The processing began on 23-MAR-2016 10:28:59 and ended on 23-MAR-2016 10:29:01. You may find more information on the cause of the error in the request log or the concurrent manager log.

[ErmanArslansOracleBlog]

It seems there is an unusable index or index partition. Find it and rebuild.
If it is not reported in the error message, then check the unusable indexes in dba_indexes table;

select owner, index_name from dba_indexes where status='UNUSABLE';

For partitions, check Dba_ind_partitions and for sub partitions chechk dba_ind_subpartitions.

Rebuild the unusable partition or index and retry.

Example command:
ALTER INDEX REBUILD PARTITION <partition_name>;

ALTER INDEX <index_name> rebuild;

[Roshan]

There is no unusable partition
SQL> select owner, index_name from dba_indexes where status='UNUSABLE';

no rows selected

[ErmanArslansOracleBlog]

Please read my updates carefully. Did you check index partitions?
Anyways, use this to produce the alter statements for you.

select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where status='UNUSABLE';
select 'alter index '||index_owner||'.'||index_name||' rebuild partition '||partition_name||';' from dba_ind_partitions where status='UNUSABLE';
select 'alter index '||index_owner||'.'||index_name||' rebuild subpartition '||subpartition_name||';' from dba_ind_subpartitions where status='UNUSABLE';

[Roshan]

O.k thanks. I did it. I found 6 unusable partitions.

I rebuilt the indexes on it.

[Roshan]

Thanks a lot! The reports for Create Accounting are now complete.