EBS

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

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

Order processing in certain scenarios requires to deliver available quantity and cancel the remaining quantity and unshipped lines instead of creating the back order. This is very common requirement from some customers to send a single shipment for their orders. Currently there is no way to setup this in Oracle EBS R12.2.8 or prior versions, … Read more

Prior to Oracle EBS R12.2.9, Item’s Primary Unit Of Measure(UOM) can be selected only at the time of item creation and cannot be updated once the item is saved. There is a new feature added in Oracle EBS 12.2.9 latest version, where it is allowed change item’s primary UOM after the item is created When … Read more