Running Service Contract Main Billing Program: Exception In Insert Into RA_INTERFACE_SALESCREDITS (Doc ID 2198283.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run "Service Contract Main Billing" program, the following error occurs.

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

The issue can be reproduced at will with the following steps:
1. AR Super User responsibility
2 Navigate to Requests form
3. Run 'Service Contracts Main Billing' program.

Changes

  

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