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 laterInformation 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 |