Cause: 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 MoreIntroduction. This API will used to adjust the Fixed asset details like life_in_months and etc. declare l_trans_rec FA_API_TYPES.trans_rec_type; l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type; l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type; l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; l_inv_tbl FA_API_TYPES.inv_tbl_type;…
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 MoreDescription Below script is used to check the printer, IP status and testing the printer. Script : #!/bin/bash con() { if [ $choice -eq 1 ] then echo “Give ip…
Read MoreIntroduction: This scripts will used to extract the customer bank information in fusion. SELECT IBY_EBA.*,hp.party_name, CA.ACCOUNT_NUMBER, cbb.bank_branch_name Branch_name FROM hz_cust_accounts ca, hz_parties hp, iby_external_payers_all IBY_PAYEE, iby_pmt_instr_uses_all IBY_PAYEE_USES ,…
Read More