WHICH IDOC TYPE FOR SD CREDIT/DEBIT NOTES.
Hi, We are implementing an EDI Solution for SD Invoices which would involve sending EDIFACT Messages generated out of mapping the SAP iDOC TYPE INVOIC02 to the EDIFACT fields. We also have to send Credit and Debit Notes generated from SAP in the SD Module in the same path. We are currently planning on using [...]

Answer Question   |  March 28, 2005  4:05 PM
EDI, ERP

Congress to ban sale of SSNs for commercial purposes?
According to articles in today’s Washington Post and Wall Street Journal, Congress is considering legislation to ban the sale of Social Security Numbers for commercial purposes, unless individuals give their permission. The Post article went on to opine that there appears to be a growing bipartisan consensus among key House and Senate members to enact [...]

Answer Question   |  March 23, 2005  3:14 PM
Auditing, Business/IT alignment, California Security Breach Information Act, Compliance, E-business, Information risk management, ISO 17799, Laws, Regulations, Sarbanes-Oxley Act, Security, Security management, standards

Outer Join
I have two queries below. One table has one row for each the other table has many rows for each one in the first table. Can someone show me how I can join these tables and get the results I’m looking for? SELECT A.NAME AS TABLE_NAME , ‘,’, B.NAME AS TBL_SPACE, ‘,’, B.DBNAME AS DB_NAME, [...]

Answer Question   |  March 16, 2005  2:03 PM
DB2

migration from 2000 to 2003 using ADMT v 2.0
We have multiple forests in our organisation.We are now planning to consolidate them into a single forest and a single domain.We have more than 200 different sites spread all across the world. We have now upgraded all our domain controllers to 2000 and 2003 servers.We have a proper test lab being setup for performining all [...]

Answer Question   |  March 16, 2005  6:32 AM
Data center operations, Database Management Systems, DataCenter, Disaster Recovery, Hardware, Microsoft Operations Manager, Servers, Systems management software, Tech support, Windows, Windows 2000 Server, Windows Server 2003, Windows tools/WSRM

SQL Server equivalent of Oracle’s desc tablename command
Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle’s desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular [...]

Answer Question   |  March 17, 2005  2:13 PM
Database Management Systems, MySQL, Oracle, SQL Server

Difference between SQL and T-SQL(Microsoft SQL Server 2000)
What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

Answer Question   |  March 15, 2005  9:25 AM
Database Management Systems, DataCenter, MySQL, SQL Server

SAP (HR authorisations). View ex-employees.
Our departmental SAP HR users currently have access through structural authorizations to their “active” workforce – those employees holding active positions in OM. There is a business need for these users to be able to see records for employees who have retired or terminated from their department – these employees no longer hold active positions. [...]

Answer Question   |  June 21, 2011  10:37 AM
ERP, MySAP, mySAP Financials, mySAP Human Resources, SAP, Security

Oracle ./runInstaller problem
Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. “You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME. Installation cannot continue.: Permission denied” The following environment are set [...]

Answer Question   |  March 25, 2005  11:19 PM
Database Management Systems, Oracle, Oracle 9i, Standard Edition

ID Theft and National Security
If it turns out, as I believe, that enemies of the United States are behind a lot of the major ID thefts in the US, that would mean that a lot of money is going to our enemies. Can we therefore surmise that those who mishandle our identity information, by means of their poor stewardship [...]

Answer Question   |  September 21, 2010  10:35 PM
Application security, Auditing, Biometrics, Business/IT alignment, California Security Breach Information Act, Can Spam Act, Compliance, CRM, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Gramm-Leach-Bliley Act, HIPAA, Identity & Access Management, Incident response, Information risk management, Instant Messaging, ISO 17799, Laws, Policies, provisioning, Regulations, Risk management, Sarbanes-Oxley Act, Secure Coding, Security, Security management, Security products, Security Program Management, Security tokens, Single sign-on, standards, USA Patriot Act, Vulnerability Assessment & Audit

Linux based CRM systems
I know several companies are working on Linux based CRM systems, but are there any commercial grade complete CRM products available on the market today (March 2005)? Thanks

Answer Question   |  March 11, 2005  1:19 PM
Call Centers, CRM, Customer relationship management applications, Data analysis, ERP, Exchange, Linux, Microsoft Windows, Oracle, PeopleSoft, Salesforce.com, SalesLogix, SAP, Siebel

Versioning and merging products for oracle
Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I’m hoping for some recomendations.

Answer Question   |  March 15, 2005  7:55 AM
Administration, Application software, Architecture/Design, Automated, Development, Functional, Knowledge management applications, Lifecycle development, Migration, Oracle, Oracle 9i, Performance/Load, Software testing, Software testing tools, Special-purpose software, SQL

To go with RDBMS or OODBMS for a database to store textual excerpts
Hello, I am currently designing a database to store textual excerpts: quotations from certain genres of literature will be stored. Relations will exist between different types of quotes and quotes and their topic sentences etc. I am deliberating on whether to use an RDBMS or an OODBMS for this project. I have read about the [...]

Answer Question   |  March 16, 2005  6:07 AM
Database Management Systems

Convert date format from UTC to PST in SQL
HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

Answer Question   |  March 10, 2005  3:30 AM
Database Management Systems, SQL Server, Standard Edition 2000, T-SQL

Installation of Oracle9i client
How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

Answer Question   |  March 10, 2005  2:24 AM
Database Management Systems, Oracle

Database comparison
I know this is ‘cheating’ but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp’s etc. I think this can be done using systables, however i was wondering if anybody had done this and how [...]

Answer Question   |  March 10, 2005  4:21 PM
Database, DB2, Oracle, SQL Server, SQL Server 2000, T-SQL

Domino Database Last Used
Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

Answer Question   |  March 9, 2005  7:36 AM
Database, DB2, Development, Domino Designer, Lotus Domino, Oracle

How to re-feed SAP data back to Taxware?
I am using R/3 V46B and Taxware. Our financial info feeds into Taxware automatically. At one time, we lost 1 day of data going to Taxware. How can I re-feed those missing data into Taxware again ? Those missing doc are still in SAP. Any notes or any suggestions ? Thank you.

Answer Question   |  March 10, 2005  3:27 PM
Basis, ERP, MySAP, mySAP Accounting, mySAP Financials, R/3, SAP

CLOB – Fetch out of sequence
I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE where SESSION_ID [...]

Answer Question   |  March 3, 2005  10:48 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML

PMP transitioning from tech oriented projects to business oriented projects
I am a PMP with 10+ years experience in implementation oriented projects (rollouts, user moves, infrastructure, NetOps, etc.) for internal clients. I want to transition to business oriented projects (SAP, PeopleSoft, SOX, SW development, etc.) for external clients. I am fully familiar with PMI methodologies but have no experience and little familiarity in any of [...]

Answer Question   |  March 11, 2005  10:08 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance

Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT experise to build or maintain, and will deliver maximum performance in terms of response time and data [...]

Answer Question   |  March 7, 2005  10:03 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server