Venkanna Mittakanti

iSupplier Portal Active Users List SQL

by

Business has a common requirement to get supplier accounts using iSupplier Portal. Below is the SQL to get iSupplier Portal Active Users. This is needed from procurement and Oracle licensing prospective. SELECT hou.name Operating_Unit,pv.segment1 Supplier_Number, pv.vendor_name Supplier_Name, pvs.vendor_site_code Supplier_Site,fu.user_name Supplier_UserName, fu.EMAIL_ADDRESS Supplier_Email,fu.end_date User_Effective_End_DateFROM apps.AK_WEB_USER_SEC_ATTR_VALUES attr, apps.fnd_user fu, apps.ap_suppliers pv, apps.ap_supplier_sites_all pvs, apps.hr_operating_units houWHERE attr.attribute_code = … Read more

Categories EBS

Oracle Fusion Pricing Cloud – Price List Export SQL

by

Here is another SQL Which I extensively used to validate the price list conversions in the OM Cloud implementations and getting the price list(s) export from the Fusion SCM Applications. SELECT qplt.name “Price List”,qplt.price_list_type_code,qplt.currency_code Currency,qplt.start_date,qplt.end_date,qplt.description,qplt.org_id Business_Unit_ID,qplt.status_code Status,— qpli.price_list_item_id, qpli.price_list_id,qpli.item_level_code,(SELECT item_number FROM fusion.egp_system_items esi WHERE esi.inventory_item_id = qpli.item_id AND esi.organization_id=300000007099064) “Item”, — Master Org Id(SELECT unit_of_measure … Read more

Oracle Fusion Order Mgmt Cloud – SQL Script to get the Sales Orders export

by

Below is the SQL to get sales order export from Fusion Apps Order Mgmt Cloud. Please use Oracle Transaction Business Intelligence (OTBI) Data model (SQL) and Report to create the report. I have used the script extensively to validated the converted Sales Orders. SELECT (SELECT name FROM fusion.hr_operating_units where organization_id = h.org_id) BU_NAME,h.order_number,h.SOURCE_REVISION_NUMBER revision_NUM, — … Read more

Speaking live at Ascend 2021 – August 15-18, 2021

by

Ascend 2021: Elevating Insights for the Oracle CommunityAugust 15-18, 2021The Diplomat Beach ResortHollywood, FLStreaming Worldwide#Ascend2021 I’m speaking live at OATUG ASCEND 2021. Please join me there. Session# Account Receivables eInvoicing SolutionDate: Monday 08/18/2021 at 10.00 AM – 11.00 AM EDT Session# Overview of Oracle EBS Enterprise Command Centers and Procurement Command Center DashboardsDate: Wednesday, 08/18/2021 … Read more

ODTUG Kscope21 Virtual Event – June’21 to July’1

by

The ODTUG Kscope21 Virtual Event features presentations across a variety of technical content topics, including Oracle Database, Oracle Application Express, Oracle EPM-Hyperion, Oracle Analytics and Emerging Technologies, just to name a few. I will be presenting “Emerging Technologies – Overview of Robotics Process Automation and it’s use case in Oracle EBS” virtual session on Thursday … Read more

Oracle EBS – Application User Maintenance SQL Scripts

by

Here are the SQL Scripts to create application user, reset application user’s password and adding responsibility thru SQL Plus / Toad / SQL Developer. Connect as APPS to execute the scripts. Creating application user — creating application userDECLAREl_user_name VARCHAR2(100) := UPPER(‘VMITTAKANTI‘); — Usernamel_password VARCHAR2(30) := ‘Welcome1‘; — Passwordl_session_id INTEGER := USERENV(‘sessionid’);BEGINfnd_user_pkg.createuser (x_user_name => l_user_name,x_owner => … Read more

R12.2.10 – Country of Origin for On-hand Inventory

by

Most of the businesses have a requirement to capture Country Of Origin (COO) while receiving the goods and track the item’s on-hand by Country of Origin. This functionality isn’t available with Oracle EBS R12.2.9 & lower versions including EBS R12.1. Unfortunately there is no good custom solution also to implement this type of business requirement. … Read more

Categories EBS