Steps to start/stop Workflow Notification Mailer Check workflow mailer service current status SQL> select running_processes from fnd_concurrent_queues where concurrent_queue_name = ‘WFMLRSVC’; RUNNING_PROCESSES —————– 1 Number of…
Read MoreSyntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreSyntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreBy using below script we can perform ddl statement in Application Module. public void OTCancel() { OnetimeVOImpl delvo = getOnetimeVO1(); Row row[] = delvo.getAllRowsInRange(); OADBTransactionImpl oadbtransactionimpl = (OADBTransactionImpl)getDBTransaction(); for (int…
Read MoreINTRODUCTION: OEM13.4 is not monitoring all the Disks so we are unable to monitor the Disk alerts. SOLUTION: To fix this issue we need to change a parameter called EM_MONITOR_ALL_DISKS…
Read MoreIn this blog, you will find the SQL query to extract the Employee expense payments in Oracle apps R12.1.3 Query: select aps.vendor_name “Supplier”, aca.AMOUNT “Payment amount”, aca.currency_code “Currency”, aca.check_date “Payment…
Read MoreIntroduction This Query will help to Extract the Customer Wise Accrual Details in Trade Management in Oracle Apps. SQL Query: SELECT DECODE (qualifier_context, ‘CUSTOMER’, (SELECT b.party_name FROM hz_cust_accounts a, hz_parties…
Read MoreIntroduction This Query will help to Extract the Credit Memo Data in Oracle Apps. SQL Query: SELECT CASE rcta.interface_header_context WHEN ‘CLAIM’ THEN ‘TRADE MANAGEMENT’ WHEN ‘ORDER ENTRY’ THEN ‘Order Entry…
Read MoreIntroduction This Query will help to Fetch PO Receipt Details Data in Oracle Apps. SQL Query: SELECT pv.vendor_name, poh.ship_to_location, poh.bill_to_location, DECODE (plla.match_option, ‘P’, ‘PO’, ‘R’, ‘Receipt’, ”) line_status, UPPER (poh.status)…
Read More