Oracle Apps FAQs
What is tar? What is the processes to raise tar in detail? What is metal link?
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...
How to run the GL posting through custom program?
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.
How to create india localization setups?
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...
Need a query that can give me all the responsibilities that have a specific function.
The input param will be the "function name" and the output should be "all the responsibilities that use that function" irrespective of whether the function in under the menu or the sub-menu of that responsibility.
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
How to join the tables in PO modules?
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...
Oracle Apps error rep-0613 : value does not match
Hi,while running reports in Oracle applications ,i also defined a value set with parameters. Moreover I have defined the correct mask for the date field in the properties of report & I got the following errors:appllcsp environment variable set to:current nls_lang and nls_numeric_characters environment...
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
GL - journal entry for reversal
What is the journal entry for reversal?
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...
How to get distinct value for any column in value set.E.G table is emp, to type value set for job then in lov it has to display distinct job.
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
What is pa module? What are its main use & what are its steps & navigations?
Oracle Projects is suite of modules which combines Project Costing Project Billing Project Foundation Project Management Project Resource Management and Project Portfolio Management Oracle ...
Open return orders conversion from 11i to Oracle r12
Whether any one worked on sales order conversion and I want to know the process to do this and I am having some concerns in data mapping...Please assist on this...Regards,ravindra.
Open return sales order conversion from 11i to r12
I am going to work on open return sales order conversion with line category is "awaiting return" and first time I am doing this conversions...Could you please any one tell me the process and if you guys having any sample codes,please mail me to raviApps84@gmail.Com...Thanks in advanceravi
What is ers? Use of this function?
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
How to set org id?
By using fnd_clinet_info.set_org_context
begin
fnd_client_info.set_org_context(org_id)
end
What is the difference between conversion and interface
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.
Are dff's controlled at organisation level? If yes how?
What are the different types of accounting entries available in ap?
How many types of sales orders are there in order management. What are they?
There are various types of sales orders in order management which are as follows:-1. Standard Order2. Book and Bill 3. Expense Order4. Demonstration order5. CEU orders, i.e., Customer Evaluation order...
3 Types of Sales Order are Available. They are:
1.Standard Sales Order
2.Mixed Sales Order
3.Return Sales Order
In Standard Sales Order we have
1.Back to Back
2.Drop Shipment
Internal Sales Order are raised within an Organization
How to do a conversion involving two legacy systems?
User Panel
Categories
Ads
Interview Coaching
Connect
Ads
Question Categories
Interview Question
Career Counselling
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".
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.