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

Oracle Groundbreakers APAC Virtual Tour 2020

by

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

Oracle Groundbreakers EMEA Virtual Tour

by

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