Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

Latest Updated Posts
JDE TECHNICAL 2020-01-27 21:52:46

FAQ - Frequently Asked Questions on Table Conversion (TC) in JDE E1 2020-01-10 09:50:09

What is MVC Architecture? 2020-01-08 03:26:12

Power Forms in JDE E1 2019-12-29 12:59:17

Difference Between EDI Process and Z files 2019-12-10 11:32:31

test 2019-07-06 14:18:19


Page Visits:-425345 (Since:-January-2014)
Loading

Oracle JD Edwards EnterpriseOne Main Topic Category

JDE Forum Comments/Reviews/Query
1462 day(s) ago   #227
Name: Admin
Category: Technical
Location: Singapore
Date: 2016-07-07 08:40:21
Replies(2)

Status: 

Like to Join

Follow the "Sign Up" link to register.

Thanks
1484 day(s) ago   #224
Name: Nick
Category: Technical
Location: Singapore
Date: 2016-06-15 20:46:38
Replies(0)

Status: 

SQL to Compare Records in two Different Environments for a Table

We found it very handy in finding records for a table that are available in one environment but not in a different environment using EXCEPT clause.

SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

It can also be used to do the insert of those records that are missing by adding an INSERT INTO statement.

INSERT INTO [JDE_PRODUCTION].PRODCTL.F951000
SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

Note that MINUS clause can also be used as alternative to EXCEPT.
1552 day(s) ago   #223
Name: Nick
Category: Technical
Location: India
Date: 2016-04-08 02:20:54
Replies(0)

Status: 

Error Codes Encountered while OMW Project Transfer

At times during OMW transfer we get various errors and ever wanted to know what that pesky OMW transfer error message code meant, here is the list of errors and tis description in some meaningful text.

To access the error from OMW, select the project, then the logging exit in OMW, then choose the "Transfer" entry and drill down to the object error messages.

Remember, if you get 47 your data sources are not set up in the release / data source map (fix with GH9011 -> environments menu).

0 ⇢ Transaction was successful
1 ⇢ General error
2 ⇢ Transaction not supported
3 ⇢ SAR integration has been disabled
4 ⇢ Object already present in project
5 ⇢ Object not present in project
6 ⇢ User already in project
7 ⇢ User is not in project
8 ⇢ Attempting to add invalid object to project
9 ⇢ Attempting an unauthorized action
10 ⇢ Status activity rule is inactive
11 ⇢ Transfer Activity Rule is inactive
12 ⇢ Project name is user ID
13 ⇢ Project already exists
14 ⇢ Bad handle
15 ⇢ Could not initialize user
16 ⇢ Memory errors occurred
17 ⇢ Object creation errors occurred
18 ⇢ Invalid SAR number entered
19 ⇢ Can not create default project
20 ⇢ User canceled
21 ⇢ Project is non-existent
22 ⇢ Can not rename project
23 ⇢ Invalid status change attempted
24 ⇢ Invalid string entered
25 ⇢ Invalid type entered
26 ⇢ A required field is blank
27 ⇢ Invalid user id entered
28 ⇢ TAM errors have occurred
29 ⇢ RDB errors have occurred
30 ⇢ Parameter specified does not exist
31 ⇢ Token is available
32 ⇢ Token is not available
33 ⇢ Transfer rolled back per previous call
34 ⇢ Transfer failed to commit to rollback
35 ⇢ Transfer success reference decremented
36 ⇢ Transfer success commit rollback
37 ⇢ JITI fialed
38 ⇢ Start form dynamic failed
39 ⇢ Entry point not found
40 ⇢ Not licensed to access object
41 ⇢ Deadlock has occurred
42 ⇢ Object is currently checked out
43 ⇢ Object has already been transferred
44 ⇢ Locked by vocab overrides
45 ⇢ Not authorized to install
46 ⇢ TSE not authorized
47 ⇢ Transfer not compatible
48 ⇢ Column prefix is invalid
49 ⇢ Copy errors
50 ⇢ Invalid action for project type
51 ⇢ Project is at an invalid status
52 ⇢ Invalid object ID, project ID is a duplicate
53 ⇢ Invalid object ID, project ID is too long
54 ⇢ Invalid object ID, contains invalid characters
55 ⇢ Errors occurred while cleaning up specs
56 ⇢ Object does not exist
57 ⇢ Unknown object Librarian or Version data source
58 ⇢ Could not initialize processing option data
59 ⇢ User security is not authorized
60 ⇢ Notification system is disabled
61 ⇢ SAR creation error
62 ⇢ Save location specified is not found
63 ⇢ No object to restore from
64 ⇢ There is another object in save location
65 ⇢ BSFN library in use
66 ⇢ Project already exists for SAR number specifed
67 ⇢ Role already assigned
68 ⇢ Can not remove user from SAR
69 ⇢ Token is inherited
70 ⇢ Linked project is at an inconsistent status
71 ⇢ Object already exists in an open project
72 ⇢ Object has not been checked out
73 ⇢ SAR status change error
74 ⇢ Inheritance status change error
75 ⇢ No Transfer Activity Rules exist for object
76 ⇢ Log Failure
77 ⇢ Objects are checked out
78 ⇢ Specified object is not checked out to this machine
79 ⇢ Objects are in token queue
80 ⇢ Source file does not exist
81 ⇢ Bad Transfer Activity Rule
82 ⇢ Queued for deletion
83 ⇢ Object marked for deletion
84 ⇢ Object has not been modified
85 ⇢ Mandatory rule exists
86 ⇢ Transfer Limitation exists
87 ⇢ Transfer Exception exists
88 ⇢ Attempting to transfer Version before Template
89 ⇢ Path Code release and SAR release incompatible
90 ⇢ Web Only Version Successful
91 ⇢ Invalid operation performed on Web Only Version
92 ⇢ Token not available for Web Only Version

Courtsy - shannoncncjdeblog
1555 day(s) ago   #222
Name: Teo
Category: CNC
Location: Singapore
Date: 2016-04-05 22:48:30
Replies(0)

Status: 

How to Drop and Restore Indices for EnterpriseOne Tables Using P95150

The P95150 (Index Selection Tool) application displays the table indexes in a tree structure and allows to flag the indexes that we wish to drop. We can drop single or multiple indexes at a time. P95150 only allows to drop indexes that are not unique or primary to the table. As Dropping these types of indexes would disrupt the integrity of the table.

Please refer to Doc ID 1114664.1 for more details.
Oracle docs also provides detailed documentation about Dropping Indexes from a Table.

Cheers!
1581 day(s) ago   #221
Name: Admin
Category: JDENews
Location: Singapore
Date: 2016-03-10 19:38:34
Replies(0)

Status: 

JD Edwards EnterpriseOne within Oracle Infrastructure as a Service on the Oracle Public Cloud

JD Edwards EnterpriseOne within Oracle Infrastructure as a Service

JD Edwards EnterpriseOne continues to lower the Total Cost of Ownership (TCO) with simple provisioning of JD Edwards EnterpriseOne in Oracle Infrastructure as a Service (IaaS). The JD Edwards EnterpriseOne Trial Edition all-in-one image with demo data enables customers to explore new functionality in JD Edwards EnterpriseOne Application Release 9.2, such as new industry modules, One View Financial Statements, Internet of Things Orchestrator, as well as mobile and user experience, without installing JD Edwards EnterpriseOne in their data centers.

Alternatively, customers on JD Edwards EnterpriseOne Application Release 9.1 can easily provision Development/Test environments in Oracle IaaS. This solution in combination with the Migration Tool kit provided by Oracle allows customers to easily move their development and test data, customizations, and patch level from their on-premise instances to Oracle IaaS. In addition, customers can leverage Oracle Database as a Service (DBaaS) for the JD Edwards database layer. The combination of IaaS and DBaaS enables customers to quickly provision new instances of JD Edwards, resulting in reduced administration cost and increased agility.

Both the JD Edwards EnterpriseOne Trial Edition and the Development/Test environments are updated on a periodic basis to ensure that customers always have access to the most current JD Edwards EnterpriseOne capabilities.

The Oracle Compute Cloud Service offers self-service provisioning of network, compute, and storage resources, tested with JD Edwards EnterpriseOne applications. Subscription-based pricing, predictable performance from an optimized hardware infrastructure, and highly secure data center operations provide JD Edwards customers with a trusted IaaS solution. This IaaS solution eliminates capital expenditures for hardware, releases internal resources to focus on initiatives that provide competitive advantage, and enhances the operational agility which creates business transformation.

This new solution enables companies to innovate in the digital economy with enhanced platform choices and deployment options to run their business their way.

Refer to detailed link here.

(Date Published - January 28, 2016)
1594 day(s) ago   #220
Name: Nick
Category: Technical
Location: India
Date: 2016-02-26 01:10:42
Replies(0)

Status: 

SQL Used to Compare Records in Tables From Different Environments

Following SQL script is very handy in finding records that are in one table but not in the same table in a different environment.

SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

Script can also be utilized to do the insert of those records that are missing by adding an INSERT INTO statement.

INSERT INTO [JDE_PRODUCTION].PRODCTL.F951000
SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

1605 day(s) ago   #217
Name: Nick
Category: Technical
Location: Singapore
Date: 2016-02-15 19:44:25
Replies(0)

Status: 

XML vs JSON: Which is better for JD Edwards Integration?

In the debate between JSON vs. XML the arguments usually run one of two directions.

The JSON proponents argue that JSON is a superior data interchange format because it is lightweight allowing for superior performance. The XML proponents argue that it is strongly typed allowing for superior transactional reliability. Both are right. So choosing the data exchange protocol that works best for your situation may depend on a number of factors.

Ask yourself these questions when considering a data interchange format:

What volume of raw data will I need to deal with? Do you need enterprise scale or web scale? Extremely large volumes of repetitively formatted data lends itself well to JSON formatting and can be handled more easily because of JSONs low overhead. XML may be sufficient for typical enterprise scale projects but may slow down significantly at scale.

How complex are the data structures you need to exchange? JSON likes predictable array structures for data. Field1, field 2, field 3, … in row after row of data. JSON is not well suited, however, to complex nested formats and data structures that are not based on arrays. Complex xml structures are common, however, and may be best suited to many requirements.

Do you need to conform to strongly typed data structures? XML is much better suited to strong data types. JSON should be avoided if transactional integrity is at risk.

JSON.org describes JSON by saying that: “JSON has a much smaller grammar and maps more directly onto the data structures used in modern programming languages.” While this may be true, it is also true that some IDEs support programming using either JSON or XML. With integration platforms, the same may be true.

One improvement in the new Magic xpi 4.5 will be the incorporation of native JSON structures in the data mapper. This gives your projects the advantages of JSON`s lightweight nature. In previous versions, JSON was supported, but the data mapper was essentially converting it to xml before doing its mappings. While this accomplished the integration task, it did not leverage the full speed of JSON.

So that`s good news for JD Edwards integration requirements where large scale data interchange and transformation is expected. This strikes me as good news for JD Edwards users all around.

Page:[First] |[<<] | 4 5 6 7 8 9 10 11 ...[>>]
Post Comments/Queries
Role:*
Subject:*
Email:*
Name:*
Details:*
 
   
* Please keep the forum clean.  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
Related
JDE List JDE Source    JDE Upgrade JDE Fusion     The CNC Guy     Itz about ERP JDE Dev JDE Tech
E1 Tips & Tricks JDE CNC JDE Tips IT Toolbox JDE Tech Tips JDE ERP JDE Advisor JDE Wikipedia
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in