R12: PA: After RUP18 Patch, PRC: Create Accounting Request Completes With Warning (Doc ID 3060440.1)

Last updated on NOVEMBER 22, 2024

Applies to:

Symptoms

After RUP18 Patch, PRC: Create Accounting request completes with warning.

FND Debug Log of the execution of the concurrent "PRC: Create Accounting", shows the following:

MODULE                                                  MESSAGE
------------------------------------------------------- -------------------------------------------------------------------------------------------------
...
...
fnd.form.FNDRSRUN.modal_toolbar.event                   Enter procedure, event=WHEN-NEW-ITEM-INSTANCE
xla.plsql.xla_accounting_pkg.unit_processor             l_array_events.COUNT = 2382
xla.plsql.xla_security_policy_pkg.MO_Policy              MO_Policy.Begin
xla.plsql.xla_security_policy_pkg.MO_Policy             "l_mo_policy after calling  mo_global.org_security = EXISTS (SELECT  /*+ no_unnest */ 1 --bug 13891445
                                                          FROM mo_glob_org_access_tmp oa WHERE oa.organization_id = org_id)"
xla.plsql.xla_security_policy_pkg.MO_Policy             MO_Policy.End
xla.plsql.xla_accounting_pkg.unit_processor             l_event_insert_count = 2382
xla.plsql.xla_accounting_pkg.unit_processor             l_event_insert_count = 0
xla.plsql.xla_accounting_pkg.unit_processor             Number of events in XLA_EVENTS_GT = 2382
xla.plsql.xla_accounting_pkg.delete_request_je          BEGIN of procedure DELETE_REQUEST_JE
xla.plsql.xla_accounting_pkg.delete_request_je          Number of errors deleted = 3149
xla.plsql.xla_accounting_pkg.delete_request_je          Number of distribution links deleted = 19056
xla.plsql.xla_accounting_pkg.delete_request_je          Number of segment values deleted = 14292
xla.plsql.xla_accounting_pkg.delete_request_je          Number of line acs deleted = 0
xla.plsql.xla_accounting_pkg.delete_request_je          Number of header acs deleted = 0
xla.plsql.xla_accounting_pkg.delete_request_je          Number of ae lines deleted = 19056
xla.plsql.xla_accounting_pkg.delete_request_je          Number of ae headers deleted = 4764
xla.plsql.xla_accounting_pkg.delete_request_je          END of procedure DELETE_REQUEST_JE
fnd.plsql.fnd_file.PUT_LINE                             sid:231333201: 09-SEP-2024 10:42:50 - executing extract hook
xla.plsql.xla_accounting_pkg.handle_accounting_hook     BEGIN of procedure handle_accounting_hook
xla.plsql.xla_accounting_pkg.handle_accounting_hook     Warning: Product is not integrated using APIs 
xla.plsql.xla_accounting_pkg.raise_unit_event           BEGIN of procedure RAISE_UNIT_EVENT
xla.plsql.xla_accounting_pkg.raise_unit_event           p_application_id = 275
xla.plsql.xla_accounting_pkg.raise_unit_event           p_accounting_mode = F
xla.plsql.xla_accounting_pkg.raise_unit_event           p_event_name = extract
  ...
  ...
fnd.form.FNDRSRUN.modal_toolbar.event                   Enter procedure, event=WHEN-NEW-ITEM-INSTANCE
xla.plsql.xla_accounting_pkg.wait_for_requests          request completed with status = Warning 
xla.plsql.xla_accounting_pkg.wait_for_requests          END of procedure WAIT_FOR_REQUESTS
fnd.plsql.fnd_file.PUT_LINE                             sid:231333199: 09-SEP-2024 10:51:23 -  Child Threads completed
xla.plsql.xla_accounting_pkg.post_accounting            BEGIN of procedure POST_ACCOUNTING
xla.plsql.xla_accounting_err_pkg.get_total_error_count  BEGIN of function GET_TOTAL_ERROR_COUNT
xla.plsql.xla_accounting_err_pkg.get_total_error_count  RETURN value l_total_error_count = 3149
xla.plsql.xla_accounting_err_pkg.get_total_error_count  END of function GET_TOTAL_ERROR_COUNT
xla.plsql.xla_accounting_pkg.post_accounting            g_total_error_count = 3149
xla.plsql.xla_accounting_pkg.post_accounting            Global Context cleared
  ...
  ...
xla.plsql.xla_accounting_pkg.batch_accounting           END of procedure BATCH_ACCOUNTING
xla.plsql.xla_accounting_pkg.event_application_manager  Accounting process completed
fnd.plsql.fnd_file.PUT_LINE                             sid:231333199: 09-SEP-2024 10:51:23 - executing postaccounting hook
xla.plsql.xla_accounting_pkg.handle_accounting_hook     BEGIN of procedure handle_accounting_hook
xla.plsql.xla_accounting_pkg.handle_accounting_hook     Warning: Product is not integrated using APIs 
xla.plsql.xla_accounting_pkg.raise_accounting_event     BEGIN of procedure RAISE_ACCOUNTING_EVENT
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_application_id = 275
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_ledger_id = 2021
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_process_category = 
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_end_date = 09-SEP-24
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_accounting_mode = F
xla.plsql.xla_accounting_pkg.raise_accounting_event     p_valuation_method = 
  ...
  ...
xla.plsql.xla_accounting_pkg.handle_accounting_hook     END of procedure handle_accounting_hooks
fnd.plsql.fnd_file.PUT_LINE                             sid:231333199: 09-SEP-2024 10:51:23 - postaccounting hook executed successfully
fnd.plsql.fnd_file.PUT_LINE                             sid:231333199: - Accounting Time = 516.68 secs
fnd.plsql.fnd_file.PUT_LINE                             sid:231333199: - Transfer Time   = 0 secs
xla.plsql.xla_accounting_pkg.event_application_manager  COMMIT issued in the procedure EVENT_APPLICATION_MANAGER
xla.plsql.xla_accounting_pkg.event_application_manager  END of procedure EVENT_APPLICATION_MANAGER
xla.plsql.xla_accounting_pkg.accounting_program_batch   g_mpa_accrual_exists= N
xla.plsql.xla_accounting_err_pkg.insert_errors          BEGIN of procedure INSERT_ERRORS
xla.plsql.xla_accounting_err_pkg.insert_errors          Count of Error Messages in the stack = 0
xla.plsql.xla_accounting_err_pkg.reset                  BEGIN of procedure RESET
xla.plsql.xla_accounting_err_pkg.reset                  END of procedure RESET
xla.plsql.xla_accounting_err_pkg.insert_errors          END of procedure INSERT_ERRORS
xla.plsql.xla_accounting_pkg.accounting_program_batch   g_error_status = 
xla.plsql.xla_accounting_pkg.accounting_program_batch   g_warning_status = Y
xla.plsql.xla_accounting_pkg.accounting_program_batch   g_total_error_count = 3149
xla.plsql.xla_accounting_pkg.accounting_program_batch   p_retcode = 1
xla.plsql.xla_accounting_pkg.accounting_program_batch   p_errbuf = Accouting Report ended in Warning because one of the Parent Accounting Program ended in Warning 
xla.plsql.xla_accounting_pkg.accounting_program_batch     END of procedure ACCOUNTING_PROGRAM_BATCH
xla.plsql.xla_accounting_pub_pkg.accounting_program_batch END of procedure ACCOUNTING_PROGRAM_BATCH
xla.plsql.XLA_CREATE_ACCT_RPT_PVT                         l_accounting_batch_id = 2284068
xla.plsql.XLA_CREATE_ACCT_RPT_PVT                         l_errbuf = Accouting Report ended in Warning because one of the Parent Accounting Program ended in Warning 
xla.plsql.XLA_CREATE_ACCT_RPT_PVT                         C_ACCT_PROG_RETURN_CODE = 1
  ...
  ...

Notice in the highlighted lines, the original message "Warning: Product is not integrated using APIs" causing the concurrent to complete in Warning status.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.