The Service Contract Main Billing Program Fails with 'Insert Failed IN ARFEEDER...' Error (Doc ID 2198283.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to run the "Service Contract Main Billing" program, it fails and the following error can be seen in the log file.

Error
OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit
OKS_ARFEEDER_PUB.Sales_credit =>Line level RA_Interface_SalesCredit
OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT
OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT100
OKS_ARFEEDER_PUB.insert_ra_interface_sc => Exception in insert into RA_INTERFACE_SALESCREDITS SQLCODE = -6502 SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For128134204838936098758220632190668816547
OKS_ARFEEDER_PUB.Sales_credit =>Line level RA_Interface_SalesCredit
OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED128134204838950605868056007740765290659
OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED User-Defined Exception

Steps
1. Run the 'Service Contracts Main Billing' program.
2. See it failed.
3. Review the log file and see the indicated error.

Cause

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