Solved

Proplem of launch cost manager

Posted on 2002-04-18
7
1,771 Views
Last Modified: 2008-10-13
How to launch the cost manager in Oracle Applications in command line?
Thanks.
0
Comment
Question by:blueleaf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Expert Comment

by:AlbertYou
ID: 6952931

Hi blueleaf,

Why do you launch the cost manager in the command line ?
You can launch it programmatically by the FND_REQUEST package.
Moreover, the cost manager needs its security context,
such as organization_id, WHO columns... to be established.
It is difficult to establish the security context in the command line.
You can try the following:
1. In the command line, start SQL*Plus to run a SQL script, say, COSTMGR.sql.
2. In the COSTMGR.sql script:
   2.1 Establish the security context by calling the API
            FND_GLOBAL.APPS_INITIALIZE(user_id, responsibility_id, application_id)
   2.2 Call the FND_REQUEST.submit_request API to submit the COST manager concurrent program.

Hope this can help you.

Albert.

0
 
LVL 48

Expert Comment

by:schwertner
ID: 6953155
may be the following will help you to find the solution.

The Resource cost transaction manager processes transactions from
Oracle's WIP in addition to those resource transactions imported from other sorces
such as barcode readers.

The program polls pending transactions in wip_cost_txn_interface and
periodically updates/inserts into the following WIP tables:
wip_transactions, wip_transaction_accounts and wip_period_balances

The program can be run from the command line: CMCCTM bom/bom passwd 0 Y

For more details on this program see Oracle WIP Technical Referance
manual.

0
 

Author Comment

by:blueleaf
ID: 6964793
Hi AlbertYou,

Could you tell me more detail about how to run FND_REQUEST.submit_request to launch cost manager, I mean how to setup the parameters?

Thanks
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 2

Accepted Solution

by:
AlbertYou earned 200 total points
ID: 6979802

Hi Blueleaf,

You can find the detail information from the Oracle Applications Documentation Library --
Oracle Applications Developer's Guide.
You can also view the package spec by using DESCRIBE statement in SQL*Plus:
      describe fnd_request;

The parameters are briefly described below:
--------------------------------------------------
FND_REQUEST.SUBMIT_REQUEST(
     application  in   varchar2 default NULL,
     program      in   varchar2 default NULL,
     description  in   varchar2 default NULL,
     start_time   in   date     default NULL,
     sub_request  in   boolean  default FALSE,
     argument1    in   varchar2 default NULL,
     argument2    in   varchar2 default NULL,
     ...
     argument100  in   varchar2 default NULL )
     return NUMBER;
1. APPLICATION is the short name of the application assocaited with the concurrent program to be submitted.
   In your case, it is 'BOM'.
2. PROGRAM is the short name of the concurrent program.
   In your case, it is 'CMCTCM'.
3. DESCRIPTION is the description to be displayed in the view requests form.
   In your case, it is 'Cost Manager'.
4. START_TIME is the time(HH24:MI or HH24:MI:SS formatted) the request should be started.
5. SUB_REQUEST states that whether this request is submitted from another concurrent request.
6. ARGUMENT1...100 : Up to 100 arguments are permitted. If the request is submitted from Oracle Forms, You have to specify all 100 arguments. (explicitly specify NULLs for the unused arguments)
   In your case, no argument is need.

Hope this can help you.

Albert.

0
 
LVL 2

Expert Comment

by:AlbertYou
ID: 6979812

Another note:
This function returns the request ID of the concurrent request if submit successfully; It returns 0 otherwise.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7063165
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 9203237
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
points to be given to AlbertYou
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

anand_2000v
EE Cleanup Volunteer
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question