Search results for query: *

Hi, I'm using oracle 9i on a server , and microsoft iis 6.0 is running on other server, I want to create a stored procedure, that read log file exist on iis server, and insert data on a table on oracle server. I want this procedure to run on daily basis, updating table content, then I will...

Hi... I created a profit and loss report for all years in discoverer, Shall I use YTD calculation or PTD calculation in this report? This report is not based on period name, I displayed only period year, but I guess since the YTD calculation is comulative, the total on year will be wrong? How...

Hi... I'm trying to create a report in discoverer that match what is appearing in the fund available inquiry screen , I created a report that read data from gl balances table , the budget and actual figures are correct but the encumbrance figures are wrong, I checked the GL records and compare...

Hi... I'm trying to create a budget variance report that may be accessed by different departments, there are some security roles on the account flex field that let the users see thier departments data only , it's working fine on ERP screens but my report shows all the data, from where I can...

Hi... I'm trying to create a report in discoverer that shows first the summary figures and then goes down to the account details, I want to create a hierarchy of the accounts, example: + assets + current Assets + -------- + -------- + -------- + liabilities + -----...

Hi... I have a report that shows the actual YTD , Budget YTD , Encumbrance YTD. I want to create another report that list the invoices data from GL since they are represent the Actual YTD figure in the first report. I tried to list the data from GL_je_lines table , but these amounts are...

Hi... I need to create a leave adjustment report, where I can list employee name, type of leave , original day of leave , original last day of leave,actual day of leave , actual last day of leave and leave balance. Actually , I don't know where can I do the adjustments and where can I get...

Hi... How can I calculate YTD actual and budget from gl_balances table? I found this formula when I searched through metalink : YTD = begin_balance_dr + period_net_dr - begin_balance_cr - period_net_cr but when I use it and compare the report output with the system data , I get some figures...

Hi... I need a help on how to develop budget variance report in discoverer, I want to create a report listing account , budget , commitments, actual and available fund and I don't know where can I get these information? I tried to get the sql from fund inquiry screen but it seems that these...

Hi... in our system , when the manager approve the MR , a notification message will send to the preparer telling him that the MR is approved , I need to modify this by sending a message to preparer and requester , but I don't know where can i find this process to modify it, and what shall i...

Hi... I'm trying to find out where is the invoice approval date, and approval by fields exist in the tables? We are using a manual method to approve invoices , using validate check box , and I want to create a report showing invoice created date, created by , validation date and validated by...

Hi... I'm new in dealing with oracle erp applications,I wonder if there is a way (script) to copy the concurrent data ( executable,define , parameters) from server to another server, because it took lots of time to reenter and define request in the production were we already defined them on...