Venkanna Mittakanti Here is the SQL script to get all the open Purchase Orders info, including PO Lines & Shipment info. The script has been used extensively to provide Open POs info to the business & Corporate, especially for data cleansing and data migration purposes when we migrated our ERP system from Oracle EBS to SAP. SELECT … Read more
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
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
Join Spain Oracle Users Group SPOUG22 Convention for 2 days of Oracle sessions on June’2nd & 3rd,2022. I’m speaking at SPOUG22 Convention. Please join me for the below virtual sessions. Overview of Oracle EBS Enterprise Command Centers and Procurement Command Center Dashboards on June 3,2022 at 12.00 PM CEST Emerging Technologies – Overview of RPA … Read more
Join the Dallas Oracle Users Group (DOUG) for a full day of Oracle sessions on Thursday, October 7th,2021 from 8.00 am to 6.00 PM. I will be presenting “AR Invoice Print solution using Bill Presentment Architecture and Minimizing tech customizations” at 11.00 am.
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
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
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
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
The Oracle Groundbreakers APAC Groundbreakers Tour will be virtual this year with presentations on Cloud, Database, Java, Applications, Hands-on Labs and more. The event will be held from October 19-30, 2020. Registration and agenda are live I will present two sessions for the event. Emerging Technologies – Overview of Robotics Process Automation and it’s use … Read more