Posts by Alam

Vendor Delivery Details

The below query gives the Vendor delivery performance details with po approval TAT and delivery TAT. SELECTpo_number,vendor_name,po_creation_date,po_approved_date,po_item_code,po_item_description,po_quantity,po_price,rate_type,exchange_rate_date,exchange_rate,po_line_amt,pr_to_po_creation_tat,po_creation_to_approval_tat,need_by_date,mrn_date,actual_material_receipt_date,mrn_tat,delivery_tatFROM(SELECT DISTINCTpoh.segment1 po_number,poh.creation_date po_creation_date,aps.vendor_name vendor_name,poh.approved_date po_approved_date,mtl.segment1 po_item_code,pol.po_line_id,pol.item_description po_item_description,pol.quantity po_quantity,pol.unit_price po_price,poh.rate_type,poh.rate_date exchange_rate_date,poh.rate exchange_rate,( pol.quantity *…

Read More

List of Suppliers which have not made payments since 2 years

Introduction: AP-query to get List of Suppliers which have not made payments since 2 years in Oracle EBS either invoice or payment. Query: select distinct a.vendor_id, b.ORG_ID, a.segment1 SUPPLIER_NUMBER, a.VENDOR_TYPE_LOOKUP_CODE…

Read More

Query to get loaded work structure (Grade) in Fusion HCM

Objective: Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have…

Read More

Query to get loaded work structure (organization) in Fusion HCM

Objective: Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have…

Read More

Query to get loaded work structure (Location) in Fusion HCM

Objective: Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have…

Read More

System variable to get current language by default in Oracle Fusion BIP report

Objective : Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc).  In Order to build such a report, you…

Read More

Resolve API error — (hz_cust_site_uses cannot be locked as it has been updated by another user)

Objective: Intent to publish this blog to get rid of this below common API Error while updating the Customer site uses. Error: hz_cust_site_uses cannot be locked as it has been…

Read More

Program to extend the customer sites into the multiple orgs.

Objective: The below code logic is used to extend the customer sites into the different org. (eg. Suppose customer sites exist in 82 org and the requirement is to extend…

Read More

Fixed Assets Invoice Cancel SQL script

Overview: This query is use to extract fixed assets invoices which is cancelled in Oracle Application R12. SELECT hou.name Org_Name, xep.name Entity, asp.segment1 Vendor_number, asp.vendor_name, assa.vendor_site_code, aia.doc_sequence_value voucher_number, aia.invoice_id Invoice_id,…

Read More

Script To Cancel Or Delete Work Confirmation In Oracle Apps R12

Overview: This Datafix script is used to delete the work confirmation and the associated receipt data. In this script it will reduce the amount/quantity delivered for the work confirmation in po…

Read More