Best Of
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
Re: getting the error Failed to send test email: certfile for SMTP config on Oracle session monitor
Re: Enter Feedback Here for the EBS Workflow Java Mailer Analyzer KB551591
Thanks for the feedback.
The correct version 200.45 workflow java mailer analyzer zip file is now downloadable on
Workflow Java Mailer Analyzer (Doc ID 2901874.1).
Re: newer java version certified with Java Web Starter
Ow OK. Thank You Rajagopalan.
I Will use 1.8.0_461 version.
apps
Re: Form control UDC dropdown to display values based on a selection of value in another FC drop down
Try combo box or override the data dictionary item using system function.
E1: FDA: Using a Combo Box Control in Form Design Aid (FDA) (Doc ID 1391121.1)
https://docs.oracle.com/en/applications/jd-edwards/development-tools/9.2.x/eotfd/set-data-dictionary-overrides-1.html
Re: How to check if AIS Server Configuration was successful?
BTW, the json file is named defaultconfig.json.
Thanks.
Kwan Lam
How does Oracle AP6350 SBC select local-policy used to route a call?
Hi Experts,
I have two local-policy configured on OCSBC AP6350 as follows. The SBC is running software version SCZ920p5.
Local-Policy A:
local-policy
from-address *
to-address 100.200.100.1
source-realm Core
description Outbound to SBC1
activate-time
deactivate-time
state enabled
parallel-forking disabled
policy-priority none
policy-attribute
next-hop SAG:SBC1
realm SBC1_Access
action none
terminate-recursion disabled
carrier
start-time 0000
end-time 2400
days-of-week U-S
cost 0
state enabled
app-protocol
methods
media-profiles
lookup single
next-key
auth-user-lookup
eloc-str-lkup disabled
eloc-str-match
Local-Policy B:
local-policy
from-address +441171234567
+441171234578
+441171234589
to-address *
source-realm Core
description
activate-time
deactivate-time
state enabled
parallel-forking disabled
policy-priority none
policy-attribute
next-hop SAG:SBC2
realm SBC2_Access
action none
terminate-recursion disabled
carrier
start-time 0000
end-time 2400
days-of-week U-S
cost 0
state enabled
app-protocol
methods
media-profiles
lookup single
next-key
auth-user-lookup
eloc-str-lkup disabled
eloc-str-match
Please note that both local-policy has the same source-realm named Core.
When +441171234567 calls 08000123456, and the call gets routed to the SBC from the Core Network, the SBC uses local-policy A to route the call to SAG:SBC1 instead of local-policy B which should route the call to SAG:SBC2.
How do we configure the SBC to always use local-policy B instead of local-policy A for this type of call scenario where a number in the from-field of local-policy B calls any destination number?
Thanks.