Service Contracts Main Billing Program Completes With Warning For Contracts with Payment Type Credit Card (Doc ID 1078684.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Service Contracts - Version 12.0 and later
Information in this document applies to any platform.
OKS_BILLING_MAIN module: Service Contracts Main Billing
***Checked for relevance 14-Nov-2013***

Symptoms

Service Contracts Main Billing Program ends with Warning while using Credit card as the payment type.

Steps to reproduce:
1. Create a contract and enter Credit card as the payment type.
2. Activate the contract and run billing program.
- The billing program ends with a warning and does not process billing.

Error from the Service Contracts Main Billing log file :

OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method is CCR
OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is 0
OKS_ARFEEDER_PUB.Get_REC_FEEDER => Enter a Value for the Profile, OKS: Payment Method for AR Interface
OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED User-Defined Exception
OKS_ARFEEDER_PUB.debug report1
OKS_BILLING_PUB.Calculate_bill => Failed- when others exception raised in Mainline loop ORA-06502: PL/SQL: numeric or value error
OKS_BILLING_PUB.Calculate_bill processing Ends
OKS_BILLING_PUB.Billing_Main => After Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run
Billing Main is successfully completed with warnings
OKS_BILLING_PUB.Billing_Main Ends

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms