Who we can get attachment functionality in custom Form R12.1.3

We can activate the attachment functionality in Custom Form or Seeded Form where attachment is not available.

Multiple Operating Unit setup in Oracle Apps Reports R12.1.3

Problem:
With the introduction of multi-org access control in release 12, an applications responsibility
can access multiple operating units. Some concurrent programs have been enhanced to process multiple operating units simultaneously, while for other requests the operating unit must be specified when you run the program. To support this, concurrent programs are defined with an operating unit mode of 'S' for single operating unit or 'M' for multiple operating units. If the 'Operating Unit Mode' is not set for the concurrent program it will fail.




This is described in (unpublished) Documentation Bug 5587132

Solution:
To support this, concurrent programs are defined with an operating unit mode of 'S' for single
operating unit or 'M' for multiple operating units. This mode is set automatically during
the upgrade to release 12.

However, if you have modified the definition for any concurrent programs, the upgrade will not set
this. This is done to preserve your customizations. Depending on how you run the customized
program, you may need to set this operating unit mode.
To do this, execute the following SQL to set a concurrent program to run for a single operating
unit:

UPDATE FND_CONCURRENT_PROGRAMS
SET MULTI_ORG_CATEGORY='S'
WHERE CONCURRENT_PROGRAM_NAME = ''


Enter 'M' instead of 'S' for multiple operating units.

If you want to know which setting is appropriate for a given program, you may
review the setting in the appropriate .ldt file.
Please note, however, that if you have customized the concurrent program definition,
this setting may not be appropriate given the way you use the program.



This can also be done via Applications User Interface:


1. Login into application with System Administration responsibility (NOT System
Administrator)
2. Navigate: Concurrent -> Programs
3. Query for short name of the concurrent program
4. Click on Update pencil icon of your program
5. Under 'Update Concurrent Program' region, select Request tab
6. Under 'Request Setting' region, select 'Single' from the drop down of 'Operating Unit
Mode' field
7. Save changes by clicking on 'Apply' button.

Purchase Order Workflow Notification is sending TEXT message not PDF.

Please Visit http://www.conacent.com/?page_id=218

Problem:

===========================================================================

Purchase Order Workflow Notification is sending TEXT message not PDF.

Solution:

In this case, you can change the users preference to MAILATTH which will allow for emails to be sent as - Plain text mail with HTML attachments.

Listed are the other possible option:

MAILTEXT = Plain text mail
MAILHTML = HTML mail with attachments
MAILHTM2 = HTML mail
MAILATTH = Plain text mail with HTML attachments
QUERY = Do not send me mail
SUMHTML = HTML summary mail
SUMMARY = Plain text summary mail
DISABLED = Disabled

Only for Single User :
1. Log in as User

2. Top right corner of homepage is the preferences link.

3. Select and make the change to the notification Email Style to Plain text mail with HTML attachments.

For All User :

1. One should backup these tables before performing the updates.

FND_USER_PREFERENCES and WF_LOCAL_ROLES

2. Update for All User following is the update statement.

a. UPDATE wf_local_roles SET notification_preference=’’

Where orig_system in (‘FND_USR’,’PER’);

b. UPDATE fnd_user_preferences SET preference_value=’’

Where preference_name = ‘MAILTYPE’ and module_name = ‘WF’ and user_name <> ‘-WF_DEFAULT-‘;

PO Output for Communication request Complete with Error

Please Visit http://www.conacent.com/?page_id=218



Problem Description :
=============================================================
genDoc() : Exceptionjava.lang.Exception: Error while generating PDF :APPLPTMP/xdoldCw8wPDTu072311_0353221610.fo (No such file or directory)java.lang.Exception: Error while generating PDF :APPLPTMP/xdoldCw8wPDTu072311_0353221610.fo (No such file or directory) rolling back the complete program

Solution :
================================================================
Navigate to Setup/Organizations/Purchasing Options/Document Control make sure the value in 'Output Format' = PDF

Navigate to Setup/Purchasing/Document Typechoose Standard Purchase Ordermake sure the value in 'Document Type Layout' = PO_STANDARD_XSLFO

Run the XML Publisher Template Re-Generator ProgramConnect to the XML Publisher Administrator responsibility, then run the "XML Publisher TemplateRe-generator" concurrent program with the parameter ALL .

Create a new Standard Purchase Order and see the PDF is successfully generated.

PO Output for Communication failed to produce PDF report

Please Visit http://www.conacent.com/?page_id=218


 

Responsibilty :-

Oracle Purchasing

Navigate :-

Setup/Organizations/Purchasing Options/Document Control

make sure the value in 'Output Format' = PDF

Responsibilty :-
Oracle Purchasing

Navigate :-

Setup/Purchasing/Document Typechoose Standard Purchase Order

make sure the value in 'Document Type Layout' = PO_STANDARD_XSLFO

Responsibilty :-

XML Publisher Administrator

Concurrent Program :-

Run the "XML Publisher Template Re-Generator Program" with parameter ALL .

Create a new Standard Purchase Order and see the PDF is successfully generated.

New Oracle APPS Online Documentation Library Link

This is recently launched Oracle online documentation portal

http://download.oracle.com/docs/cd/E18727_01/index.htm