SELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreHow to Change MTU Size in Exadata Environment Issue: Having a larger value for MTU such as 65520 bytes = 64kb will require more memory pages to support IPoIB, the…
Read MoreSteps 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 More