My Oracle Support Banner

OPM Cost Rollup Giving Error "Bill level generation failed"; Log File Shows "ORA-01722: invalid number" (Doc ID 2664878.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Cost Rollup Process

When attempting to run Cost Rollup the process ends in error. The Error Messages shows:

Bill level generation failed. Process aborted.

The log file shows:

Checking for bad effectivity rows.13-MAR-2020 16:44:38
  **** sy_etrap - FATAL_ERROR ****%N%NFunction: gmfsget_badeff%N%NStatement: open%N%NError: ORA-01722: invalid number

  Time: Fri Mar 13 16:44:40 2020

  Error number: -127

 Error message: ORA-01722: invalid number

  Function: gmfsget_badeff

The issue has the following business impact:
Due to this issue, users cannot roll up costs for an operating unit.


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

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