| DBA and System Administration Services |
|
|
|
|
Is a Database backup available to an emergency restore? Is the database secure against intruders or unauthorised access? What we can do for you
Ask for On demand DBA and System Administration services. ORACLE MSSQLSERVER
|
How secure and reliable is your data? | < Prev |
|---|
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
