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 and thanks fro your reply,I have one comments regarding calculating YTD field, now from gl_balances table I used the opining balances with the period amount to calculate YTD , now from gl_je_lines , I will use only period amount,How can I check if the values I calculate are correct? I mean I...

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...

Thanks a lot...............

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...

Thanks Alot mdwyer......

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...

Thanks mdwyer for ur reply, MR is stand for Material requisition, but where can I find this pl/sql package that you talking about. thanks

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...

I checked the table and I didn't find any column? But I have an idea i'm not sure if it's correct or not since I'm new to the ERP applications, if the invoice is validated , can we change any field on it, because if the system will lock this record , then the last update will be the date when...

Hi and thanks for your help , I checked the table and it's empty, because we are not using approval workflow , we just let the user to choose validate check box from the action screen , Is this means that we can not see who validate invoices? Thanks in advance

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...

Thanks very much Kccbb, I read the loader part from system administration document , but I could not under stand where shall i find this configuration file ? is it exist or I should create my own configuration file? Thanks again for ur help regards

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...