Maximo

Hi All,

I am trying to explore Service Provider modules. I have created a customer agreement with only 1 billing schedule and set it to Monthly with bill date as today i.e 10 nov 2022 and approved it. Customer agreement does not have a price schedule.
I have activated cron tasks. But it is not generating the bill, i have checked in Customer Billing(SP) application, the bill is not generated.
Kindly suggest what step am i missing.

Regards,
Aparna

------------------------------
Aparna S V
------------------------------

#AssetandFacilitiesManagement
#Maximo

Hello Aparna, 
  If you are just exploring this functionality I'll provide a few tips.  1 - Make sure you enabled the When the correct cron task, for bill schedules it's PLUSPBILLGENCRONTASK.  2 - When the cron runs it will evaluate a few things. First it will determine if there are active bill schedules that need to be run.  It basically looks at APPR customer agreements where the next bill date on the bill schedule is = to today or in the past and that do not have an existing customer bill open.  You can check to see if a bill is open by searching the customer billing app for customer agreements +bill schedule that are in status PREBILL, REVIEWED, INPROGRESS,.  If you have these then you can either advance them to a Billed or cancelled status. Next time the cron runs it will create a new bill.

------------------------------
Thomas Knowles
Maximo Product Manager
IBM
704-231-1341
------------------------------

Original Message:
Sent: Thu November 10, 2022 12:12 PM
From: Aparna S V
Subject: Service Provider Modules

Hi All,

I am trying to explore Service Provider modules. I have created a customer agreement with only 1 billing schedule and set it to Monthly with bill date as today i.e 10 nov 2022 and approved it. Customer agreement does not have a price schedule.
I have activated cron tasks. But it is not generating the bill, i have checked in Customer Billing(SP) application, the bill is not generated.
Kindly suggest what step am i missing.

Regards,
Aparna

------------------------------
Aparna S V
------------------------------

#AssetandFacilitiesManagement
#Maximo

Hi Thomas,

Thanks for the reply.
PLUSPBILLGENCRONTASK is active.

Also, I have checked the logs, it is giving unique constraint error as follows:
=================================================================
[PLUSPBILLGENCRONTASK] - saving Sales Orders: start
11 Nov 2022 06:31:57:955 [DEBUG] [MXServer] [CID-CRON-16614] [MAXADMIN] ** [PLUSPBILLGENCRONTASK] - Uh Oh! Something went terribly wrong...
11 Nov 2022 06:31:57:955 [DEBUG] [MXServer] [CID-CRON-16614] [MAXADMIN] ** BMXAA4129E - The record for Site ID=BEDFORD, WO Num=, Unique Id=12 already exists. This validation error is thrown when an attempt is made to insert a new record with a unique key value that already exists in the database. Ensure that the key value for the given record is unique.
===================================================================

As per my understanding it tries to create sales order, but I am not able to get the error message.
Kindly suggest.

Regards,
SV Aparna
IBM | Maximo Consultant | National Grid - Europa
Bangalore
+91 - 9972016373

Upcoming OOO :
9 Dec 2022
26 Dec 2022 - 31 Dec 2022
2 Jan 2023 – 4 Jan 2023


Original Message:
Sent: 11/11/2022 8:16:00 AM
From: Thomas Knowles
Subject: RE: Service Provider Modules

Hello Aparna, 
  If you are just exploring this functionality I'll provide a few tips.  1 - Make sure you enabled the When the correct cron task, for bill schedules it's PLUSPBILLGENCRONTASK.  2 - When the cron runs it will evaluate a few things. First it will determine if there are active bill schedules that need to be run.  It basically looks at APPR customer agreements where the next bill date on the bill schedule is = to today or in the past and that do not have an existing customer bill open.  You can check to see if a bill is open by searching the customer billing app for customer agreements +bill schedule that are in status PREBILL, REVIEWED, INPROGRESS,.  If you have these then you can either advance them to a Billed or cancelled status. Next time the cron runs it will create a new bill.

------------------------------
Thomas Knowles
Maximo Product Manager
IBM
704-231-1341
------------------------------

Original Message:
Sent: Thu November 10, 2022 12:12 PM
From: Aparna S V
Subject: Service Provider Modules

Hi All,

I am trying to explore Service Provider modules. I have created a customer agreement with only 1 billing schedule and set it to Monthly with bill date as today i.e 10 nov 2022 and approved it. Customer agreement does not have a price schedule.
I have activated cron tasks. But it is not generating the bill, i have checked in Customer Billing(SP) application, the bill is not generated.
Kindly suggest what step am i missing.

Regards,
Aparna

------------------------------
Aparna S V
------------------------------

#Maximo
#AssetandFacilitiesManagement

Seems like a data issue in your environment?  Is there an existing sales order with this same id already in table? Can you run the query below?

select * from pluspsalesorder where pluspsalesorderid = 12

Also you can PM me or send me an email to further discuss offline.  We can post back the resolution in this forum once we further troubleshoot.

------------------------------
Thomas Knowles
Maximo Product Manager
IBM
704-231-1341
------------------------------

Original Message:
Sent: Fri November 11, 2022 08:28 AM
From: Aparna S V
Subject: Service Provider Modules

Hi Thomas,

Thanks for the reply.
PLUSPBILLGENCRONTASK is active.

Also, I have checked the logs, it is giving unique constraint error as follows:
=================================================================
[PLUSPBILLGENCRONTASK] - saving Sales Orders: start
11 Nov 2022 06:31:57:955 [DEBUG] [MXServer] [CID-CRON-16614] [MAXADMIN] ** [PLUSPBILLGENCRONTASK] - Uh Oh! Something went terribly wrong...
11 Nov 2022 06:31:57:955 [DEBUG] [MXServer] [CID-CRON-16614] [MAXADMIN] ** BMXAA4129E - The record for Site ID=BEDFORD, WO Num=, Unique Id=12 already exists. This validation error is thrown when an attempt is made to insert a new record with a unique key value that already exists in the database. Ensure that the key value for the given record is unique.
===================================================================

As per my understanding it tries to create sales order, but I am not able to get the error message.
Kindly suggest.

Regards,
SV Aparna
IBM | Maximo Consultant | National Grid - Europa
Bangalore
+91 - 9972016373

Upcoming OOO :
9 Dec 2022
26 Dec 2022 - 31 Dec 2022
2 Jan 2023 – 4 Jan 2023


Original Message:
Sent: 11/11/2022 8:16:00 AM
From: Thomas Knowles
Subject: RE: Service Provider Modules

Hello Aparna, 
  If you are just exploring this functionality I'll provide a few tips.  1 - Make sure you enabled the When the correct cron task, for bill schedules it's PLUSPBILLGENCRONTASK.  2 - When the cron runs it will evaluate a few things. First it will determine if there are active bill schedules that need to be run.  It basically looks at APPR customer agreements where the next bill date on the bill schedule is = to today or in the past and that do not have an existing customer bill open.  You can check to see if a bill is open by searching the customer billing app for customer agreements +bill schedule that are in status PREBILL, REVIEWED, INPROGRESS,.  If you have these then you can either advance them to a Billed or cancelled status. Next time the cron runs it will create a new bill.

------------------------------
Thomas Knowles
Maximo Product Manager
IBM
704-231-1341

Original Message:
Sent: Thu November 10, 2022 12:12 PM
From: Aparna S V
Subject: Service Provider Modules

Hi All,

I am trying to explore Service Provider modules. I have created a customer agreement with only 1 billing schedule and set it to Monthly with bill date as today i.e 10 nov 2022 and approved it. Customer agreement does not have a price schedule.
I have activated cron tasks. But it is not generating the bill, i have checked in Customer Billing(SP) application, the bill is not generated.
Kindly suggest what step am i missing.

Regards,
Aparna

------------------------------
Aparna S V
------------------------------

#AssetandFacilitiesManagement
#Maximo

Service Provider Modules are modular components within a system designed to offer specific services or functionalities. They facilitate extensibility and customization, allowing users to replace or enhance services as needed. Examples include Java Service Provider Interface (SPI) and modular components in web services or software architectures.

------------------------------
Jure Teo
------------------------------

Original Message:
Sent: Thu November 10, 2022 12:12 PM
From: Aparna S V
Subject: Service Provider Modules

Hi All,

I am trying to explore Service Provider modules. I have created a customer agreement with only 1 billing schedule and set it to Monthly with bill date as today i.e 10 nov 2022 and approved it. Customer agreement does not have a price schedule.
I have activated cron tasks. But it is not generating the bill, i have checked in Customer Billing(SP) application, the bill is not generated.
Kindly suggest what step am i missing.

Regards,
Aparna

------------------------------
Aparna S V
------------------------------

#AssetandFacilitiesManagement
#Maximo