Navigation: System Administrator ? Security ? Responsibility ? Define Enter the details Responsibility Name: IM CO AP Period End Application: Payables Responibility_key: IM_CO_AP_PERIOD_END Description: IM CO AP Period…
Read MoreThe 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 MoreOverview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process…
Read MoreIntroduction: 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 MoreUser was unable to apply the 6 receipt to the invoices for UK and they were getting the below error , “Error message: FRM-40654: Record has been updated .Requery block…
Read Morebusiness noticed that the receipt application is missing and the missed transaction level balance is not updated .. means transaction is not applied any receipt but it is showing ZERO…
Read MoreEnviroment Details Primary Standby DB SID INDIA INDIA DB ROLE Primary Physical Standby DB Unique Name INDIA CHINA Server IP 192.168.25.159 192.168.25.158 DB Version 19.2.00 19.2.00 OS Oel7 Oel7 Switchover…
Read More1. Overview This document explains how to set dialogue page title dynamically. 2. Technologies and Tools Used The following technologies have been used to set page title dynamically. Oracle Apex JavaScript 3. Use…
Read MoreGST Query for Payables SELECT jeh.period_name period_name, gll.NAME ledger_name, a.concatenated_segments accounting_string, jeh.doc_sequence_value doc_num, gstl.user_je_source_name je_source, gctl.user_je_category_name je_category, jeb.NAME batch_name, jeb.description batch_desc, jeh.NAME je_name, jeh.description je_desc, jel.description line_desc, NULL h_desc,…
Read MoreUTL file for AR invoice Outbound to EBS CREATE OR REPLACE PROCEDURE APPS.xx_mintifi_sales_inv_ext ( p_from_date IN DATE, p_to_date IN DATE, p_org_id IN NUMBER ) AS x_id UTL_FILE.file_type; x_file…
Read More