E1: TDA: Unable to Save Union ALL Business View Involving Large Tables
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.
When trying to save Union ALL business view involving large tables, it ends with below on-screen error:
"Failed to save business view specifications. Check jde.log for details."
Steps to replicate:
- Create a copy of table F4211, call it as F554211.
- Create a new business view by clicking Add button in Object Management Workbench.
- Go into the business view design and try to create a union all business view using F4211 (Primary table), F42119 and F554211 (created in step 1). Select all columns from primary table F4211.
- Once done, click on save button and below error message appears.
Jde log shows below messages:
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