ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEE779D2E0530100007F1FF2 ONT Order Number Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc Fixed bug in operating unit access restriction when the default operating unit is set to something else US A7A5AF417ED10425E053B46B6358F60D SELECT fu.user_name, opmt.*,opm.* FROM oe_processing_msgs opm, oe_processing_msgs_tl opmt, fnd_user fu WHERE 1=1 and opm.transaction_id = opmt.transaction_id and opm.created_by=fu.created_by Y US ONT Order Processing Errors During a Sales Order Creation scenario, when data is inserted into Interface table – sometimes Orders can fail to get created due to issues in the Interface table. The corresponding error information is stored in the oe_processing_msgs_tl table. original_sys_document_ref contains the order number Schedule this query to find out error messages in the Order Interface table is: SELECT * FROM oe_headers_iface_all WHERE order_number = '123456'; SELECT * FROM oe_lines_iface_all WHERE orig_sys_document_ref = (SELECT orig_sys_document_ref FROM oe_headers_iface_all WHERE order_number = '123456'); 1=1 1 10 1=1 opm.original_sys_document_ref =:order_number LOV ONT Order Number 8E2FF36EDEE779D2E0530100007F1FF2 Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc US Order Number 2 20 1=1 type=:error LOV custom Y select distinct opm.type value, null description from oe_processing_msgs opm ERROR US Type 3 30 1=1 opmt.message_text=:message_text LOV custom Y select distinct opmt.message_text value, null description from oe_processing_msgs_tl opmt Ship To is required on a booked order. US Message Text B9FDBD6D5933A23703A34824DA9196AC Proc-Errors DEVELOPER 2 ATTRIBUTE_CODE 3 CREATED_BY 4 CREATION_DATE 11 ENTITY_CODE 6 MESSAGE_SOURCE_CODE 9 MESSAGE_STATUS_CODE 8 MESSAGE_TEXT 10 ORIGINAL_SYS_DOCUMENT_LINE_REF 1 ORIGINAL_SYS_DOCUMENT_REF 7 ORIG_SYS_SHIPMENT_REF 5 TYPE S Site