E1: 53: Need a Solution for Bug 32557193 for Passing Negative Numbers to Contract Service Billing (Doc ID 2869657.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

When using a Revenue Account along with Contract Billing and using processing option # 3 on the Contract Commit Tab of the P5310 and a "Positive Number" is entered it updates the F5202 - Contract Billing Line Detail as a positive number.

Based on prior functionality if using both Contract Billing and Job Cost the following apply:

Processing option #3 on the Contract Commit tab of the P5310 determines how the change request revenue amount should be committed to Contract Billing.

Valid values are:
Blank: Use the change request revenue amount. If using only the Contract Billing module, user must enter a positive revenue amount on the change request which will be processed as a positive amount in the Schedule of Values on the Contract (P5202).
1 : Reverse the sign of the change request revenue amount. If using both the Contract Billing module and the Job Cost module, user is allowed to enter negative or positive revenue amounts. Negative revenue amounts will increase the Job Cost revenue budget amounts and positive revenue amounts will decrease the Job Cost revenue budget.

The Contract Commit will reverse the sign of the change request revenue amount and only allow positive values to be committed to the Schedule of Values on the Contract in Contract Billing.  Negative amounts (credits) on the contract must be processed through the Contract Billing module.

If trying to post a Negative amount (credits ) to the contract it must be processed through Contract Billing Module as the Change Management System doesn't handle them.

Processing Option that addresses this:
3. Revenue Values
Blank = Pass revenue values as entered.  Negative values are not allowed.
1 = Reverse sign on revenue values

There might be two viable options to resolve this issue......
1. Allow the commit through Change Management, (reverse the value)
2. Restrict posting of deduct Change Orders to Contract Billing. ( prior functionality)
3. Modify the software so it can handles this and pass the correct amount to Contract Service Billing.  (This was the option taken by Development, Job Cost, and Contract Service Billing)

Steps:
The issue can be reproduced at will with the following steps:
1. Create a Job: (P51006) Job Cost Master
2. Create some Accounts: (P510121)
3. Enter a two contracts: See Power Point on how to complete this.
4. Contracts: See Power Point on how to complete this.
5. Enter two Revenue Detail lines:P5310-First one is positive
6. Enter second one Revenue Detail lines:P5310-Second one Negative:
7. Review the F0902
8. Revenue Detail Commit to Contract Billing from within the Change Request-positive amount-NO ERROR MESSAGE (See Power Point on how to complete this)
9. Revenue Detail Commit to Contract Billing from within the Change Request-negative amount-Goes thru correctly (See Power Point on how to complete this)
10. Change Management:
11. Review F5202 File:

Information is getting passed to Contract Billing incorrectly. Both positive and negative number are being passed as positive.

Cause

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