JD Edwards CNC

Q: Up to this point, what has Oracle announced about JD Edwards and Oracle Cloud? A: Oracle announced the availability of two different JD Edwards EnterpriseOne offerings through the Oracle Cloud Marketplace. The first is the JD Edwards EnterpriseOne Trial Edition, an “all-in-one” view of a JD Edwards EnterpriseOne system, making it easier to deploy. Built with current Applications and Tools releases, it’s an ideal way to explore the latest features made available by Oracle. The second is a Multi Tier Edition (OCP tool), which includes discrete images for the enterprise server, HTML server, and database server. This edition also has a Server Manager, allowing a system administrator to take control over the deployment configuration. The Multi Tier Edition also has utilities for transitioning customers’ data and custom objects from on-premise to the cloud environment. By leveraging the Trial Edition and the Multi Tier Edition, JD Edwards clients can get a hands-on experien...

If the  package was deleted from the Application P9601 but the directory still exist on the deployment server, this is what can be done in order to restore it: 1. Go to deployment server and rename the correspondent package name directory to a different name (just so it does not wipe it out) 2. Go to the package assembly and recreate it with the initial package name 3. Go to the package definition and also recreate it BUT don't check anything: uncheck all boxes, save and activate it 4. Rename the directory back to the initial package name on the deployment server. 5. Do a submit build . It will see that the directory is there, will ask if you want to delete it and say NO. 6. It will process it and actually, since everything was unchecked, it will not do anything but set the build status to complete/successful courtesy: jdehelp blogspot

 Index Selection Tool     Database administrators drop indexes from tables in a physical database to increase system performance. Instead of using the actual database application to drop table indexes, you can use the Index Selection Tool (P95150).     The advantage of using P95150 to drop indexes is that Oracle's JD Edwards EnterpriseOne keeps track of the indexes that are dropped, even if the indexes have been restored or rebuilt.        For example, during a software update, the system restores indexes to tables that are affected by the update. Typically, after an update, you would have to perform another analysis to determine the indexes that need to be re-dropped. However, JD Edwards EnterpriseOne retains this information so that you can easily find the indexes that were previously dropped, reducing the time it takes to drop the indexes again. Note. P95150 should only be used by system administrators or database administrators. ...

Below are some FAQs on Pathcode, Environments.. Path Code: Question1:  In which format EnterpriseOne Specs get stored for a path code? Answer1:  Prior to 8.12, specs were stored in TAM (Table Access Management) format. In the 8.12 release and later, this metadata is now stored in XML format in an XML schema in the relational database. This change allows all servers to view and match their code up to one central source. Question2:  How to create central objects for custom path code? Answer2:  One can create using either of the two methods: 1-  Using Platform Pack Installation:  Installing the platform pack selecting only the EnterpriseOne DB components. Once done with the platform pack, one need to create F983051 manually and need to update the table with the name of your Deployment server and path code name. 2-  Runing R98403, version XJDE0019. This is automatically copy F983051 and updates the table with the name of your Deployment server and path cod...

JDE EnterpriseOne UBE Runtime Performance Audit: Here`s a SQL script which can be used to evaluate the runtimes of your UBEs. SELECT JCPID as UBE, JCVERS as [Version], ltrim(rtrim(simd)) + `: ` + ltrim(rtrim(vrjd)) as UBE_Name, count(1) as [Count], Avg(datediff(s,jcstdtim,jcetdtim)) AS Avg_Time, min(datediff(s,jcstdtim,jcetdtim)) AS Min_Time, max(datediff(s,jcstdtim,jcetdtim)) AS Max_Time from svm910.f986114,ol910.f9860, [JDE_PD910].pd910.f983051 where ltrim(rtrim(jcpid)) = ltrim(rtrim(siobnm)) and ltrim(rtrim(jcvers)) = ltrim(rtrim(vrvers)) and ltrim(rtrim(jcpid)) = ltrim(rtrim(vrpid)) and JCETDTIM > `01-01-2018` and JCETDTIM < `06-30-2018` group by jcpid, JCVERS, ltrim(rtrim(simd)) + `: ` + ltrim(rtrim(vrjd))  Courtesy-  e1tips

To Check status of OMW Objects using SQLs: List all checked out objects: select * from from ol920.F9861 where SISTCE != '1' order by siuser, siobnm;  select sipathcd , simkey as "Server", SIOBNM, siuser as "User" from ol920.F9861 where SISTCE != '1' order by siuser, siobnm; Versions Checked out: select VRENHV, VRUSER as "User", VRPID as "Object", VRVERS as "Version", VRMKEY as "Machine" from DV920.F983051 where VRCHKOUTSTS='Y' order by vruser, vrpid, vrvers;

RuntimeCache and UBEOverride folders When any UBE is submitted for the first time, the MetaData Kernel will manage the XML-to-platform dependent metadata objects for runtime consumption. This kernel loads a JVM via JNI and TAM cache files will be created and stored in the \ \spec\runtimeCache folders. These persistent cache files will be created for each report when the report is run for the first time and subsequent runs will utilize this cache. This will improves the performance of small and frequently run reports. The folder \ \spec\runtimeCache is used to store the persistent TAM cache files for UBE specs e.g. GBRLINK, GBRSPEC, RDASPEC and RDATEXT. The folder \ \spec\UBEOverride is used to store version override specifications e.g. Data Selection, Data Sequencing overrides. The runtimeCache folder is organized by Report and Version in the following file structure: UBE Persistent cache per report: \ \spec\runtimeCache\R0006P\ GBRLNK GBRSPEC  RDASPEC RDATEXT UBE Persiste...

Manually adding Webdev Feature after the Full Package was built: If you miss to add Web Development Feature into the Package build and built it then here is the steps to add it from Backend. 1.) INSERT INTO SY920.F9631 VALUES('C','WEBDEVOC4J','DVF120120','DV920',' ',' ',' ','1',' ','P9601','DEPSRVR',119031,123027.000000,'JDE') Here Full package - DVF120120 Environment - DV920 Machine - DEPSRVR 2.)  Add following line in end of  E:\JDEdwards\E910\PACKAGE_INF\DVF120120.inf [FEATURE] WEBDEVOC4J=\\DEPSRVR\E920\package_inf\feature_inf\WEBDEVOC4J.INF After this you can install Full package on Fat Client and Web Dev Feature will install.

So far we have discussed about API, SOAP and REST. Let's continue with JSON. What is JSON? -----------------      JSON (java script object notation) is a lightweight data format for data exchange or transfer.  The JSON format is syntactically identical to the code for creating JavaScript objects.      Because of this similarity, a JavaScript program can easily convert JSON data into native JavaScript objects. JSON is easy to integrate in JavaScript applications, but XML isn't.        This makes JSON a preferred data format with many mobile application developers. In the 'old' days, web services used XML as their primary data format for transmitting back data, but since JSON appeared , it has been the preferred format because it is much more lightweight. The two primary parts that make up JSON are keys and values. Together they make a key/value pair. Key: A key is always a string enclosed in quotation marks. Value: A value can...

Application Interface Services (AIS) - As the name says, it provides interface services to the applications.  JDE and mobile devices are using Java scripts called JSON which stands for JavaScript Object Notation over REST API to communicate with each other. Before going for AIS, let's discuss about API, REST and JSON. What is an API? --------------- API stands for Application Programming Interface. It makes it possible to transfer data from an application to other applications.  An API receives requests and sends back responses through internet protocols such as HTTP, SMTP, and others. SOAP and REST are two API styles that approach the question of data transmission from a different point of view. SOAP ----- SOAP stands for Simple Object Access Protocol. It’s a messaging protocol for interchanging data in a decentralized and distributed environment SOAP can work with any application layer protocol, such as HTTP, SMTP, TCP, or UDP. It returns data to the receiver in XM...