My Oracle Support Banner

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

Last updated on SEPTEMBER 18, 2018

Applies to:

Oracle Service Contracts - Version 11.5.10 and later
Information in this document applies to any platform.
OKS_BILLING_MAIN module: Service Contracts Main Billing

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.
3. Run the Service Contracts Main Billing program.
4. The 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

To view full details, 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 a vibrant support community of peers and Oracle experts.