This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Tuesday, October 30, 2012
Setting Up Benefits Administration JD Edwards E1
Converting Payroll History JD Edwards E1
When you implement the JD Edwards EnterpriseOne Payroll system in the middle of a calendar year, you typically need to enter the payroll history records from the legacy payroll system into the JD Edwards EnterpriseOne Payroll system. The system uses these payroll history records to calculate the information that appears on employees year-end forms.
The system provides a conversion process that you can use to import payroll history records from a legacy system and convert them into the format that is used by the JD Edwards EnterpriseOne Payroll system.
Each time that you process a payroll cycle, the system creates historical records of employees earnings, deductions, and taxes. You use these historical records to print historical and governmental reports, answer employees questions, and process year-end forms for employees. In some cases, you might need to import payroll history records from another payroll system and convert them to the format that is used by the JD Edwards EnterpriseOne Payroll system. These situations are examples of when you might need to convert payroll history:
http://docs.oracle.com/cd/E16582_01/doc.91/e15133/cvrt_payroll_histry.htm
Saturday, October 27, 2012
Building and Using WebServices with JDeveloper
At the end of the tutorial you create an ADF Client application that consumes the web service you created.
Monday, October 22, 2012
Jdeveloper To connect to Microsoft SQL Server
To connect to Microsoft SQL Server:
From www.microsoft.com, download and install the appropriate Microsoft SQL Server driver:
For Microsoft SQL Server 2005, choose Microsoft SQL Server 2005 Driver.
For Microsoft SQL Server 2008, choose Microsoft SQL Server 2008 Driver.
Set up the user library to contain install-directory\sqljdbc.jar.
Create a database connection to Microsoft SQL Server. Use the following values:
Connection Type:
SQLServer
Username and Password: enter the appropriate values for the connection.
Driver Class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
Library: the library you created for the driver.
JDBC URLs:
jdbc:sqlserver://machine-name:port;DatabaseName=database-name
, where the sectionDatabaseName=database-name
is optional
If you are using Windows Authentication credentials to connect to Microsoft SQL Server, you need to add do the following:
Add the connection property
integratedSecurity=TRUE
and the username and password values to the JDBC URL, for examplejdbc:sqlserver://machine-name:port;DatabaseName=database-name;username=USERNAME;password=PASSWORD;integratedSecurity=TRUE
Add the location of
sqljdbc_auth.dll
to your PATH variable:For 32bit JVM, this is
installation-directory\sqljdbc_version\language\auth\x86
For 64bit JVM, this is
installation-directory\sqljdbc_version\language\auth\x64
For more information, see Building the Connection URL, which is available as part of Connecting to SQL Server with the JDBC Driver at the Microsoft MSDN website.
http://docs.oracle.com/cd/E16162_01/user.1112/e17455/connect_work_databases.htm
Saturday, October 20, 2012
Using BPEL to Build Composite Services and Business Processes
Friday, October 19, 2012
Saturday, October 13, 2012
Saturday, October 6, 2012
Business view JD Ewards distinct Data
First create the index you want to use, then right click on the table name in the "Table Joins" window and click "Change Index". You will get error message.
Pick your single field index and you will be able to accomplish selecting the distinct values for a single field without selecting the entire primary key.
Source:JDELIST
Friday, October 5, 2012
Convert Numeric to A String with decimals - JD Edwards
B0400410