Company Services DBA and System Admin
| Oracle JDE ERP1 CNC Managed Services |
|
|
|
| Company Services - JDEdwards JDE CNC | |
|
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
ORACLE ERP E1 - What we can do for youArchitect 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
We offer a very competitive rates. Request a quote using the contact form |
|
| Next > |
|---|
JDEdwards ERP1 Oneworld Backup and Recovery guide
ERP1 Oracle JDEdwards Backup and Recovery guideTechnology 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
How to find the JDEdwards Oracle ERP1 table name from a form's grid
Need 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.
Determining the current version of Oracle ERP1 JDEdwards
Demographics 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
Oneworld Xe - Concepts and Environment Overview
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.
How to void and reissue checks and auto deposits in Payroll
Demographics: Oracle ERP1 / JDEdwards / Peoplesoft ERP0 / B7334 Module: Payroll http://www.peoplecnc.com/whitepapersHow to reverse or reissue payroll payments (checks and auto deposit)
Considerations:
- An interim payroll process is required in order to reissue a payroll check.
- Configure an interim payroll with dates matching the payment to be voided.
- Double check that the bank has not changed the check, it is important to have the check in hand.
- Do an auto deposit reversal only if you have received the funds from the Bank, e.g. incorrect bank account number, bank account closed.
- An auto deposit reversal does not create a new a deposit, it will converted into a check.
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
