ERROR: Concurrent program error-ed out with below error, Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimited” before starting Java again…
Read MoreRecently I have faced below error, while running FNDCPASS for changing apps password. ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) does not…
Read MoreEnable & Disable ADDM reports in Pluggable Database Oracle you can configure ADDM reports for Pluggable database(PDBs). By default it is disabled. You need to enable it manually by executing…
Read MoreStep by Step installation of 19c Grid software, 1. Download the 19c Grid software from ORACLE, https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html 2. Copy Grid sofwatare to Grid home mkdir -p /u01/oracle/product/19.3.0.0/grid unzip the…
Read MoreCause: After installing grid,i cant start asm resource [oracle@dbadb01 ~]$ srvctl start asm PRCR-1001 : Resource ora.asm does not exist Check the resource status [oracle@dbadb01 ~]$ crsctl stat res -t…
Read More1. Overview This document talks about finding duplicate values in the Interactive Grid using PLSQL. 2. Technologies and Tools Used The following technologies have been used to achieve this functionality, PLSQL JavaScript 3. Use Case In my last post, I discussed finding duplicates values in the IG using JavaScript and…
Read More1.CREATE TABLE FOR THE FILES create global temporary table FILE_NAME ( filename varchar2(255) ) 2.CREATE JAVA SOURCE. This java is used to read the file from directory and insert the…
Read Moreselect gl.name ledgername, gjb.name “Journal Batch Name”, gjh.name “Journal Name”, gjh.je_source “Journal Source”, gjh.je_category “Journal Category Name”, gcc.concatenated_segments accountdisplayvalue, SUM(NVL(GJL.ACCOUNTED_DR,0)) DebitAmount, SUM(NVL(GJL.ACCOUNTED_CR,0)) CreditAmount, SUM(NVL(GJL.ACCOUNTED_DR,0)-NVL(GJL.ACCOUNTED_CR,0)) BALANCE, gl.currency_code currencycode,gjh.posted_date transdate,gjh.default_effective_Date,gjh.period_name from gl_je_headers…
Read Moreselect aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments distributed_code_combinations, aca.check_number, aipa.amount payment_amount, apsa.amount_remaining, aipa.invoice_payment_type, hou.name operating_unit, gl.name ledger_name…
Read MoreTo check weblogic version From registry.xml from Middleware_Home Go to Middleware_Home under which weblogic is installed and look for a file registry.xml Default path should look like something below /usr/local/oracle/middleware/Oracle_Home/Inventory…
Read More