Federal or Multifunding: Accounting Program Report Fails to Account Invoices With Rules

(Doc ID 1311999.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle Receivables - Version: 12.0.6 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms

Create Accounting fails to account invoices with rules, output file shows:

The subledger journal entry does not balance in the entered currency

Sample diagnostic output
shows the data is balanced in Receivables core tables.
Table xla_ae_lines shows the following:

class_code        entered_dr    entered_cr
FV_REC_CR                          177
FV_REC_DR       177
REVENUE                              177
UNBILLED             0

So as you can see the data is not balanced in XLA.

Sample Debug log file shows:

after error count = 0
END of procedure validation
BEGIN of function balance_single_entered_curr
BEGIN of function GETVALUECHAR
p_source_code = XLA_ROUNDING_RULE_CODE
p_target_ledger_id = 2021
BEGIN of function IS_SOURCE_VALID
p_source_code = XLA_ROUNDING_RULE_CODE
p_datatype = C
return value = TRUE
END of function IS_SOURCE_VALID
return value. = NEAREST
END of function GETVALUECHAR
LOOP - check error for single entered currency: ae_header_id = 419000
BEGIN of procedure BUILD_MESSAGE
p_appli_s_name = XLA
p_msg_name = XLA_AP_UNBAL_ENTED_AMT
p_entity_id = 268360
p_event_id = 288439
p_ledger_id = 2021
p_ae_header_id = 419000
p_ae_line_num =
p_accounting_batch_id =
BEGIN of procedure STACK_ERROR
p_appli_s_name = XLA
p_msg_name = XLA_AP_UNBAL_ENTED_AMT
p_entity_id = 268360
p_event_id = 288439
p_ledger_id = 2021
p_ae_header_id = 419000
p_ae_line_num =
p_accounting_batch_id =
l_msg_number = 0

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms