My Oracle Support Banner

E1: 75T: Change the Business View V75T03B11B(GUI/VAT Transaction - A/R Review) to Fetch from Table F75T005 (Doc ID 2616053.1)

Last updated on DECEMBER 17, 2019

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In the Current design of Business View V75T03B11B(GUI/VAT Transaction - A/R Review)there is a SQL 92 Left Outer Join between the following Tables:

Primary Table --- F03B11(Customer Ledger)

Secondary Table -- F75T004(GUI/VAT Transaction Header)

Because of the above when a Row security is set for Company(CO) Data is not fetched in the Grid of Form P75T004UW75T004UF.

Design of Business View V75T03B11B(GUI/VAT Transaction - A/R Review) should be changed such that Secondary Table is F75T005(GUI/VAT Transaction Detail.

It should follow the design of the Business View V75T0411B.

By the above change data will be fetched although there is a row security set on Company(CO)

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.