I need some help writing a query to pull some data out of a Release 12.1.3 eBusiness Suite database, specific to the accounts payable module.

I need a payments history query between 2 dates, that provides the following fields:

supplier ID, supplier name, site ID, supplier invoice number, oracle invoice number (voucher number?), invoice date, payment date, total invoice amount, VAT amount, method of payment, payment reference number (e.g. check run details).

Can anyone assist - no idea where to start in terms of tables. Presume its quite a common query though so hopefully someone has some sample SQL to share. I'd prefer to get the data this way that via a standard report in the application. most standard reports that sounded close were more geared towards reports per supplier, whereas I need it for all payments, regardless of supplier.

We are looking at doing a DNS web filtering service. We have public WiFi so we feel this is the easiest way to avoid an ssl mismatch.
If we did do DNS filtering, would it be logical for us to block all connections to port 53 UDP unless it's to the web filtering DNS servers? This way someone can bypass it by changing their DNS servers?

I am using an ERP product called Epicor and trying to create a calculated field using their query tool.  The code as I understand is Progress.

I have a value in a number field of 24,165 which represents the seconds past midnight.  When converting it to a readable time it is 06:42:45 AM.  Here is the code to get that which I am converting to a character field......
String(Integer(LaborHed.Number01),"HH:MM:SS")

My issue is I need to round up this to the closest 15 minute interval which in this case would be 07:00:00 AM.  Here is my lame attempt......
String(Round(LaborHed.Number01 * 60 * 60 / 3600,0),"HH:MM:SS")

People,

What would be your suggestion as the task to do for the first 90 days as a System Administrator in the new company you joined ?

Thanks in advance.

I am having a hard time trying to figure out how to take a quote and convert it into an order in SalesForce.  What I want to accomplish is after I have quoted something with line items and all.  Once the quote gets accepted I then want to convert that into an order.  Carrying over all the line items and account information.  I am trying process builder and got the order created but just basic data is there.  I need all the data from the quote to carry over.

Is there anyone that can assist me with this.

I am trying to set up a Select All Checkbox on the Salesforce CPQ Steelbrick.

Okay, so this is what I did:
 
I created a Select All checkbox field on the Product Option Page.
 
Then I created a new Configuration Attribute called Select All Checkbox.
These are the settings that I have set up.

This is how it's displayed on the Quote Line Editor.
 
All I need now is for when it's selected to select all the Products in the bundle.
 
So, I tried setting up a product rule according to the resources that I found. My settings are as follows.

I also added the Configuration Rule to the Bundle as well.

I think it might have something to do with the Error Condition.
This is how I have the condition set up. I don't know if it is accurately checking if the checkbox is checked or not so it can fire the rule. Maybe setting the value to True isn't the right value?

Any help is appreciated. Thanks!

Dear Experts

We have around 5000 application forms filled and each application form of 20 pages, now we have implemented CRM software application but each physical application entering in the CRM software takes too much of time, we have to process these forms to next level  like rasing invoice from software CRM but every form entering to the CRM application takes time and we have short time, is there any way OR any device which can scan the dully filled application form and convert it into word document, requirement is the conversion to the word document should be editable and alignment should be as per the physical forms.

please suggest, thanks in advance.

Please provide me with the steps to setup a Windows 7 OS so that while a user is sitting in front of the computer using it and then another user connects to the same computer using Windows 7 the user sitting in front of the computer won't have his/her computer session locked.

We need to make it so that both the user in front of the computer and the user who connects remotely using remote desktop will be able to both use the computer at the same time

I have Exchange 2010 SP3 Enterprise and going to apply an ActiveSync policy to our mobile phone users.  Within the policy I see I can enable the password recovery option, which I checked.  I can view this either through OWA, EMC or shell for an individual's recovery password.  My question is how (or where) do you use this recovery password to unlock a users device?  

Thank you,

Dear Experts,

 How do I export Oracle DataBase diagram inclluding VIEWS also, to any tool like Visio or something else more friendly to make a revers engineering for Database diagram

Thanks

Hello Experts,

I'm running Splunk to grab some live data off a switch and my regular expression is working great when it comes in a single line. However sometimes when the events happen too close together (which is common) the data comes in with multiple lines and the regex then only catches the first line. I googled it and everything I found said to just add (?m) to the beginning but that doesn't seem to be working. Here's a screenshot of the missing data from any more than one received at a time.
splunk-regex.png