ERPstuff - Oracle EBS Community

hi,

how to Write a PL/SQL program to extract data from Oracle base tables into a flat file. can i use UTL_FILE or is there any other way.

thanks,
venkat

hi,

i have a requirement where i need to display flexfield information.
which table stores this information.
also need to display segment description in GL. how to do that.
can plz anyone help me

thanks,
venkat

Hi,

1. How the invoices are related to receipts in AR?

2. What is the technical flow of transfer of AR to GL?

Can anyone explain me?


Thanks,
venkat

hi i have a situation where i need to display only few records in a form. i am giving a condition if (:dept.deptno=40) then clear_record; end if; but the record is not cleared automatically. it is getting cleared once i go into that particular record. what else can i do. can i use exec sql to displa...

hi,

i was trying to open a form using call_form('formname'). but it's not opening any new forms. i tried using new_form,open_form also.
i am working on windows xp,oracle forms 6i.can anyone tell me how to do it.

thanks,
venkat

hi,

can anyone plz explain me or upload the documentation for TCA in AR.


thanks,
venkat

hi,

what is the difference btw api and interfaces.can anyone plz
explain.

thanks,
venkat

hi,

how to use autoinvoice in AR. can anyone let me know plz.

thanks,
venkat

hi,

you can use
set timing on;
in sql
to check how much time one query is taking.

thanks,
venkat

hi,

i want to develop a new oracle apps form.

thanks

thanks uma.

venkat

hi,

custom.pll is a standard pl/sql library given by oracle apps.it interacts with every EBS.for customizations in oracle apps forms you write the code in custom.pll and place it in the appropriate folder.

thanks,
venkat

hi,

why do you use pl/sql tables in a package.what is the use of them.
can anyone plz let me know.

thanks,
venkat

hi,

how to scratch develop the forms in oracle apps.
can anyone plz let me know.

thanks
venkat

hi,

how to use autoinvoice in payables.can anyone plz let me know.

thanks