Receipts Workbench Error:When Applying a Receipt to a Transaction, Error is Raised: APP-JL-62068 The Profile JLBR Interest Debit Memo Transaction Type cannot be blank (Doc ID 444683.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Receivables - Version 11.5.6 to 11.5.10.3 [Release 11.5.6 to 11.5.10]
Information in this document applies to any platform.
FORM:ARXRWMAI.FMB - Receipts


Symptoms

Get following error when applying a receipt:

APP-JL-62068: The Profile JLBR Interest Debit Memo Transaction Type cannot be blank.

You have confirmed have following Descriptive Flexfields are setup correctly:

JG_AR_SYSTEM_PARAMETERS:

a) Number: 16
Name: BATCH_IDM (Required: Yes)
Prompt: Batch Source IDM
Column: GLOBAL_ATTRIBUTE16
Value Set: JLBR_AR_BATCH_IDM
Displayed: Yes
Enabled: Yes
Description: Batch Source to create Interest Debit Memo
LOV Prompt: Batch Source


b) Number: 17
Name: TRX_TYPE_IDM (Required: Yes)
Description: Transaction Type to create Interest Debit Memo
Prompt: Transaction Type IDM
Column: GLOBAL_ATTRIBUTE17
Value Set: JLBR_AR_TRXTYPE_IDM
Displayed: Yes
Enabled: Yes
LOV Prompt: Transaction Type IDM


c) Number: 18
Name: RECEIPT_MET_IDM (Required: Yes)
Description: Receipt Method used to create Interest Debit Memo
Prompt: Receipt Method IDM
Column: GLOBAL_ATTRIBUTE18
Value Set: JLBR_AR_RCPTMET_IDM
Displayed: Yes
Enabled: Yes
LOV Prompt: Receipt Method

The definition for those Value Sets use above are:


Value Set Name: JLBR_AR_BATCH_IDM
Description: Batch Source used to create Interest Debit Memo
Format Type: Char
Maximum Size: 50
Validation Type: Table
Table Application: Oracle Receivables
Table Name: RA_BATCH_SOURCES_ALL
Table Columns: Value = NAME; Meaning= NULL;ID= BATCH_SOURCE_ID
Where/Order By: where batch_source_type='INV' AND ORG_ID = :$PROFILES$.ORG_ID order by name

Value Set Name: JLBR_AR_TRXTYPE_IDM
Description: Transaction Type used to create Interest Debit Memo
Format Type: Char
Maximum Size: 20
Validation Type: Table
Table Application: Oracle Receivables
Table Name: RA_CUST_TRX_TYPES_ALL
Table Columns: Value= Name; Meaning=Null; ID= CUST_TRX_TYPE_ID
Where/Order By = where type = 'DM' AND ORG_ID = :$PROFILES$.ORG_ID order by name

Value Set Name: JLBR_AR_RCPTMET_IDM
Description: Receipt Method to create Interest Debit Memo
Format Type: Char
Maximum Size: 30
Validation Type: Table
Table Application: Oracle Receivables
Table Name: AR_RECEIPT_METHODS
Table Columns: Value= NAME; Meaning= NULL; ID= RECEIPT_METHOD_ID
Where/Order By: where receipt_class_id in (select receipt_class_id from ar_receipt_classes where global_attribute1='MANUAL_RECEIPT') order by name

Changes

None

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