Creating a Supplier in Oracle Fusion 24D
Creating a Supplier in Oracle Fusion Creating a supplier in Oracle Fusion involves several key steps to ensure accurate setup and integration within your procurement processes. Here’s…
Read MoreQuery to get Invoice,value of invoice and cash collected details:
Introduction: This query will fetch you the below data.1) Total Number of invoices2) Total value of invoices (USD)3) Cash collected (USD)The input parameter passed is from date and to date.…
Read MoreNon-PO invoice report in Cloud
Introduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the Non-PO…
Read MoreQuery to get the tax type and tax accounts details.
SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_recovery_ccid) interim_recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=recovery_ccid) recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_liability_ccid) interim_liability_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=liability_ccid) liability_ccid FROM apps.jai_tax_types_v tv, apps.jai_tax_accounts…
Read MoreQuery to get ship to and Dist location mismatch invoices details.
select distinct hou.name, a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_code from apps.ap_invoices_all a, apps.ap_invoice_lines_all b, apps.ap_invoice_distributions_all c, apps.gl_code_combinations d, apps.hr_operating_units hou, apps.ap_suppliers aps,…
Read MoreAP Open invoice extract in EBS
Introduction: This script will extract the AP open invoices select 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,…
Read MoreLower Deduction Cost
Lower Deduction Cost Details Introduction: This report will provide LDC details. Cause of the issue: To get the remaining amount pan wise. How do we solve: So, extract the LDC…
Read MoreSupplier Contact Details
Supplier Contact Details Introduction: This report will provide active supplier contact details. Cause of the issue: To apply TDS tax deduction against open invoice. How do we solve: So, extract…
Read MoreOracle R12 Internal Bank Account Query
SELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbv.address_line1,…
Read MoreAP Web Report Workflow Status
SELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_date)) days_old, NULL timeout_date, NULL manager_level, TO_CHAR (h.report_header_id) report_header_id, h.invoice_num invoice_num, h.description description, p.full_name requestor,…
Read More