SQL to Find Employee – Supervisor Hierarchy details
Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…
Read MoreQuery for finding MTD/YTD/ITD Cost/Revenue and Fee Details for a Project in PA Module
WITH PARAMETER AS (SELECT :PERIOD_NAME AS PERIOD_NAME FROM DUAL) SELECT distinct prj.project_id,prj.segment1, (SELECT ROUND(SUM(tot_burdened_cost),2) FROM apps.pa_txn_accum WHERE project_id=prj.project_id AND gl_period =PARAMETER.PERIOD_NAME — and…
Read MoreGL Transactions for Payments
SELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHAR (aca.check_date) invoice_date, …
Read MoreGL Transactions for AR
SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl.line_number) ponum_inv_linenum, rcl.description line_desc, TO_CHAR (rcl.quantity_invoiced) requestor_qty_inv, TO_CHAR…
Read MoreGL Transactions for AR Adjustments
SELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_customer_trx_all WHERE customer_trx_id = aaa.customer_trx_id) invoice_date, …
Read MoreGL Transactions for AP
SELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type, ent.transaction_number invoice_num, TO_CHAR (aia.invoice_date) invoice_date, TO_CHAR (pod.po_number) ponum_inv_linenum, …
Read MoreExtract for Payments – Check and EFT
SELECT papf.employee_number employee_number , aps.vendor_name payee_name , ieba.bank_account_num bank_account_number ,…
Read MoreSteps to Create Excel for Apps Report
GL Wand needs no desktop installation and it is very user friendly for creating many financial reports. It is a very good reporting tool for Oracle E-Business suite. Pre-Requisites :…
Read MoreERROR ORA -00980 Synonym Translation no longer valid
Error Message : ORA -00980 Synonym Translation no longer Valid. Error Area : it is related Database (Table/view) not related to forms When it happens : Synonym is in inconsistent…
Read MoreOATS Installation issue – Struck/Hang for Long Time
Installation Issue : ‘ Spawning C:OracleATSbindeploy.bat C:OracleATSinstalloats.ear’ and never completes for Long Time ( even for Days) When it Happen : While Installing OATS Software Action Needs to Taken…
Read More