Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error – Local Event Error: oracle.apps.ar.applications.cashapp.apply
On : 12.1.1 version, Receipts Related
When attempting to apply a receipt, a notification is generated with the following error:
Local Event ERROR : oracle.apps.ar.applications.CashApp.apply
Event Error Message: No Event Subscriptions exist for this Event
The issue can be reproduced at will with the following steps:
Responsibility: Receivables Manager
Navigation: Receipts > Receipts
Apply a receipt to an invoice
Due to this issue, SYSADMIN mailbox is getting hundreds of notifications daily and you are not sure whether the error requires an action from you to fix, or can be ignored.
CHANGES
Upgraded to 12.1.1
CAUSE
FND Debug log generated via Note:433199.1 How to enable and retrieve debug log messages shows the following:
Start executing rule function – PA_PWP_NOTIFICATION.Receive_BE [Start time 1301086012]
End executing rule function – PA_PWP_NOTIFICATION.Receive_BE [End time 1301086014] [Time taken – .02 secs]
Executed Rule Function PA_PWP_NOTIFICATION.Receive_BE and returned ERROR
saving event to WF_ERROR on TST.LAKECO.ORG
This is worked in unpublished Bug 8869818 and Bug 8993957 GSI R12.1.1 WFERROR GENERATED FOR “PA AR NOTIFICATION” (PAPWPAR). In the bug it says:
WFERROR is generated for “PA AR Notification”(PAPWPAR) even when the functionality is not in use( “AR Receipt Notification” is disabled
Automatic receipt creation program in AR triggers the Business event oracle.apps.ar.applications.CashApp.apply, this in turn triggers the subscription API PA_PWP_NOTIFICATION.Receive_BE in synchronous mode. In API PA_PWP_NOTIFICATION.Receive_BE
apps_inititalize was called which was resetting the context already set by AR program. This resetting of context was clearing out the request_id from the global variables and was causing performance impact in AR process.
If you Don’t the PA AR Notification subscription then you can disable it as follows:
First login as SYSADMIN (you must have SYSADMIN privileges in order to update)
Responsibility: Workflow Administrator Web Applications
Navigation: 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
– This will disable the notifications to PA manager and will also bypass the call made to this particular API.
The below failure while executing :
Running perl /u01/apps/oracle/fs2/prodapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/apps/oracle/inst/fs2/inst/apps/PROD_U01ORACLEapp01/appl/admin/PROD_U01ORACLEapp01.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected
adpreclone cannot be run with pending ADOP session.
While An active ADOP session , If any cloning activity is performed, both file-systems could be in trouble. Hence we need to clear all ADOP sessions before executing adpreclone. However if adop -status -detail has no active sessions. Then Apply
Patch 22271970: ADPRECLONE.PL FAILS ON DELTA 7
$adop phase=apply patches=22271970
Restart of the adworker fixed the issue.
Change the page count to 200000 at the OS level:
$ more /proc/sys/vm/max_map_count
$ sysctl -w vm.max_map_count=200000
Adjust the realfree heap pagesize within the database by setting the following parameters in the init/spfile and restart the database.
_use_realfree_heap=TRUE
_realfree_heap_pagesize_hint = 262144
Then try restarting the worker
All Rights Reserved