Oracle Apps FAQs

What are the currencies will be used by the revaluation?

Revaluation is used if, and only if, you have foreign currency transactions (i.e.Conversion of foreign currency transactions).

Revaluation uses the Period Rates Table. The Revaluation Rate is simply 1/Period End Rate.

As you know there are three types of items: •Inventory Expense Item a) Create Receipt Inventory Receiving A/c Dr Accrual A/c Cr b) Receiving Transaction Expense A/c Dr Inventory Receiving...

Metalink is the Oracle Corporation Website, Where any one can get all the Information about A-Z of Oracle , Oracle Products, User Guides, Technical Reference Manuals etc... To access metalink one nee...

 TAR stands for Technical Assistance Request from Oracle. This is wbbased support from to their Oracle Apps/E-business suit customers.This done thru their site metalink.oracle.com.

It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...

In two ways we can post the journals.

Journals> Post function will helps you to post specific journels or we have a request "Program - Automatic Posting", this program will post all the journals.

Hi,

Please share R12 Indian locailzation setup and Procedural documetns to me.

Regards
Raju

For this there is a diff module called India localization in that there are separate setup is the based on the tax, local area its depend for ex. in standard when you create an organization in India l...

here is the query that give you all responsibilities having a specific function in menu or sub menus: "oracle8 replace yourFUNCTION_NAME by your function_name SELECT r.RESPONSIBI...

but this query will list just the menu linked directely to responsibilities, not their sub menus also

Following should work for standard POs "sql SELECT * FROM po_headers_all pha ,po_lines_all pla ,po_line_locations_all plla ,po_distributions_all pda WHER...

Use the value set FND_STANDARD_DATE and in the user parameters defined in the report use the following as input mask against the date field.

RRRR/MM/DD HH24:MI:SS

Journal entry used to reverse accruals, estimates, errors or temporary adjustments. You can reverse the journal by ‘assigning reversal period or reversal effective date to a journal entry which you...

select PERIOD_YEAR
from gl_periods
where rowid in (select max(rowid) from gl_periods group by
PERIOD_YEAR )
order by PERIOD_YEAR

Follow the same with required table.

Use select distinct column name from table instead of table name

Oracle Projects is suite of modules which combines Project Costing Project Billing Project Foundation Project Management Project Resource Management and Project Portfolio Management Oracle ...

ERS Belongs to AP Module.

Pay on Receipt also known as ERS(Evaluated Receipt Settlement) or Self-Billing, is an Oracle Purchasing Concurrent Program, which automatically creates invoices in Payables and matches them with purchase orders for the received amount.

ERS is used in ap not in GL

By using fnd_clinet_info.set_org_context

begin
fnd_client_info.set_org_context(org_id)
end

Conversion is one time process interface is scheduled process.

There is very major difference b/w conversion & interface.
data conversion is receiveing data from a legacy syatem ,validating it &  converting to our targat module using the import program.

Interface is used to transfer data from legacy system to oracle system.