This is more a feature question as opposed to an sforce question, but i dont know where else to turn.
We're starting to use the revenue schedule feature for products, and were wondering what effects this has on other parts of the salesforce system (besides the opportunity detail page)? For example, do the forecasts take into account the revenue schedule, or just the total oppor amt/close date?

Can i adjust the product schedule via sforce? Can i make a custom schedule (that doesnt use fixed intervals)?

Thanks in advance.

our application queries the Organization entity to get the org name and id of the current user.
it used to work fine, but we are now getting ORA-XXX oracle errors in the fault string.
Note that it still works if the current user has admin privs; this error only happens when a non-admin user is issuing the sforce call...but this used to work..

is there a better (w/o using the 2.0 undocumented api call) to get the org id?

sent:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Header>
  <ns1:SessionHeader soapenv:mustUnderstand="0" xmlns:ns1="SoapService">
   <ns2:sessionId xmlns:ns2="urn:partner.soap.sforce.com">[omit]</ns2:sessionId>
  </ns1:SessionHeader>
  <ns3:QueryOptions soapenv:mustUnderstand="0" xmlns:ns3="SoapService">
   <ns4:batchSize xmlns:ns4="urn:partner.soap.sforce.com">500</ns4:batchSize>
  </ns3:QueryOptions>
 </soapenv:Header>
 <soapenv:Body>
  <query xmlns="urn:partner.soap.sforce.com">
   <queryString>SELECT Name,Id FROM Organization</queryString>
  </query>
 </soapenv:Body>
</soapenv:Envelope>

received:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Body>
  <soapenv:Fault>
   <faultcode>soapenv:Server.userException</faultcode>
   <faultstring>java.sql.SQLException: ORA-20000:
ORA-06512: at &quot;BUILD132R5A.CPERMISSIONS&quot;, line 46
ORA-06512: at &quot;BUILD132R5A.CORGANIZATION&quot;, line 2382
ORA-06512: at line 1
</faultstring>
   <detail/>
  </soapenv:Fault>
 </soapenv:Body>
</soapenv:Envelope>

did something change w/ the product entity today??? our application was working for a long while (same code), and starting getting excpetions tonight...it inserts products into the product entity. today we started getting a field integrity exception. api 2.5 using axis 1.1, btw.

xml sent:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Header>
  <ns1:SessionHeader soapenv:mustUnderstand="0" xmlns:ns1="SoapService">
   <ns2:sessionId xmlns:ns2="urn:partner.soap.sforce.com">[removed]</ns2:sessionId>
  </ns1:SessionHeader>
 </soapenv:Header>
 <soapenv:Body>
  <create xmlns="urn:partner.soap.sforce.com">
   <sObjects xmlns:ns3="urn:sobject.partner.soap.sforce.com">
    <ns3:type>Product</ns3:type>
    <Name xsi:type="xsd:string" xmlns="">Content Management Server 2003</Name>
    <DefaultPrice xsi:type="xsd:double" xmlns="">700.0</DefaultPrice>
    <PricebookId xsi:type="xsd:string" xmlns="">00i30000000bp5wAAA</PricebookId>
   </sObjects>
  </create>
 </soapenv:Body>
</soapenv:Envelope>

respone:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Body>
  <createResponse xmlns="urn:partner.soap.sforce.com">
   <result>
    <errors>
     <fields xsi:nil="true"/>
     <message>field integrity exception</message>
     <statusCode>FIELD_INTEGRITY_EXCEPTION</statusCode>
    </errors>
    <id xsi:nil="true"/>
    <success>false</success>
   </result>
  </createResponse>
 </soapenv:Body>
</soapenv:Envelope>

did something change w/ the product entity today??? our application was working for a long while (same code), and starting getting excpetions tonight...it inserts products into the product entity. today we started getting a field integrity exception. api 2.5 using axis 1.1, btw.

xml sent:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Header>
  <ns1:SessionHeader soapenv:mustUnderstand="0" xmlns:ns1="SoapService">
   <ns2:sessionId xmlns:ns2="urn:partner.soap.sforce.com">[removed]</ns2:sessionId>
  </ns1:SessionHeader>
 </soapenv:Header>
 <soapenv:Body>
  <create xmlns="urn:partner.soap.sforce.com">
   <sObjects xmlns:ns3="urn:sobject.partner.soap.sforce.com">
    <ns3:type>Product</ns3:type>
    <Name xsi:type="xsd:string" xmlns="">Content Management Server 2003</Name>
    <DefaultPrice xsi:type="xsd:double" xmlns="">700.0</DefaultPrice>
    <PricebookId xsi:type="xsd:string" xmlns="">00i30000000bp5wAAA</PricebookId>
   </sObjects>
  </create>
 </soapenv:Body>
</soapenv:Envelope>

respone:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Body>
  <createResponse xmlns="urn:partner.soap.sforce.com">
   <result>
    <errors>
     <fields xsi:nil="true"/>
     <message>field integrity exception</message>
     <statusCode>FIELD_INTEGRITY_EXCEPTION</statusCode>
    </errors>
    <id xsi:nil="true"/>
    <success>false</success>
   </result>
  </createResponse>
 </soapenv:Body>
</soapenv:Envelope>

I wrote a loop that query's through every account record I have (150,000 total), and it runs through at about 10 records per second (BatchSize set at 500). Which would take around 4 hours.

My company also uses DataJunction, and when we use it to download all accounts it runs in 20 minutes.

Is their a good reason DJ can run that much faster compared to using the API? I can provide my code if needed.

Thanks