My Oracle Support Banner

Receivables - Miscellaneous Receipts Real Time Return Blank Receipt Accounted Amount If Using Ledger Name (Doc ID 2762657.1)

Last updated on APRIL 11, 2021

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

When using Receivables - Miscellaneous Receipts Real Time, the Receipt Accounted Amount is showing blank afer adding the Ledger Name.

Logical Query Example
==================
SELECT
   0 s_0,
   "Receivables - Miscellaneous Receipts Real Time"."- GL Account"."Account Code Combination Identifier" s_1,
   "Receivables - Miscellaneous Receipts Real Time"."- GL Account"."Concatenated Segments" s_2,
   "Receivables - Miscellaneous Receipts Real Time"."- GL Accounting Date"."Accounting Date" s_3,
   "Receivables - Miscellaneous Receipts Real Time"."- GL Overridden Account"."Overridden Account Code Combination Identifier" s_4,
   "Receivables - Miscellaneous Receipts Real Time"."- GL Overridden Account"."Overridden Account Concatenated Segments" s_5,
   "Receivables - Miscellaneous Receipts Real Time"."- Subledger Accounting Journals Details"."Ledger Name" s_6,
   "Receivables - Miscellaneous Receipts Real Time"."Business Unit"."Business Unit Name" s_7,
   "Receivables - Miscellaneous Receipts Real Time"."Miscellaneous Receipts Details"."Receipt ID" s_8,
   "Receivables - Miscellaneous Receipts Real Time"."Miscellaneous Receipts Details"."Receipt Number" s_9,
   DESCRIPTOR_IDOF("Receivables - Miscellaneous Receipts Real Time"."Business Unit"."Business Unit Name") s_10,
   "Receivables - Miscellaneous Receipts Real Time"."- Miscellaneous Receipt Accounting"."Accounted Amount CR" s_11,
   "Receivables - Miscellaneous Receipts Real Time"."- Miscellaneous Receipt Accounting"."Accounted Amount DR" s_12,
   "Receivables - Miscellaneous Receipts Real Time"."Miscellaneous Receipts"."Receipt Accounted Amount" s_13,
   "Receivables - Miscellaneous Receipts Real Time"."Miscellaneous Receipts"."Receipt Entered Amount" s_14
FROM "Receivables - Miscellaneous Receipts Real Time"

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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