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
I’m speaking at Oracle Groundbreakers EMEA Virtual Tour. Please join me for a virtual session “Empowering Oracle EBS with Enterprise Command Centers Dashboards” on Oct’13th, 2020 at 3.00 PM CEST (8.00 am CST). Please register for the session at registration link for free. Oracle ACEs will be presenting on Cloud, Database, Analytics/Data Science, Oracle EBS, … Read more
Oracle Applications and Technology Conference in Las Vegas – OATUG Forum Live Join OATUG’s first hybrid event this winter! OATUG Forum Live will deliver education and insights for the Oracle community this Dec. 6-9. Participate in-person in dazzling Las Vegas or via the Virtual Experience — whatever you choose, there’s great Oracle education and networking … Read more