My Oracle Support Banner

Create Multiperiod Accounting Is Failing For Dec-2018 - Cannot update NEXT_GL_EFF_PERIOD_NUM to NULL (Doc ID 2484845.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Create Multiperiod Accounting in Final Mode the following error occurs. (There is no error in draft mode, and previous month worked without issue)

INVPO2018/357 is created and draft multiperiod accounting was run for the month of DEC-18 without issues, however when Create Multiperiod Accounting is run in Final mode, the program end with "error".

The CMA log shows the following

>> xlampa_update_history() 06-DEC-2018 15:54:59
XLA_AP_FATAL_SQL_ERROR! Module: xlampa_update_history, Statement: Call xla_fsn_mpa_accounting_pkg.postprocess_entries, Oracle error: ORA-01407: cannot update ("FUSION"."XLA_MPA_DISTRIBUTIONS"."NEXT_GL_EFF_PERIOD_NUM") to NULL
ORA-06512: at "FUSION.XLA_FSN_MPA_ACCOUNTING_PKG", line 3310
ORA-06512: at line 1

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
Cause
Solution


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