When we implement Oracle Fusion ERP/SCM Cloud applications, we will be converting only open purchase orders (POs) that have not yet been received in the legacy system. We won’t be converting closed or closed-for-receiving POs in general. We will also be performing an on-hand conversion to bring inventory/stock from the legacy system into Oracle Fusion … Read more
Manufacturer Part Numbers (MPNs) are used to uniquely identify parts from specific manufacturers, distinguishing them from internal item numbers. You can use this information for reporting purposes, communicating with the manufacturers using their own part numbers and and in catalog searches for particular items. We can create a manufacturer part, then assign it to an … Read more
Use the below SQL to list Level1 Components/Sub-Assemblies for the Assembly. select a.segment1 COMP_Item, a.description Comp_Descr, a.inventory_item_status_code Comp_Status, a.item_type,d.segment1 ASSY_ITEM, d.description Assy_Descr, d.inventory_item_status_code Assy_Statusfrom mtl_system_items_b a,bom_components_b b,bom_structures_b c,mtl_system_items_b dwhere 1 = 1and a.inventory_item_id = b.component_item_idand a.organization_id = c.organization_idand b.disable_date is nulland b.bill_sequence_id = c.common_bill_sequence_idand d.inventory_item_id = c.assembly_item_idand d.organization_id = c.organization_idand d.segment1 = ‘SB68415’and d.organization_id = … Read more
Purchase Order or Requisition approvals are setup based on the Employee-Supervisor hierarchy or position hierarchy. Most of the companies use employee-supervisor hierarchy which is easier to setup. Approval Limits are assigned at the Job Level. The HR provides direction on the approval limits for each of the job, especially requisition approvals. Procurement decides approval limits … Read more
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
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 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
Oracle E-Business Suite 12.1 release will move into Oracle Sustaining Support in January 2022 and you will no longer receive new fixes, updates, or security patches. Release 12.1 premium support ends in Dec’2021. Sustaining Support poses a high risk for business-critical applications. Oracle and industry experts advise against running mission-critical applications on software that is … Read more
Some times you get the error message as “The record cannot be reserved for update. It has already been reserved by another user” or “Could not reserve record(2 tries). Keep trying?” While querying/updating the Purchase Order/Sales Order/any other transaction/setup screen in the Oracle EBS or Oracle DB related custom applications. Generally you get this message … Read more