UC4

Dernières infos

Re: looking for a third party 'job system/job scheduler'

AppWorx, now UC4, is one possibility but there is little, if anything, they can do that can not be done through the proper use of the DBMS_SCHEDULER package.

I would suggest that, before you spend or waste money, you look at the docs on DBMS_SCHEDULER and determine that there is something you need that you have not already purchased. Using OEM to schedule jobs is far from giving you access to the full functionality.

Oracle Forum Search for UC4

using stored procedures - I can't seem to get the parameters right

I am wanting to use stored procedures to create substitute variables to use in UC4(Appworx). (the databases I am using are 10g) To do this I first need to get the procedures to run at the command line in PL/SQL. I do not seem to be able to create the correct command. This is the part of the package that I want to call

CREATE OR REPLACE
PACKAGE BODY "APPLICATION_PACKAGE" AS

PROCEDURE GET_APP_PARAM(V_APP_PARAM_ID IN CCOK.CC_APP_PARAM_DETAIL.APP_PARAM_ID%TYPE,
V_APP_PARAM_NAME IN CCOK.CC_APP_PARAM_DETAIL.APP_PARAM_NAME%TYPE,
V_APP_PARAM_VALUE OUT NOCOPY CCOK.CC_APP_PARAM_DETAIL.APP_PARAM_VALUE%TYPE)

BEGIN

SELECT APP_PARAM_VALUE
INTO V_APP_PARAM_VALUE
FROM CCOK.CC_APP_PARAM_DETAIL
WHERE APP_PARAM_ID = V_APP_PARAM_ID
AND APP_PARAM_NAME = V_APP_PARAM_NAME;

END;

This is the exact command I am using at the command line

execute application_package.get_app_param(1000,'RUN_TYPE')

when I do this I get the expected invalid statements, but further tweaking doesn't fix it and doesn't give me any clear idea of what I need to do to fix it.
I get this kind of thing

SQL> execute ccok.application_package.get_app_param(1000,'run_type')
BEGIN ccok.application_package.get_app_param(1000,'run_type'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_APP_PARAM'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SQL> execute ccok.application_package.get_app_param(1000,'run_type',:result)
SP2-0552: Bind variable "RESULT" not declared.
SQL> execute ccok.application_package.get_app_param('1000','run_type')
BEGIN ccok.application_package.get_app_param('1000','run_type'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_APP_PARAM'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Any help will be most gratefully appreciated.

Re: RIB vs AppWorx (integration between Oracle POS and RMS)

Hello Aan,
Please see my comments in the message below.
Please do not count on my remarks only but get expert advice (from an expert who has sufficient time, e.g. a consultant from Oracle Corp., Wipro Retail, Online Resource, Accenture, FSI, IBM, etc.) re. this - the whole integration subject is no easy matter and not to be explained in one sentence.
By choosing many OracleRetail products you will certainly have benefits in free, optimized and/or pre-built integration. However both for internal and for external integration many choices and implementation decisions need to be made.

Regards,
Erik

actually if the salesman mention this product from the very beginning, it would not be such a problem.
but now, after all the deal is settled, it's quite difficult to ask our management for another purchase, hikss....
EYK> Appworx is 'only' about 65kUS$

1. actually all the interface program is in place, but we need to run that batch program manually, or scheduled it using crontab. but since the program could be so many, it's best if we used some program like appworx.
EYK> you definitely need a scheduler - it is unwise to go with cron

2. interface between Retail and finance done by RIB and BPEL. we don't need separate purchase/license purchase for BPEL?
EYK> Yes, you need separate BPEL licenses, and probably also for the RMS-EBS interface Package

3. RMS to BO/POS/CO/SIM is done partially over RIB (SIM) and batches.
a. could u please explain this? is it mean that for SIM, the interface will go through RIB, and for other data (like sales, master, etc) will go through Batches program? is this program already exists or we have to build a new one?
EYK> This is not my area of expertise - please read all the operations guide and/or get expert advice

b. what is the flow of the data? POS to BO to CO to RMS? or?
for SIM, it will be from Enterprise SIM to store SIM right? (data can come from SIM to POS).
EYK> idem

4. appworx or any other batch scheduliing program only run the batch/interface program that already exists. if need other interface from some legacy system to oracle retail, we must first build the program and use appworx to schedule the execution of the program. is it correct?
EYK> This is correct, any custom integration you need to build can (should) be run in your enterprise scheduling platform, e.g. AppWorx/UC4. Also consider a generic tool like an ESB for application to your interfacing challanges. Actually, as BI Publisher is required for the RMS Operational reports, and this is only sold as an option to the OAS-EnterpriseEditition, and the OAS-EE contains the Oracle ESB, you already have an ESB in your portfolio - why not apply it.
When possible it is interesting to do more realtime, message like integration over batch/file based integration, and an ESB comes closer to the former.

5. we'r buying oracle retail release 13 (Because we need wholesale functionality)... our EBS is version 11.5.9. the consultant told me that ORetail R13 only work with OraFin v12.4, is true?
can it work gracefully with ORAFIN R11.5.10?
EYK> We are now implementing 13 (13.0.1 currently). Indeed the RMS12 is for EBS11, RMS13 is for EBS12. But a skilled consultant can make it work if one combines elements from the two interfaces into one - though it may be a challange due to the impact on the financials interface of e.g. multiple sets of books/multiple legal entities and franchising/wholesale etc.

Re: RIB vs AppWorx (integration between Oracle POS and RMS)

RIB is a publisher/subscriber internal integration bus, like an enterprise service bus, for Oracle Retail modules like RMS, RWMS, SIM etc.
Appworx/UC4 is a batch scheduling and execution platform - e.g. RMS comes with many programs that either need to be run multiple times per day, or once a night/week/month. Sometimes people use cron (on unix) for such a purpose, but since there are many jobs and dependencies between the jobs (what should run after what) and also errors need to be managed, this kinda grows out of the cron area.
I hope this makes it more clear.

If you do not already have a batch scheduling platform, e.g. like Redwood Cronacle, I think it is worthwile to consider Appworx/UC4. If you do already have a platform, consider also to built the RMS schedule into that. Not having a scheduler is not an option.
(And there may be other applications that need scheduling, I do not recall that yet).

Data to Financials is done by RIB and BPEL (you will need the BPEL option for the Oracle Application Server for that)
RMS to BO/POS/CO/SIM is done partially over RIB (SIM) and batches.

Also ask your system integrator/OracleRetail consultant, they should be able to clarify this for you too.
Also check out the Operations Guides of your applications, starting at http://www.oracle.com/technology/documentation/oracle_retail.html.

Regards,
Erik

Re: How to run multiple query paralelly in single session?

Hi some one else,

i guess he can use some kind of scheduler tool, where the scripts are run parallely, and each time they connect to db,

we use tool called uc4 to do it,

i know only this way

regards
nic