Oracle racl e Pro Process cess Manufact nu factur urin ing g (OPM) Day, Date, Wednesday, Nov.2004 16, 2011 timET e p.m. ETMT 11:00 AM / 09:00 T Teleconference eleconference Acc Acc ess: ess: North America: Conference ID:xxxx International: 18539322 or xxxx Oracle OPM Password: Advisor
North America: (866) 627-3315
International:
Upcoming OP OPM M Commu Community nity Webca ebcasts sts:: December 14, 2011: EBS Upgrade Advisor and EBS Patching & Maintenance Advisor Overview (Doc ID 1064676.1) December 21, 2011: High Level Comparison of OPM Financials R12 to 11.5.10.2 (Doc ID 1064676.1) January Jan uary 18, 201 2011 1: Patch Wizard Overview (Doc ID 1064676.1) For complete details OPM Webcast Events, please see Note 1064676.1.
+1-706-758-7972
For complete details on All Other upcoming Oracle Advisor Webcast Events, please Note 398884.1.
Other Global Toll Free:
Do you have any requests for future Advisor Webcast Events? Please email your suggestions to
[email protected], subject: Topics of Interest.
Doc ID: 1148600.1
Oracle racl e Pro Process cess Manufact nu factur urin ing g (OPM) Day, Date, Wednesday, Nov.2004 16, 2011 timET e p.m. ETMT 11:00 AM / 09:00 T Teleconference eleconference Acc Acc ess: ess: North America: Conference ID:xxxx International: 18539322 or xxxx Oracle OPM Password: Advisor
North America: (866) 627-3315
International:
Upcoming OP OPM M Commu Community nity Webca ebcasts sts:: December 14, 2011: EBS Upgrade Advisor and EBS Patching & Maintenance Advisor Overview (Doc ID 1064676.1) December 21, 2011: High Level Comparison of OPM Financials R12 to 11.5.10.2 (Doc ID 1064676.1) January Jan uary 18, 201 2011 1: Patch Wizard Overview (Doc ID 1064676.1) For complete details OPM Webcast Events, please see Note 1064676.1.
+1-706-758-7972
For complete details on All Other upcoming Oracle Advisor Webcast Events, please Note 398884.1.
Other Global Toll Free:
Do you have any requests for future Advisor Webcast Events? Please email your suggestions to
[email protected], subject: Topics of Interest.
Doc ID: 1148600.1
OPM OPM Work Workflow flow s: Gettin Gettin g Workfl ows To Work Using event event oracle. or acle.apps.gml apps.gml .po.receipt .po.receipt.crea .created ted As An Example Jonathan Corker Principal Technical Support Engineer
Saf e Ha Har b o r St at em en t The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
OPM Workflow s: Gettin g Workflows To Work Using event oracle.apps.gml .po.receipt.created As An Example Jonathan Corker Principal Technical Support Engineer
Agenda
• Enabling and subscribing to the event • Creating Specification and Validity Rule • Creating and Testing the Approval details (if required) • Creating the PO & Receipt • Running the Workflow Agent Listener • Finding the Notification • Some ‘Tech’ stuff
Please refer to note 337345.1 Essentially this presentation is contents of this note but ‘with pictures’
Enable and Subscribe to the Event
WORKFLOW EVENT DETAIL
IS THE EVENT SUBSCRIBED TO? select e.name,e.status event_status,s.status subscription_status ,nvl(s.PHASE,0) SUBSCRIPTION_PHASE ,s.LICENSED_FLAG subscription_LICENSED_FLAG ,e.LICENSED_FLAG event_LICENSED_FLAG from wf_events e ,WF_EVENT_SUBSCRIPTIONS S where e.name like '%oracle.apps.gml.po.receipt%' AND S.EVENT_FILTER_GUID = E.GUID
SPECIFICATION
VALIDITY RULE
APPROVAL
Approval Attributes
ITEM ATTRIBUTE
APPROVAL CONDITION
APPROVER GROUP
APPROVER GROUP DETAILS
Note the Approver i.e. the person to whom the Notification will be sent
TEST THE APPROVAL
Enter the Transaction_id from rcv_transactions
TEST THE APPROVAL (CONT)
TEST THE APPROVAL (CONT)
PURCHASE ORDER
RECEIPT
RUN WORKFLOW AGENT LISTENER
EXPECT TO SEE NOTIFICATION AT THIS POINT
Use for example Navigation Path Workflow>Self Service Workflow>Notifications
NO NOTIFICATION – WHY? We appear to have done everything correctly i.e. •Ensured the Event was enabled and subscribed to •Created a valid Specification and Validity Rule •Created an Approval Process •Created a Receipt •Ran the Workflow Agent Listener
TO INVESTIGATE Log in as Sysadmin Navigation Path System Administrator>Administer Workflow>Status Monitor Enter the Workflow type e.g. OPM Quality Management Sample Creation Or Internal Name e.g. GMDQMSMC Search for the ones in error
WORKFLOW DETAILS
ERROR DETAILS
WORKFLOW DIAGRAM
FIX THE ERROR Fixed the error using note ‘‘Oracle HRMS AME Error "Oracle Approvals Management has found parallelization configuration...’ (Doc ID 338508.1)
NEW RECEIPT USING SAME DETAILS Created new Receipt 17927 for the same item, supplier etc Ran Workflow Agent Listener, and…
NOTIFICATION TO TAKE SAMPLE
NOTIFICATION DETAILS
SPECIFICATION FOR INVENTORY CREATION
DIFFERENT WORKFLOW TYPE
NOTICE TWO SAMPLES FOR SAME RECIPT
Notice two Notifications Sample Required for Receiving into Inventory transaction: Organization PR1 Item JGC_SAMPLE_TEST Lot JGC_1 oracle.apps.gmi.inventory.created Item Key 48446123-0-5277300 i.e. first value is transaction_id from mtl_material_transactions Sample Required for Receiving transaction: Organization PR1 Item JGC_SAMPLE_TEST oracle.apps.gml.po.receipt.created
Package Name GMD_QMSMC (GMDQMSMB.pls) Deals with the events 'oracle.apps.gmi.inventory.created' 'oracle.apps.gmi.lotexpirydate.update' 'oracle.apps.gmd.lotretest' 'oracle.apps.gmi.lotretestdate.update' 'oracle.apps.gml.po.receipt.created' 'oracle.apps.gmi.inv.po.receipt' 'oracle.apps.gme.batch.created' 'oracle.apps.gme.bstep.rel.wf'
select distinct s.item_type,s.item_key,s.begin_date,s.ACTIVITY_STATUS , wiav.name attr_name, wia.type value_type, nvl(wiav.text_value , nvl(to_char(wiav.number_value),to_char(wiav.date_value,'DDMON-YYYY hh24:mi:ss'))) value from
wf_item_attribute_values wiav,
wf_item_attributes wia,
wf_item_activity_statuses s where wiav.item_type Like 'GM%' and wiav.item_key = s.item_key and wiav.item_type = s.item_type and wia.item_type(+) = wiav.item_type and wiav.name and wia.type(+) <> 'EVENT'
wia.name(+)
and s.begin_date >='01-SEP-2011' and wiav.text_value='oracle.apps.gml.po.receipt.created' order by s.begin_date /
=
set serveroutput on declare v_itemtype
VARCHAR2(20) :='GMDQMSMC';
v_itemkey
VARCHAR2(20) :='48959419-0-5277858';
V_actid
NUMBER;
V_funcmode V_resultout
VARCHAR2(10); VARCHAR2(100);
begin GMD_QMSMC.VERIFY_EVENT (v_itemtype ,v_itemkey ,V_actid ,V_funcmode ,V_resultout); end; /
•
To ask a question on the phone line, select *1 on your phone.
•
To ask a question online, use the Q&A area.
•
Your question will be read aloud in the order received.
•
Question can also be asked on the My Oracle Support Communities
Visit My Oracle Communities Collaborate with a large network of your industry peers, support professionals, and Oracle experts to exchange information, ask questions & get answers. Find out how your peers are using Oracle technologies and services to better meet their support and business needs. •
Exchange Knowledge
•
Resolve Issues
•
Gain Expertise
Visit the My Oracle Suppor t Community now!!
1.
Log into My Oracle Support.
2.
Select the Community tab.
3.
Select the Enter Here button.
4.
Select the Community Name link under the E-Business Suite section of the My Communities Menu on the left side of the window.
© 2011 Oracle Corporation – Proprietary and Confidential
43
OPM Advisor Webcast Calendar and Archive (Doc Id 1064676.1)
© 2011 Oracle Corporation – Proprietary and Confidential
44
Receive Email Webcast Invites • Would you like to receive email invites for future Advisor Webcasts? • Answer “Yes” to receive information the next time you register for a live webcast or webcast recording. • You can unsubscribe at any time by replying to the invite with “unsubscribe” in the subject line.
Advisor Webcast Assessment • Your feedback is a valuable part of ensuring the Advisor Webcast program continues to meet your needs. • Assist Oracle with the consistent delivery of quality webcasts, and to help identify opportunities for improvement. • Please take a moment to complete the Advisor Webcast Assessment , which will be emailed to you in the next week. • Your feedback is greatly appreciated. • You may also contact me directly at [email protected].
THANK YOU
