Posts by Siva Chandaran

Query to display the PO delta extract

Introduction: This query will display the PO details(Delta extract) select prha.attribute1 triprojectnumbertx, –project_number, poh.segment1 cstPONumberTX, –po_number, cstPOUniqueKeyTX prla.attribute4 cstCostCodeIDTX, — Added this as per the latest Cost code change request.…

Read More

Error : failError!! Could not deliver the output for Delivery channel:null

Introduction: Error : failError!! Could not deliver the output for Delivery channel:null On : 12.1.3 version, XML Publisher Report Bursting Program is getting Error Out   CAUSE : Bursting control…

Read More

Query to get the OAC fields for the customers

Introduction: This query is about to get the advance collections related columns for the customers. SELECT HCA.CUST_ACCOUNT_ID, IST.STATUS_CODE STRATEGY_STATUS, ISTT.STRATEGY_NAME, (SELECT ISWI.STATUS_CODE FROM IEX_STRATEGY_WORK_ITEMS ISWI WHERE ISWI.STATUS_CODE IN(‘OPEN’,’PRE-WAIT’) AND ISWI.STRATEGY_ID=IST.STRATEGY_ID…

Read More

Query to find Supplier report with payment method changed date

Introduction: This report will showing all Oracle US and Canada suppliers with payment type of XXX   select AP_SUP.SEGMENT1 SUPPLIER_NUMBER ,AP_SUP.VENDOR_NAME SUPPLIER_NAME ,SUP_SITES.VENDOR_SITE_CODE SUPPLIER_SITE ,(select APT.NAME from apps.AP_TERMS_TL APT where…

Read More

iExpense audit SLA report

Introduction This report is about to find the expense details and time taken to complete the audit. SELECT A.Report_Number, A.Employee_Name, A.Emp_Number, A.Operating_Unit, A.Amount, A.Currency, A.Last_Audited_By, A.Report_submit_date, TO_CHAR(A.Claim_Approved_Date,’DD-MON-YYYY HH24:MI:SS’) Claim_Approved_Date, TO_CHAR(A.Pending_Your_Resolution_Date,’DD-MON-YYYY…

Read More