Entries by Oracle ERP Apps Guide

, , , , , , ,

Script to Get Concurrent Request Details

selectrequest_id, parent_request_id,fcpt.user_concurrent_program_name Request_Name,fcpt.user_concurrent_program_name program_name,DECODE(fcr.phase_code,’C’,’Completed’,’I’, ‘Incactive’,’P’,’Pending’,’R’,’Running’) phase,DECODE(fcr.status_code, ‘D’,’Cancelled’,’U’,’Disabled’,’E’,’Error’,’M’,’No Manager’,’R’,’Normal’,’I’, ‘Normal’,‘C’,’Normal’,’H’,’On Hold’,’W’,’Paused’,’B’,’Resuming’,’P’,’Scheduled’,’Q’,’Standby’,’S’,‘Suspended’,’X’,’Terminated’,’T’,’Terminating’,’A’,’Waiting’,’Z’,’Waiting’,’G’,’Warning’,’N/A’) status,round((fcr.actual_completion_date – fcr.actual_start_date),3) * 1440 as Run_Time,round(avg(round(to_number(actual_start_date – fcr.requested_start_date),3) * 1440),2) wait_time,fu.User_Name Requestor,fcr.argument_text parameters,to_char (fcr.requested_start_date, ‘MM/DD HH24:mi:SS’) requested_start,to_char(actual_start_date, ‘MM/DD/YY HH24:mi:SS’) ACT_START,to_char(actual_completion_date, ‘MM/DD/YY HH24:mi:SS’) ACT_COMP,fcr.completion_textFromapps.fnd_concurrent_requests fcr,apps.fnd_concurrent_programs fcp,apps.fnd_concurrent_programs_tl fcpt,apps.fnd_user fuWhere 1=1— and fu.user_name = ‘JMOHANTY’— and fcr.request_id = 1565261— and fcpt.user_concurrent_program_name = ‘Autoinvoice Import Program’and fcr.concurrent_program_id = […]

/by
, , , , , , , , ,

Adding responsibility using fnd_user_pkg

Some times we don’t have the access to add the responsibility to the user using the the Create User form. So for this Oracle is having one API fnd_user_pkg.addresp which can do the job without using the Create User Form. — R12 – FND – Script to add responsibility using fnd_user_pkg with validation DECLARE v_user_name […]

/by
, , , , , , , , ,

Use Of Pricing API (QP_PRICE_LIST_PUB.Process_Price_List)

Oracle Pricing provides the ability to allow for the import of large volumes of Price List data into the Pricing Tables. The following two methods may be used to populate the price list. A) QP: Bulk Import of Price List B) Pricing API (QP_PRICE_LIST_PUB.Process_Price_List). Price List Setup API.(QP_PRICE_LIST_PUB.Process_Price_List):=================================================The Price List Setup package consists of entities […]

/by
, , , , , , , , , ,

Consigned POs not getting converted with the consigned flag checked through PDOI & Coming to the base tables with Incomplete Status

While trying to import the Consigned Purchase Orders using Standard Purchase Order Import Process, the Consigned Flag is not updated to Yes in the Purchase Order Shipment due to which the PO is coming to the system in INCOMPLETE status rather than APPROVED status. If we will try to approve the PO in the form […]

/by