How To Set Email Style Preference For All Users At Once?

Applies to: Oracle Workflow Cartridge - Version: 11.5.9 to 11.5.10Information in this document applies to any platform.

Goal
The goal of that Note is to explain how to bulk update the Email Style preference for all E-Business Suite users at once. The same can be used to update the Email Style for a group of users only, for instance the users who have the preference set to "Disabled" ...
Usually, each user must reset the Email Style preference through the "Preferences" page available from his Home Page.

Solution
1. Unfortunately, currently there is no seeded way to do this. An enhancement request has been logged for this under Bug 5748131 (NEED PLEASANT WAY TO BULK RESET NOTIFICATION PREFERENCE FROM DISABLED).It is under Oracle Development's review ...
2. Currently, the only workaround to change the Email Style of all users is to update the tables.Note that there are 2 tables to update :
FND_USER_PREFERENCES and WF_LOCAL_ROLES.
NB:You should backup those tables before performing the updates.
3. Updates for All Users would look like :
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-';

4.
Updates for Users having the preference set to "Disabled" would look like :
a.
update wf_local_rolesset notification_preference=''where orig_system in ('FND_USR','PER')and name in(select user_namefrom fnd_user_preferenceswhere preference_name='MAILTYPE'and module_name='WF'and preference_value='DISABLED');b. update fnd_user_preferencesset preference_value=''where preference_name='MAILTYPE'and module_name='WF'and preference_value='DISABLED';

The where clauses of above SQL can be modified to match your needs

NB : Possible values for are :

QUERY (corresponds to preference value "Do not send me mail")
MAILTEXT (corresponds to preference value "Plain text mail")
MAILATTH (corresponds to preference value "Plain text mail with HTML attachments") MAILHTML (corresponds to preference value "HTML mail with attachments")
MAILHTM2 (corresponds to preference value "HTML mail")
SUMMARY (corresponds to preference value "Plain text summary mail")
SUMHTL (corresponds to preference value "HTML summary mail")
DISABLED (corresponds to preference value "Disabled")

ReferencesNote 360541.1 - 11.5.10 Users notification preference becomes Disabled in table FND_USER_PREFERENCES table

GL JOURNAL ENTRY, REVERSING, RECURRING FAQ

ORACLE GENERAL LEDGER

---------------------

JOURNAL ENTRY, REVERSING, RECURRING

-----------------------------------

FREQUENTLY ASKED QUESTIONS

--------------------------

September 2008CONTENTS

--------

Journal Entry

-------------

1. How to delete a Journal Batch? The delete icon is greyed out. The journal batch does not have journals associated and it is unposted.

2. Why does an accounting period not appear in the accounting periods list of values on the journal entry form?

3. Why can not a journal batch be deleted or modified?

4. Which report shows details of a posted journal batch?

5. Is there a report that displays information on one specific journal entry - unposted/posted?

6. Can a posted journal batch be deleted?

7. Is possible to restrict users from entering negative amounts in journal lines?

8. How to set up journal approval in General Ledger?

9. How do you attach an Excel spreadsheet to a journal entry in Oracle General Ledger?

10. How to easily copy a journal entry from one set of books to another?

Reversing Journals

------------------

11. An entire batch was reversed and posted, while trying to reverse and post just one journal entry in the batch. How can this be corrected?

12. Why is there a reversed posted journal in the next accounting period of a non posted journal?

13. Why is the reversal period of a journal being cleared out after the period is changed?

14. A journal entry with a source set up for automatic reversal is not reversed.

15. Does the reversal program generate separate reversal batches-journals for each journal in a batch that is reversed?

16. How do you reverse a journal entry that was already reversed, but its' reversed journal was deleted?

17. How do you restrict the ability to reverse unposted journals?

18. How do you automatically generate a reversal journal entry for a journal category in the previous accounting period?

19. In Release 12, a reversal journal that is Unposted cannot be modified.

Why?QUESTIONS & ANSWERS

-------------------

Journal Entry

-------------

1. How to delete a Journal Batch? The delete icon is greyed out.

The Journal Batch does not have journals associated and it is unposted.

Answer

------

The journals/enter first popup form looks only for batches with journals.

a. Go to Journals > Enter.

b. When the Find Journals window appears, click on the 'X' in the upper right corner to close the window.

c. Click the Review Batch button on the Enter Journals form. This will bring up the Find Batches window to query the batch.

d. Enter the batch Name and the Period.

e. Click the Find button and the batch should be displayed on the Batch window now.

f. Now it is possible to click on the delete icon to delete the unposted

journal batch.

Note 1036784.6

2. Why does an accounting period not appear in the accounting

periods list of values on the journal entry form?

Answer

------

The accounting period list of vlaues displays periods that have a closing

status of Open (O) or Future Enterable (F). New journal entries can be

defined in open and future enterable accounting periods. New journal entries

can be posted only in open accounting periods.

3. Why can not a journal batch be deleted or modified?

Answer

------

A journal batch can not be deleted or modified under the following

circumstances:

a. The source is frozen

b. Funds have been reserved for the batch

c. Funds are in the process of being reserved for the batch

d. The batch is in the process of being posted

e. The batch is posted

f. The batch is approved

g. The batch is in the process of being approved

A journal batch should not be updated if it comes from a sub-ledger.

Changing accounting information in a journal that originated in a

sub-module will unsynchronize the accounting information between the

ledger and the sub-ledger. Instead of changing the sub-ledger

journal, define a new journal to adjust the accounting information

if necessary.

A journal batch that has funds reverved can not be updated because

the funds would not be re-reserved appropriately.

4. Which report shows details of a posted journal batch?

Answer

------

Journals - General(180 Char) and Journals - General(132 Char)

reports display information relating to a particular journal batch.

5. Is there a report that displays information of one specific

journal entry - unposted/posted?

Answer

------

No. General Ledger reports display information of journal batches that

are posted or unposted.

Note 200787.1 gives a workaround solution.

6. Can a posted journal batch be deleted?

Answer

------

No, a posted journal batch can not be deleted. Reverse it to nullify

the accounting effects of the posted journal batch.

See Note 135532.1

7. Is possible to restrict users from entering negative amounts

in journal lines?

Answer

-------

Unfortunately, it is not possible to restrict users from entering negative

amounts in journal entry lines.

8. How to set up journal approval in General Ledger?

Answer

------

This is set up using Oracle Workflow Builder.

The complete procedure is

explained in Note 176459.1

9. How do you attach an Excel spreadsheet to a journal entry in Oracle General Ledger?Answer

------

Please refer to Note 1074918.6

10. How do you easily copy a journal entry from one set of books to another?

Answer

------

There is no standard feature to copy journal entries between sets

of books. However, there are some alternatives. See Note 204082.1

Reversing Journals

------------------

11. An entire batch was reversed and posted, while trying to reverse and post

just one journal entry in the batch. How can this be corrected?

Answer

------

When you reverse an entire batch, one reversal batch is created for each

journal in that batch. To correct your problem, reverse the reversal batches

that contained the journals you reversed by mistake, then post them.

12. Why is there a reversed posted journal in the next accounting period

of a non posted journal?

Answer

------

This is the current funcionality. Reversing journals can be posted before

the original journal is posted.

Note 176329.1

13. Why is the reversal period of a journal being cleared out after

the period is changed?

Answer

------

This is the expected functionality in Release 11i. When you change the

period of a journal, the application can not determine what you want to

do with the reversal period, so it is cleared.

14. A journal entry with a source set up for automatic reversal

is not reversed.

Answer

------

General Ledger automatically submits the AutoReverse program when a period

is opened if the profile option, GL: Launch AutoReverse After Open Period,

is set to Yes. If a journal is created after the period has already been

opened, then the AutoReverse program will need to be submitted manually.

15. Does the reversal program generate separate reversal batches-journals

for each journal in a batch that is reversed?

Answer

------

Yes.

When a batch is reversed, General Ledger creates a reversing

journal entry for each journal entry in the batch. Note that this

also generates a separate reversal batch for each reversed journal.

16. How do you reverse a journal entry that was already reversed, but its

reversed journal was deleted?

Answer

------

General Ledger does not allow you to reverse a journal entry twice.

Confirm that the first reversed journal entry does not exist in the system.

Contact Oracle Support for the solution to Note 145043.1

17. How do you restrict the ability to reverse unposted journals?

Answer

------

Unposted journals can be reversed, this is the intended functionality.

Additional information can be found in Note 172016.1

This functionality changed in R12 - see Note 734848.1 In Release 12,

a batch must be Posted before it can be reversed.18. How do you automatically generate a reversal journal entry for a journal

category in the previous accounting period?

Answer

------

Automatic Journal Reversal is a feature that is included in Release 11i.

Additional information can be found in Note 151920.1

19. In Release 12, a reversal journal that is Unposted cannot be modified. Why?

Answer

------

This is the expected functionality in Release 12. However the profile

GL: Edit Reverse Journals can be set to allow the modification.

See Note 567641.1

Problem in deleting GL Batch(UNPOSTED)

Need to Delete a JE Batch (UNPOSTED)

Query the batch then Edit --> Delete --> Save

In case you need to delete the full batch click on Batch


In case you are not getting the above delete option then check below;

Cause:
A journal batch can not be deleted or modified under the following circumstances:

a. The source is frozen

b. Funds have been reserved for the batchs

c. The batch is in the process of being posted

d. The batch is approved

e. The batch is in the process of being approved


Solution:
If your batch status is not there in any of the above cases then please try to following to fix this problem:

To Modify a journal batch that is frozen, follow this procedure:

a). (N) Setup > Journal > Sources

b). Query the Journal Source

c). Uncheck the Freeze Journals box and save the changes before exiting the form.

d). The batch or journal will now be able to be modified or deleted

e). After deleting/modifying the batch, navigate back to the Journal Sources form and re-freeze the Source.

Please note that once the journal is deleted/modified it cannot be recreated and in most circumstances means you will not be able to reconcile your subledger.
To delete Batches that are found in Journals Enter form 1.

The Navigation Path is: Journals > Enter

2. Provide search criterion in the Find Journal form

3. Select the unposted batch that has to be deleted

4. Click the Delete Icon from the tool bar.

Select the Batch option to delete whole batch

Note that the above process works only for the transactions which have not come from the subledgers or where trasnactions have not been checked for funds in the sub-ledgers. The transactions from the subledger are funds checked and passed by subledgers and hence the funds check status can not be changed in General Ledger. Where transactions have passed funds check in the subledger the above process will not work. In such a case please log an SR with Oracle Support.

References (www.metalink.oracle.com)
Note 236996.1 - How to Delete an Unposted Journal Imported to GL

Note 330668.1 - Journal Batch is Stuck in Approval - Can't Delete, Modify or Approve It

AP Closing Process

The process to close an accounting period has changed in release 11i. The
form to control the status of an accounting period has been renamed from
“AP Accounting Periods” to “Control Payables Periods”. Its location in the
navigator has also changed. It has moved from the Setup section into the new
Accounting section of the menu.

The rules to close a period in Payables in release 11i are:


All payment batches must be confirmed
All transactions must be accounted
All accounting entries must be transferred to general ledger
All future dated payments which have reached maturity in the accounting


period must have their status updated to negotiable and be accounted
---------------------------------------------------------------------
Optionally, unaccounted transactions can be swept to the next accounting period (if
allowed by accounting rules).

There is a new program in 11i to support this called the
"Unaccounted Transactions Sweep".

This program can be submitted from the "Control
Payables Periods" form in both a review mode and an update mode. The program can
be called only if there are any unaccounted transactions in the period.

This new program replaces the "Unposted Invoice and Payment Sweep".
Before invoices can be accounted they must be approved by the Payables Approval
process.

Before payments can be accounted they must pass through the Confirm
process.

Typical steps to close a period in Payables release 11i are:

. Import all invoices and/or expense reports from AP Interface tables
. Run Approval
. Confirm any outstanding payment batches
. Run the Update Matured Future Payment Status program for any future
dated payments
. Run the Payables Accounting Process
. Review the accounting process output and correct any accounting errors
. Review the Unaccounted Transactions Report to identify transactions
which cannot be accounted
. Correct any transaction data and run the Payables Accounting Process again
. Review the Payables Account Analysis Report (This report replaces the
Expense Distribution Detail Report)
. Run the Payables Transfer to General Ledger
. Optionally run the Unaccounted Transactions Sweep
. Close the Payables period
. Reconcile AP to GL