R12: AP: Unable to Account Invoices Due to Error Number 95342
(Doc ID 2986745.1)
Last updated on NOVEMBER 13, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.
Symptoms
When attempting to account invoices for a new Operating Unit with concurrent program Create Accounting, the following error occurs:
Error Number: 95342
Error Message: The document sequence category XXXX is invalid. Please enter a valid document sequence category for the application Payables.
Error Message: The document sequence category XXXX is invalid. Please enter a valid document sequence category for the application Payables.
The FND log shows:
xla.plsql.xla_je_validation_pkg.validate_doc_sequence BEGIN of function validate_doc_sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence BEGIN LOOP - invalid doc sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence LOOP invalid headers: ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.build_message BEGIN of procedure BUILD_MESSAGE
xla.plsql.xla_accounting_err_pkg.build_message p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.build_message p_msg_name = XLA_AP_INVALID_DOC_SEQ_CAT
xla.plsql.xla_accounting_err_pkg.build_message p_token_1 = CATEGORY_NAME
xla.plsql.xla_accounting_err_pkg.build_message p_value_1 = XXXX
xla.plsql.xla_accounting_err_pkg.build_message p_token_2 = APPLICATION_NAME
xla.plsql.xla_accounting_err_pkg.build_message p_value_2 = Payables
xla.plsql.xla_accounting_err_pkg.build_message p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.build_message p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.build_message p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.build_message p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.build_message p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.build_message p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error BEGIN of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.stack_error p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.stack_error p_msg_name = XLA_AP_INVALID_DOC_SEQ_CAT
xla.plsql.xla_accounting_err_pkg.stack_error p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.stack_error p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.stack_error p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error l_msg_number = 95342
xla.plsql.xla_accounting_err_pkg.stack_error END of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.build_message END of procedure BUILD_MESSAGE
xla.plsql.xla_je_validation_pkg.validate_doc_sequence END LOOP - invalid doc sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence End of function validate_doc_sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence BEGIN LOOP - invalid doc sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence LOOP invalid headers: ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.build_message BEGIN of procedure BUILD_MESSAGE
xla.plsql.xla_accounting_err_pkg.build_message p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.build_message p_msg_name = XLA_AP_INVALID_DOC_SEQ_CAT
xla.plsql.xla_accounting_err_pkg.build_message p_token_1 = CATEGORY_NAME
xla.plsql.xla_accounting_err_pkg.build_message p_value_1 = XXXX
xla.plsql.xla_accounting_err_pkg.build_message p_token_2 = APPLICATION_NAME
xla.plsql.xla_accounting_err_pkg.build_message p_value_2 = Payables
xla.plsql.xla_accounting_err_pkg.build_message p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.build_message p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.build_message p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.build_message p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.build_message p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.build_message p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error BEGIN of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.stack_error p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.stack_error p_msg_name = XLA_AP_INVALID_DOC_SEQ_CAT
xla.plsql.xla_accounting_err_pkg.stack_error p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.stack_error p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.stack_error p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error l_msg_number = 95342
xla.plsql.xla_accounting_err_pkg.stack_error END of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.build_message END of procedure BUILD_MESSAGE
xla.plsql.xla_je_validation_pkg.validate_doc_sequence END LOOP - invalid doc sequence
xla.plsql.xla_je_validation_pkg.validate_doc_sequence End of function validate_doc_sequence
The issue can be reproduced at will with the following steps:
- Responsibility Payables Manager
- Navigation: Menu > View > Requests > Submit a New Request... > Single Request
- Select from List of Values (LOV) > Create Accounting
- Provide the End Date parameter > [B] Submit > Click on Output
- Notice that invoices are not accounted and reported with the above error
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 |