PRC: Generate Draft Invoices for a Single Project Gives 'No eligible expenditures or events' on Billing Events

ISSUE:
PRC: Generate Draft Invoices for a Single Project Gives 'No eligible expenditures or events' on
Billing Events

Solution : 
 - go Event screen and check the billed flag (Yes)

- it should be 'No'




Ref:1066250.1

WEBADI CANNOT CREATE EXCEL SPREADSHEET - HANGS

Enable 'Allow status bar updates via script'.

1) Open Internet Explorer browser window.
2) Click on Tools Menu.
3) When the Tools menu appears, click "Internet Options" at the bottom of the Tools menu.
4) Click on the security tab.
5) When the Security page appears, click the "Internet" icon in the "Select a zone" box and then
click the "Custom Level.. " button.
6) When the "Security Settings" dialog box appears, scroll down to "Scripting" on the menu. Enable
- Allow status bar updates script.
   Select OK
7) You may receive a Warning. Please select "Yes"
8) Finally, click "OK" to close the Internet Options dialog box.
9) Close the browser window so that new settings can be used.


Ref:    789122.1

PRC: Update Project Summary Amounts Fails With ORA-01400 on EXPENDITURE_ITEM_DATE

PRC: Update Project Summary Amounts Fails With ORA-01400 on EXPENDITURE_ITEM_DATE [ID 1290089.1]
Ref: 1290089.1

PRC: Update Project Summary Amounts Ends with REP-0069 and REP-57054

PRC: Update Project Summary Amounts Ends with REP-0069 and REP-57054

Cause:

The parameter 'Generate Report Output' was set to YES so a huge amount of data was created with each run.  Once this option was set to NO, the error quit occurring.
Solution:

Set the parameter 'Generate Report Output' to NO for the PRC: Update Project Summary process.


Ref: 1372693.1

How to find last update for xml data definition,tamplate in database tables

Q.How to find last update for  xml data definition,tamplate  in database tables

Ans: XBO_LOBS (tables)

how to grant ON COMMIT REFRESH to user

grant ON COMMIT REFRESH to wpprod

How to delete log file in Unix

delete the file of 10 days old with this command

find . -mtime +10 -exec rm "{}" ";"

How To Enable/Disable Diagnostics menus and The Forms Personalization Menu

By default the “Personalize” menu is visible to all the users.  This can be controlled with help of profile options. By setting up the below profile options, the access to the Personalize menu can be limited for the authorized users. This will prevent unwanted users from changing the look and behavior of the forms.
The profile options are:

1. Utilities:Diagnostics = Yes/No
   This profile option controls the availability of the Diagnostics utility.
   So you can set it to Yes on site level or on user level.
   
2. Hide Diagnostics menu entry = Yes/No
   This profile Option determines whether a user can automatically use the Diagnostics features.
   If Utilities:Diagnostics is set to No, then users must enter the password for the APPS schema
   to use the Diagnostics features.

Ref:550626.1

oracle.apps.ar.applications.cashapp.apply

 Applying Receipt Generates Workflow Notification With Error - Local Event Error: oracle.apps.ar.applications.cashapp.apply

The issue can be reproduced at will with the following steps:

1. NAV: Receipts->Receipts
2. Apply a receipt to an invoice

The issue has the following business impact:

Due to this issue, SYSADMIN mailbox is getting hundreds of notifications daily and users are not sure if they need to be ignored

Solution:
The following workaround will avoid the error notification:

Please disable the event subscription as follows:

First login as SYSADMIN (you must have SYSADMIN privileges in order to update)

- RESP: Workflow Administrator Web Applications
- NAV: Administrator Workflow->Business Events
- In Name field for search criteria enter 'oracle.apps.ar.applications.CashApp.apply'
- (B) Click Go
- It will show you one even under Results
- Under Subscription column, click on Subscription icon
- Go to update subscription "PA_PWP_NOTIFICATION.Receive_BE"
- Select Disable
- Apply

Ref:973074.1