Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Go to reports path Then type: – string -a APXAPRVL.rdf|grep Header Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Version sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/…
Read More— — Displays Last Analyzed Details for a given Schema. (All schema owners if ‘ALL’ specified). — SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60…
Read MoreSimply installing Java 1.5 from Sun is the easiest way to get the newest Java and Java Web Start. Windows: To get 1.5, go to the Java 1.5 website. Just go through the install…
Read MoreBelow is the query to extract Payroll data from General Ledger, historical data for a week. select gjl.je_line_num, gcc.concatenated_segments, nvl(gjl.entered_dr,0) entered_debit,nvl(gjl.entered_cr,0) entered_credit,gjl.description from gl_je_lines gjl,gl_code_combinations_kfv gcc, gl_je_headers gjh,gl_je_sources gs,gl_je_categories gc…
Read MoreIssue : OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED, Observation : – Took a complete database backup – Used the…
Read MoreIssue : OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB SYMPTOMS : Create new DB System from backup fails during Recreate Controlfile script execution. Reason :…
Read MoreIssue : OCI Restore failure during Tempfile Creation Trying to create a new DB System from backup in OCI. Restore fails during “Re-Create Control File” step: Cause for the issue…
Read MoreIssue : Got the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB Error : ERROR at line 1: ORA-20401: Authorization failed for…
Read Moreselect (SELECT hou.NAME FROM apps.hr_operating_units hou WHERE 1 = 1 AND hou.organization_id = aps.org_id) ou_name, (SELECT paym.payment_method_code FROM APPS.iby_ext_party_pmt_mthds paym WHERE IEPA.ext_payee_id = paym.ext_pmt_party_id and aps.vendor_site_id = iepa.supplier_site_id –AND ass.supplier_site_id…
Read Moreselect aia.INVOICE_NUM ,aba.batch_name ,aia.INVOICE_AMOUNT ,aia.PAY_GROUP_LOOKUP_CODE INv_group ,aia.INVOICE_CURRENCY_CODE ,aia.CREATION_DATE ,To_char(aia.creation_date,’MONTH’) InvCreation_Month ,aia.INVOICE_DATE ,aia.SOURCE ,aia.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE ,PAYMENT_METHOD_CODE INVOICE_PAY_METHOD ,aia.amount_paid amount_paid ,aia.description ,aia.doc_sequence_value VOUCHER_NUM ,(select max(aila.ACCOUNTING_DATE) from apps.ap_invoice_lines_all aila where aila.invoice_id = aia.invoice_id…
Read More