Page 1 of 1
budget interface
Posted: Tue Mar 13, 2007 8:25 am
by annadasahoo
Can u pls tell me about budget interface?
Posted: Wed Mar 14, 2007 7:06 am
by anu_uma
<font color="blue">
Using the <b>BUDGET INTERFACE</b>
If you maintain your Budeget information in a preadsheet, u can upload it to Orace Assets. U can transfer budget data from any S/w package that prints to an ASCII file and then use the SQL loader or ADI (Applications Desktop Integrator) to load the FA_BUDGET_INTERFACE
</font id="blue">
Posted: Wed Mar 14, 2007 7:21 am
by annadasahoo
hi uma
thanks a lot.
using sql*loader we can load the data to interface tables.
but after that what to do .
means api is used to load to base tables or what??
pls help me.
thanks
Posted: Wed Mar 14, 2007 7:52 am
by anu_uma
After Loading the Data U can check the same in applications.
Posted: Fri Mar 16, 2007 8:05 am
by admin
From interface you always have to import. thanks
Posted: Fri Mar 16, 2007 8:18 pm
by muzaffarnaim
annadasahoo
You didnt mention either u r loading capital budget or revenue expenditure budget...however u upload data directly into base tables and then from appl u can view and modify/update what ever u want before creating budget journal or posting (depends which method u r using).
Muzaffar
Oracle Consultant
Posted: Fri Mar 16, 2007 10:34 pm
by siva sankar
Hi,
Using SQL*Loader program we can upload the data from flat file to staging table,then we write the pl/sql package,using cursor to load the data into interface table from staging table.