Useful Oracle Workflow Meta link ID's

Issue Description
Oracle Metal ink Note id’s
Verifying the Connection of SMTP Server in Notification Mailer
 note.753845.1
Notifications With Embedded Framework Regions Are Not Mailed or Sent
ID 309856.1
Workflow Mailer Fails To Send Email Notifications With Framework Region
ID 747490.1
Not Receiving Workflow Email Notifications Possible Connection Refused Error 
ID 464016.1
Connection Refused Errors in Mailer Log After Applying ATG RUP4
ID 403431.1
Troubleshooting Inbound & Outbound Email Notifications
ID 1184846.1
Oracle Workflow Best Practices Release 12 and Release 11i
453137.1
Oracle Workflow Cartridge Workflow Java Mailer Setup Test
274764.1
Tracking Workflow Notification Event Messages
433359.1
Queries Related to Alert and Mailer Integration Post RUP4
456921.1
How to Stop mails from Workflow Notification Mailer
454706.
Workflow Mailer Configuration SSL Implementation [Video]
ID 1324799.1
Troubleshooting Inbound And Outbound Email Notifications
ID 1184846.1
 Unable To Start Workflow Notification Mailer
Note 418329.1
 Workflow Cannot Connect to IMAP Sever: "Unable to Make a
                    Network Connection"
Note 577592.1
Java Mailer not Starting Error in Handling Component Event
Note 297725.1
 Error Svc Component Container
Note 257723.1
How To Troubleshoot Java-based Workflow Notification Mailer 
Note 242941.1
Example Of Configuring Workflow Java Notification Mailer 
Note 249957.1
How To Configure The Workflow Java Mailer Without An IMAP Account (Assumes No Inbound Processing
Note 268274.1
How To Modify Workflow Message Bodies Due To Functionality Change in 11.5.10.2 And Above?
ID 377010.1






R12: How To create read only responsibility  
Note 1290228.1
How To Create a Query Only Responsibility In Applications 11i
Note 434797.1
How To Make All The Responsibilities Read Only For A User
Note 363298.1


Review WF dev guide for other APi's

docs.oracle.com/cd/B14099_19/integrate.1012/b12163/wfapi09.htm
docs.oracle.com/cd/B19306_01/workflow.102/b15855/T341351T341380.htm#T341423
docs.oracle.com/cd/B12037_01/workflow.101/b10284/defcom38.htm


Comments

Post a Comment

Popular posts from this blog

Queries For Oracle Interface Errors Records.

Below are the queries to get the error records information while processing interface data. AP Invoices:   SELECT    airl.last_update_date process_date,    HU.NAME,   nvl(ail.invoice_line_id,aii.invoice_id) process_id,   'AP' module,   'Import AP Invoice' interface_name,   aii.source source,   NVL(SUBSTR( ail.dist_code_concatenated,1,instr(ail.dist_code_concatenated,'.',1,1)-1),'ALL') company,   'ERROR' status,   ail.line_type_lookup_code ,   airl.parent_table ,   ail.description ,   NVL(ail.distribution_set_name,dist_code_concatenated) ,   pvsa.vendor_site_code ,   listagg(NVL(airl.reject_lookup_code,'AP_INV_ERROR') ,';') within group (order by NVL(airl.reject_lookup_code,'AP_INV_ERROR')) error_code,   listagg(flv.meaning,';')  within group (order by NVL(flv.meaning,'AP_INV_ERROR'))error_summary,   NULL error_details,   pv.vendor_name ,   pv.segment1 ,   aii.invoice_amount,   aii.i
Read more

Customising PO Output For Communication Report in Oracle Purchasing

Image
PO Print PDF Report: Oracle EBS provided  a standard functionality to print the PO report directly from the PO form itself by clicking tools menu and view PDF option. Once we select that option output will be rendered in PDF format in the browser instantly. Internally it will run the concurrent program 'PO Output For Communication'. This concurrent program is of JAVA type which will uses the seeded package  'PO_COMMUNICATION_PVT'  for generating the XML data and later this XML data will be processed and formatted by using the XSL template of data definition 'Standard Purchase Order Data Source' in case of standard PO's. Oracle by default will provide one standard BI publisher template for this. In case if we want to have custom layout for this report we can build a new template for the same data definition and this template has to be used while doing the setup for PO Document types. Creating Custom Template and Setup this for PO Document type: To c
Read more

Oracle APPS Useful Queries

                       ACCOUNT PAYABLES Payable Open Interface Rejection:   SELECT ail.* FROM AP_INVOICES_INTERFACE ai ,   ap_invoice_lines_interface ail ,   ap_interface_rejections AIR WHERE ai.GROUP_ID='EO_AUG-13_010813_443' AND ai.status    ='REJECTED' AND ai.invoice_id=ail.invoice_id   --and ail.dist_code_concatenated='66810-00-999-00000000-00000000-00000-FI100' AND air.parent_id = DECODE(air.parent_table,'AP_INVOICES_INTERFACE',AI.INVOICE_ID,'AP_INVOICE_LINES_INTERFACE',ail.invoice_line_id,NULL) ORDER BY 2; AP Invoices Query: /*+INDEX (AP_INVOICES_ALL [XXDG_TEST]) */ SELECT  apia.invoice_id,        alc.displayed_field "Invoice Type",        apia.invoice_num "Invoice Number",        apia.invoice_date "Invoice Date",        apia.gl_date   "Invoice GL Date",        nvl(apia.VOUCHER_NUM,doc_sequence_value)"Voucher Number",        apia.description inv_Description,  
Read more