My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2024

Applies to:

Oracle Project Costing - Version 12.2.9 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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