Certification on Oracle service modules
I am a crm function consultant, is there any certifications available in Oracle for Oracle Apps service modules such as field service,teleservice,depot repair,service contract & even want to know if there any certifications available on Oracle Apps sales & marketing.
Real time question submitting two concurrent program from back end?
How we submit two concurrent program from backend.If one program is got error out no need to stop the program u need to run second concurrent program..?
What are the different types of accounting entries available in ap?
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...
What is tar? What is the processes to raise tar in detail? What is metal link?
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...
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.
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.