Best Of
Re: How does Oracle AP6350 SBC select local-policy used to route a call?
Hello
as already told u in the previous post LP-A is matching because To-address has priority over From-address , and in this case To-address is matching that ip address .
For this type of scenario what u can do is to configure cost=1 on LP-A , leaving cost=0 on LP-B , but I'm unaware of other type of traffic that u need to handle .
Cheers
Antonio
Re: ODA X11 new deployment
Hi Tamil,
Thanks for the feedback.
We have ascertained that 23ai is not supported on BM but only on DBsystems/KVM.
A cleanup has been done and re-create appliance but failed because of customer's NTP is not working.
Once the NTP is resolved, the appliance will be re-created.
Thanks for your support.
Thanks,
James.
Re: Enter Feedback Here for the EBS Support Analyzer Bundle Menu Tool - Note 1939637.1
Hi Surya,
I discussed your error with our DBA expert and he offered
Oracle 8i SQL*Plus limits
While the definitive maximum statement length in Oracle is limited by several factors including database configuration, available disk space, and memory, this article states that there is no fixed number. However, it is possible to list several relevant limits related to SQL*Plus in Oracle 8i:
Additionally, after each error in your log shows :
Package body created.
No errors.
INFO: Dependency File exited with status: 0
so I think you are safe to ignore these.
To be sure, confirm that you are able to run the TITLE: Inventory Counting Analyzer (one example) from the bundle and as a concurrent request.
Let me know if you see a different message if you encounter this error.
Cheers,
Bill.
Re: oracle patch downlaod error
I have the same, and my temporary fix is still : use another type of browser. You should always have at least 2 types of browsers (and one of them not Microsoft).
Mr. C
Re: Extend the record retention period of Session Monitor
Hi Shilpi,
Thank you. I followed the documentation and adjusted the settings. I’ll keep monitoring it for a while.
YyL
Re: How to work with the ActivityFilter class in Primavera P6 API Integration
// This will load all filters by type activity
EnterpriseLoadManager elm = session.getEnterpriseLoadManager();
BOIterator<ActivityFilter> boiActivityFilter = elm.loadActivityFilters(ActivityFilter.getAllFields(), "FilterType = 'VT_LWF_FILTER'", null);
while (boiActivityFilter.hasNext()) {
ActivityFilter filter = boiActivityFilter.next();
System.out.println("Filter Id: " + filter.getActivityFilterId());
System.out.println("Filter Name: " + filter.getActivityFilterName());
System.out.println("Filter Criteria: " + filter.getFilterCriteria());
System.out.println("Filter Type: " + filter.getFilterType());
System.out.println("Filter UserId: " + filter.getUserId());
System.out.println();
}
Types include:
- 'VT_RISK'
- 'VT_FILTER'
- 'VT_TMUSER_FILTER'
- 'VT_FILTER_STANDARD'
- 'VT_ASSIGNS_FILTER'
- 'VT_PROJECTS_FILTER'
- 'VT_PROJ_FILTER_STAND'
- 'VT_ASSIGNS_FILTER'
- 'VT_ASSGN_FILT_STAND'
- 'VT_LWF_FILTER'
- 'VT_ASSGN_LWF_FILTER'
- 'VT_PROJ_LWF_FILTER'
- 'VT_TM_ACT_FILTER'
- 'VT_TM_TS_FILTER'
- 'VT_TM_ACT_STAND'
- 'VT_TM_TS_STAND'
Filter information can be found in the following PMDB table:
select * from viewpref;
Re: How to work with the ActivityFilter class in Primavera P6 API Integration
// This will use a filter called 'API Activity Filter' to read activity data
EnterpriseLoadManager elm = session.getEnterpriseLoadManager();
BOIterator<ActivityFilter> boiActivityFilter = elm.loadActivityFilters(ActivityFilter.getAllFields(), "ActivityFilterName = 'API Activity Filter'", null);
if (boiActivityFilter.hasNext()) {
ActivityFilter filter = boiActivityFilter.next();
BOIterator<Activity> boiActivity = elm.loadActivities(Activity.getAllFields(), filter.getFilterCriteria(), null);
while (boiActivity.hasNext()) {
Activity activity = boiActivity.next();
System.out.println(activity.getId() + " " + activity.getName());
}
}
else {
System.out.println("No filter named 'API Activity Filter' found.");
}
Re: Split maxvalue subpartition into multiple subpartitions
In PL/SQL there should be no ";" at the end of the command.
Example:
create table t1
(
id number not null
)
partition by range (id)
(
partition t1_maxvalue values less than (maxvalue)
) ;
begin
execute immediate 'alter table t1 split partition t1_maxvalue into (partition p1 values less than (100), partition t1_maxvalue);'; —« semicolon
end;
/
begin
*
ERROR at line 1:
ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions
ORA-06512: at line 2
begin
execute immediate 'alter table t1 split partition t1_maxvalue into (partition p1 values less than (100), partition t1_maxvalue)';
end;
/
PL/SQL procedure successfully completed.
Re: Responsbilitys are not dispalying in R12
As per the output, WF services are not running:
| FND_SVC_COMPONENTS - Components Information | |||||||||||
| COMPONENT_ID | COMPONENT_NAME | COMPONENT_STATUS | |||||||||
| 10000 | ECX Inbound Agent Listener | STOPPED | |||||||||
| 10001 | ECX Transaction Agent Listener | STOPPED | |||||||||
| 10040 | WF_JMS_IN Listener(M4U) | DEACTIVATED_USER | |||||||||
| 10021 | Web Services IN Agent | STOPPED | |||||||||
| 10002 | Workflow Deferred Agent Listener | DEACTIVATED_USER | |||||||||
| 10003 | Workflow Deferred Notification Agent Listener | DEACTIVATED_USER | |||||||||
| 10004 | Workflow Error Agent Listener | DEACTIVATED_USER | |||||||||
| 10041 | Workflow Inbound JMS Agent Listener | STOPPED | |||||||||
| 10005 | Workflow Inbound Notifications Agent Listener | DEACTIVATED_USER | |||||||||
| 10022 | Workflow Java Deferred Agent Listener | DEACTIVATED_USER | |||||||||
| 10023 | Workflow Java Error Agent Listener | DEACTIVATED_USER | |||||||||
This is causing events related to this user pending:
| WF_JAVA_DEFERRED - SUN.MOON WFDS Event Information | |||||||||||
| CORRID | STATE | COUNT(*) | |||||||||
| APPS:oracle.apps.fnd.wf.ds.userRole.updated | READY | 7 | |||||||||
| APPS:oracle.apps.fnd.wf.ds.userRole.created | READY | 3 | |||||||||
ANSWER
=======
You need to make sure that Workflow Services are up and running.
Basically below are the default Workflow Agent Listeners comes with application.
Workflow Java Error Agent Listener, Workflow Java Deferred Agent Listener, Workflow Inbound Notifications Agent Listener, Workflow Error Agent Listener, Workflow Deferred Notification Agent Listener, Workflow Deferred Agent Listener, Web Services IN Agent.
Each of which will have it own functionality.Trying to provide you example /use of which listeners are used in terms of User Responsibility case,please review the below.
Main Workflow Listeners in concerns which at least needs to be up and running are :
1. Workflow Deferred Agent Listener
2. Workflow Java Deferred Agent Listener
General Idea.
-------------
There are many tables which contains User Responsibility information ,its may be FND or WF tables.Hence for any changes taking place in user information like creation of new user,updating existing user,adding responsibility etc...There are some business event raised.
Each business events are defined for it own purpose and has one or more subscription.These subscription is basically a business logic and contains function activity .There can be 2 type of Function defined. One is Java Type and other PLSQL type.
Now once any changes happen for example there is any update in user for adding responsibility or removing end-date for instance.
'WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF' subscription will run as a part of processing the "oracle.apps.fnd.wf.ds.userRole.updated" event.Hence each event for processing gets into either WF_DEFERRED or WF_JAVA_DEFERRED queues.
Based on what type of subscription function (Java or PLSQL), One of the listeners process from its queue.
For example ,If there is a Java based event(function) ,it goes into WF_JAVA_DEFERRED queue and Workflow Java Deferred Agent Listener is responsibility to read its queue and process this event .Similarly,if a event is based on PLSQL code,it gets into WF_DEFERRED queue which in turn is processing by Workflow Deferred Agent Listeners.Once these events gets processed,based on what function execute respective action takes place ,for example various WF table gets updated with one change in User Responsibility.
Hence for this reason.you need to at least have 2 Listeners up and running for smooth business process and to avoid any synchronization issues.
How to start the Workflow services
=======================
a. Ensure the profile option 'Concurrent :GSM Enabled' is set to 'Y'. If not, set and bounce the concurrent managers.
You need to activate/start -- > From Container Column : Worfklow Agent Listener Service
1. Go into OAM as the SYSADMIN user
2. In the upper right corner of the screen next to "Navigate to", please select "Workflow Manager"
from the drop down and select "Go"
3. Then in the lower left corner of the screen under Related Links, select "Service Components"
4. Look for 'Container; Column were it says 'Workflow Agent Listener',click on the link.
5. Select 'Workflow Agent Listener Service' Container and Choose 'Start' from the LOV.
6. Once started, you go back to previous Service component page to see the all the related Worflow Service components are automatically started.
b. Once the service components above are started, the processes should then be processed.
If you consider your question/issue as answered/solved,
Please don't forget to mark Correct/Helpful answers in the thread. It helps other Community users to identify the solution quickly !
Regards,
Ajith