My Oracle Support Banner

The Billing Control Hard Limit Must Be Between 0 And The Contract Line Amount (Doc ID 2450657.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.18.02.0 to 11.13.19.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, File Import/Export

Users have encountered an error when loading billing controls for Enterprise Contracts.
""
Error: The billing control hard limit must be between 0 and the contract line amount. (PJB-2190074)""

They have checked the soft and hard limit in the load file, they have the same amount from the contract line.
Based on their investigation, after loading to interface table (PJB_BILLING_CONTROLS_INT) the amount was rounded off that's why the error encountered.

Example:
Soft and Hard Limit amount in the load file = 579.19
Soft and Hard Limit amount in interface table = 579.2
 

ERROR
-----------------------

Error: The billing control hard limit must be between 0 and the contract line amount. (PJB-2190074)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Manage file import activities>
Contracts import


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the contracts due to that error.

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
References


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