For Example Display the sub total values based on Account code and show grand total end of the report. The report has only one group (G_ACCT) and group columns like …
Read MoreRequirement : Enable ‘Execure-Query’ using an LOV field (non-database items) . Approach: When user clicks on CTRL+F11 we need set dynamic where clause. Normally for database fields Oracle standard feature…
Read MoreIn some cases, we get a comma separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…
Read MoreWe can change the LOV query using form personalization. Sample provided below (Payment form). Requirement: We have to change the “type” field lov query for populating the custom values. To…
Read MoreSolution : This blog explains the technical approach for creating an automated interface to accept user supplied material transactions from External Systems and to import these transactions to Oracle as…
Read MoreSolution : URL will be passed as parameter where we can identify the currency rate conversion amount. FROM_CURRENCY , TO_CURRENCY and the date for when it has to be run…
Read MoreDefinition: Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system…
Read MoreMANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2 Concept: Once the pick release and pick confirm process is over, the details will be assigned to deliveries. Deliveries will…
Read MoreCreating a Dynamic table region and attaching the VO to this dynamic Table region in ProcessFormRequest method of controller. Consider the requirement, If user selects “U” then it should create…
Read MoreQuery to find Runtime, Status and Argument of a Concurrent Request SELECT fcp.user_concurrent_program_name, fcr.requested_by, fcr.request_id, fcr.request_date, fcr.phase_code, fcr.status_code,fcr.requested_start_date, fcr.actual_start_date,fcr.actual_completion_date, ROUND((nvl(fcr.actual_completion_date,sysdate) –fcr.actual_start_date) * 1440, 2) “Runtime (in…
Read More