Java Virtual Machine Launcher Could Not Find Main Class Program Will Exit in BI Publisher Desktop in MS Word

Go to BI Publisher menu in Word. Tools > options > preview tab. Java home should be selected there, if not select it. ...

Use of the API FND_PROFILE

It is used to perform various actions related to profile values through PL/SQL. Some of the important ones are listed below: SELECT fnd_profile.value('PROFILEOPTION')    ...

How to identify the Activity ID for a Oracle Workflow Activity

 SELECT WI.ITEM_TYPE               ,WI.ITEM_KEY               ,WI.BEGIN_DATE        ...

Query to find the Position Attached to Username in Oracle Apps

SELECT pos.name position_name, pa.position_id,fnd.user_name FROM PER_ALL_ASSIGNMENTS_F pa, per_positions pos,per_jobs job, fnd_user fnd WHERE pa.POSITION_ID = pos.POSITION_ID and...

Purchase Requisition Action History in Oracle Apps

select poah.sequence_num seq#, poah.action_date, poah.action_code, poah.employee_id emp_id, fnd.user_name, substr (poah.object_type_code,1,3) type, poah.object_sub_type_code sub_type, poah.object_revision_num...