Transactions Workbench Error: After Entering Bill To Information For A Balance Forward Billing Enabled Customer, Get Error Message: ORA-01843 Not a Valid Month (Doc ID 1072914.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions


Symptoms

When creating a transaction for a customer that is Balance Forward Billing enabled, after you enter the customer bill-to information the following error is raised:
ERROR
-----------------------
SREC STATUS :INSERTCONTXT-SREP-NAME :BILL-CUST-NAME :TARMAC LTD
-------------------------------------------------------------------------------------------------
ORA-01843: not a valid month
ORA-06512: at APPS.AR_BFB_UTILS_PVT, LINE 136
-------------------------------------------------------------------------------------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01843

 
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Transactions > Transactions

  1. Open Transactions workbench. Enter header information and customer information for a customer record that is balance forward billing enabled and whose default payment term is a balance forward billing term.
  2. After entering bill-to information, the error above is raised



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