ERPstuff - Oracle EBS Community

Dear All,
will let every one know that what are the job profiles that are available in the market for Oracle Applications Professionals and thier role in implementation

1) Designation = Oracle Applications DBA (Data Base Administrator)
Role = He is the one who is responsible for installing oracle ...

Hi,

What is the purpose of the Pair and Specal Valuesets , why do u need.

HI,

See this link

http://edelivery.oracle.com/EPD/Search/handle_go

and find out the Linux Erp Application 12 version.


Thanks
Sankar Reddy

Hi,

Plz check it this link, its good materail for HRMS and Payroll
http://www.erpstuff.com/forums/topic.asp?TOPIC_ID=780



Thanks
Sankar Ch

[quote]Hi,

Please help.

I want to learn HRMS Flow in Oracle.

Can any body send me any docs.

Thanks in advance.

Abdul Rawoof

<i><div align="right ...

Hi,


What is an Internal Requisition?
=====================
A requisition in the Purchasing system that will directly result in the generation of a sales order in the Order Management system through the Order Import process in Order Management.

Why do we use internal requisition/internal sales ...

Hi All,

Oracle Financials
Open Interfaces
Reference
RELEASE 11i
January 2000
Oracle Financials Open Interfaces Reference Release 11i
Copyright 1995, 2000, Oracle Corporation. All rights reserved.
Primary Authors: Janet Coshow, Christopher Andrews, Janet Buchbinder, Frank Colligan, Gail
D?Aloision ...

Hi All,
See the attachment of the Account receivables faqs


[img]/images/icon_zip.gif[/img] <b>Attachment:</b> AR_faqs.zip <i>( 4702bytes )</i>


Thanks,
Sankar Ch

HI,



[img]/images/icon_zip.gif[/img] <b>Attachment:</b> Performance Tuning.zip <i>( 11103bytes )</i>

Thanks,
Sankar Ch

Limitations of Forms Personalization
This feature has several significant limitations due to the architecture of Oracle Forms and/or the e-Business Suite.

[1] User can only change what Oracle Forms allows at runtime. For example, the following cannot be changed:

? User cannot create new items ...

Hi,
This is Good link for the Barcode For Oracle Reports.

http://www.idautomation.com/components.html


Thanks,
Sankar Ch

Hi,



Oracle Implementation Methodalagy


Application Implementation Method is a provan approach, which specifies all the activities which are required to implement oracle applications successfully.

The scope of the AIM is enterprise wide.

There are eleven processes of implementation.

1 ...

Hi,
See this Infoamtion

Indian localization
Oracle Applications was developed as a Global product.Because of this reason it does not supported by some acts like customs,central excise,vat,cst...etc which are mandatory according to Indian Laws.

All other contries are also having some contry ...

To check responsibility which contact given function

1. To get form Id from database
SELECT FUNCTION_ID, USER_FUNCTION_NAME FROM FND_FORM_FUNCTIONS_TL
You can also use
SELECT FUNCTION_ID, FUNCTION_NAME FROM FND_FORM_FUNCTIONS

2. Pass The obtained Function id or function name to following query ...

DECLARE
TYPE t_id IS TABLE OF t1.ID%TYPE;
TYPE t_val1 IS TABLE OF t1.val%TYPE;
l_id t_id;
l_val t_val1;

CURSOR c1 IS
SELECT ID,val FROM t1;
ERRORS PLS_INTEGER;
err_cd PLS_INTEGER;
BEGIN
OPEN c1;
LOOP
FETCH c1
BULK COLLECT INTO l_id,
l_val LIMIT 5;

DBMS_OUTPUT.put_line ('LIMIT=' || l ...

Question: How to find the current quantity in Oracle Inventory. What is the table and column details?
The short answer is, you can get the current inventory balance by querying the mtl_onhand_quantities view. To get the current balance you would have to write a query like
select sum(transaction ...