Customer Login

Login
Lost Password?

JDEdwards CNC Support

Read More...
Oracle CNC - Homepage
Oracle JDE ERP1 CNC Managed Services

jde erp CNC TECHNICAL SUPPORT

On demand JDEdwards CNC System Administration Services

Do you need JDE technical support? Is your CNC Administrator sick, on training  or in vacations. Need some help while your hire a professional CNC?  Do you need on-hand training  for your new CNC Administrator?

We solve your CNC Administrator inmediate needs. Yes, we can assist you! 

We provide helpdesk support to JDEdwards ERP EnterpriseOne for your installation including Oracle and SQLServer  Technical Support is available from one hour to long term projects.

ENTERPRISEONE ERP 8.0 8.10 8.12 and Xe versioms CNC Support

  • Remote or on site on demand JDE technical support
  • JDE English, Spanish versions supported

ORACLE ERP E1 - What we can do for you

 Architect and mantain the JDE infrastructure resolving JDE, Network and Databases outgages.

Provide maintenance to: Data Sources, OCM, Queues, Subsystems, recover lost or damaged objects, setup activity rules, client installs, Citrix and TS installs, packages builds, menu and security maintenance, Vertex installs and maintenance, UBE and Interactive applications error tracking and resolution, RFSmart barcode integration basic support.

Create new environments, move data between environments, setup datasources for excel spreadsheet integration.

Build and execute T-SQL queries. Review the database consistency. Check the backup and restore procedures.

ADVANCED CNC TASKS SUPPORTED 

  • New Environments creation and modification.
  • Business Data refresh and Go Live Support (move to production).
  • Multiple Foundations support (multiple Service Packs support).
  • New fresh installation, reinstallation, recovering damaged installations, recovering lost tables.
  • Combo Installations: convert enterprise and deployment on a combo box.
  • JDE OneWorld - EnterpriseOne updates and upgrades.
  • ESU and ASU install (Electronic Software updates)
  • Enabling 21 CFR Part 11 Electronic Records and Electronic Signatures to complaint FDA regulations.

We offer a very competitive rates.

 Request a quote using the contact form

Read more...
 
DBA and System Administration Services

DBA Support on demandHow secure and reliable is your data?

Is a Database backup available to an emergency restore?

Is the database secure against intruders or unauthorised access?

What we can do for you
  • Backup and restore the database
  • Verify the data integrity 
  • Review the security, users ans roles 
  • Check the data and archive logs space usability
  • Database performance and tuning: find deadlock, bottle-necks.
  • Support development and testing.
  • Data extraction, creating T-SQL Queries

Ask for  On demand DBA and System Administration services.

ORACLE MSSQLSERVER

 
 

JDEdwards EnterpriseOne Fast Path Codes

The JDE FASTPATH is fast redirect to most used JDEdwards applications like Batch Versions, Automatic Accounting instructions and others.

How convert Julian Dates to Gregorian Dates - JDEdwards

Converting Julian Dates to Gregorian Dates Year Month Day in Excel and SQL Language

 

 

 

 

Internet Explorer IE7 How Open connections to server from the JDEdwards client

Demographics: Java Server (JAS), Oracle Application Server

Symptoms:
JDEdwards Applications hanging
Errors in logs of Oracle Application Server like “exception in processEvent java.lang.NullPointerException” 
SEVERE error: exception in processEvent

Possible reason: IE7 browser setting creating shortage of open connections to server from the client.

 

A/R Update Open Orders Amount using R42995 Repost Open Sales Orders

ERP JDEdwards Enterprise One

Module Account Receivable A/R

Demographics: Version Xe 8.00 8.12

Problem A/R:

Open Order Amount shows wrong quantity resulting orders on Credit Hold, but open amount is under the credit limit  (alias APRC F03012),

 Image

JDEdwards ERP1 Oneworld Backup and Recovery guide

ImageERP1 Oracle JDEdwards Backup and Recovery guide

Technology Demographic Table Product: OneWorld Version: All Platform/OS:NT 4.0. Windows 2000 Server Industry: All Application Utilities Database: ALL Author: Sergio Vargas, Peoplecnc.com Date: September 27, 2000

Overview

The correct backup procedure constitutes an invaluable source for information recovery in a prudential time, which entails to diminish the impact of a system crash.

Objective

To extend the technical specifications of the Backup procedure and add some considerations for recovery in an NT 4.0 environment

Download this PDF

How to find the JDEdwards Oracle ERP1 table name from a form's grid

ImageNeed to find the table where the field resides using a ERP1 Oneworld application, find how!

How to find the JDEdwards Oracle ERP1 table name from a form's grid

Using this trick you can find the tables names for a specific form's grid

This solutions works when the form has the option: GRID / SEQUENCE enabled.

Read more

Determining the current version of Oracle ERP1 JDEdwards

ImageDemographics of this document:
Oracle ERP1 / Peoplesoft / JDEdwards versions: Oneworld Xe, ERP8, ERP8.10

How to determine the current version that is running on the Enterprise Server of JDE / Peoplesoft / Oracle ERP1

Logon to Enterprise Server
- Using windows explorer find the file: ptf.log located at

Read more 

Oneworld Xe - Concepts and Environment Overview

Image Basic concepts of the JDEdwards / Oneworld Xe environment including data sources, users and libraries.

ONEWORLD XE - CONCEPTS AND ENVIRONMENT OVERVIEW

Windows NT Terminal Server: Allows multiple thin clients or workstations to run from a single copy of OW.

OneWorld: B73.3.3 cumulative release.

B: OW, 73: Release, 3 Version of release, 3 cumulative update level.

This document is in .PDF format.

OneWorld Enviroment overview and concepts

How to void and reissue checks and auto deposits in Payroll

ImageDemographics: Oracle ERP1 / JDEdwards / Peoplesoft ERP0 / B7334 Module: Payroll http://www.peoplecnc.com/whitepapers

How to reverse or reissue payroll payments (checks and auto deposit)

Considerations: 

  1. An interim payroll process is required in order to reissue a payroll check.
  2. Configure an interim payroll with dates matching the payment to be voided.
  3. Double check that the bank has not changed the check, it is important to have the check in hand.
  4. Do an auto deposit reversal only if you have received the funds from the Bank, e.g. incorrect bank account number, bank account closed. 
  5. An auto deposit reversal does not create a new a deposit, it will converted into a check.
Read More...

SQL Query to export to excel basic information from JDE Sales Orders history file

Demographics: Oracle ERP1 / JDEdwards / Peoplesoft ERP0 / B7334 Module: Sales Orders

Credits; Sergio Vargas PEOPLECNC.COM

Keywords: How Extract Sales Orders information / History Sales Order export to excel / Extract sales order to text or excel file / JDE / JDEdwards

Exploring the JDEdwards Sales Reports those are limited to some few. Sales Managers usually request about information to be manipulated in excel worksheets.



The SQL will inquiry JDEdward Sales Order History Table F42119

Read full article 

CNC JDEdwards Oracle support