budget interface

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
annadasahoo
Posts: 12
Joined: Wed Feb 28, 2007 12:40 pm
Location: India

budget interface

Post by annadasahoo »

Can u pls tell me about budget interface?
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post 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">
annadasahoo
Posts: 12
Joined: Wed Feb 28, 2007 12:40 pm
Location: India

Post 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
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by anu_uma »

After Loading the Data U can check the same in applications.
admin
Posts: 2097
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

From interface you always have to import. thanks
muzaffarnaim
Posts: 66
Joined: Fri Dec 15, 2006 4:59 pm
Location: USA

Post 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
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

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

Who is online

Users browsing this forum: Bing [Bot] and 1 guest