Step 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 MoreNo matter how advanced a business gets, the integrated technology that supports it keeps on changing. But the thing that remains constant is the need to keep confidential information safe.…
Read MoreOracle Time and Labor (OTL) – Time Entries Creation Using REST API When we have a requirement to integrate Oracle Time and Labor with external clocks of employee IN/OUT…
Read MoreIntroduction: This script will extract the accounting rule and trx source wise invoice counts. SELECT C.NAME RULE_NAME, D.NAME SOURCE_NAME, count(A.TRX_NUMBER), DECODE(A.ORG_ID,’XX’,’IM US OU’,’XXX’,’IM CANADA OU’) OU_NAME FROM RA_CUSTOMER_TRX_ALL A ,…
Read More