Skip to main content

Home/ BI-TAGS/ Group items tagged accounting

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Install apex 4.2 - 0 views

docs.oracle.com/...otn_install.htm

apex

shared by cezarovidiu on 26 Apr 13 - No Cached
  • @apexins.sql SYSAUX SYSAUX TEMP /i/
  • @apxchpwd.sql
  • Shut down with normal or immediate priority the Oracle Database instances where you plan to install Oracle Application Express.
  • ...9 more annotations...
  • Full development environment.
  • Runtime environment
  • 3.3.3 Change the Password for the ADMIN Account
  • 3.3.4 Restart Processes
  • Unlocking the APEX_PUBLIC_USER Account
  • The APEX_PUBLIC_USER account is locked at the end of a new installation of Oracle Application Express. You must unlock this account before configuring the database access descriptor (DAD) in a new installation.
  • ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
  • ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password
  • PASSWORD_LIFE_TIME parameter is set to unlimited
cezarovidiu

How to join GL tables with XLA (SubLedger Accounting) tables - 0 views

oracle.anilrpatil.com/...xla_ae_headers

ebs tables gl xla_ae_headers

shared by cezarovidiu on 12 Apr 13 - No Cached
  • GL_JE_BATCHES (je_batch_id)                                   => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id)                                  => GL_JE_LINES (je_header_id) GL_JE_LINES (je_header_id,  je_line_num)                      => GL_IMPORT_REFERENCES (je_header_id, je_line_num) GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) XLA_AE_LINES (application_id, ae_header_id)                   => XLA_AE_HEADERS (application_id, ae_header_id)  XLA_AE_HEADERS (application_id, event_id)                     => XLA_EVENTS (application_id, event_id)    XLA_EVENTS (application_id, entity_id)                        => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 
  • The source_id_int_1 column of xla.xla_transaction_entities stores the primary_id value for the transactions. You can join the xla.xla_transaction_entities table with the corresponding transactions table for obtaining additional information of the transaction. For e.g you join the xla.xla_transaction_entities table with ra_customer_trx_all for obtaining receivables transactions information or with mtl_material_transactions table for obtaining material transactions information. The entity_id mappings can be obtained from the XLA_ENTITY_ID_MAPPINGS table
  • cezarovidiu on 12 Apr 13
     
    "How to join GL tables with XLA (SubLedger Accounting) tables"
cezarovidiu

Gartner Positions Oracle in Leaders Quadrant for Master Data Management of Product Data... - 0 views

www.oracle.com/...1897161

oracle leaders master data management gartner

shared by cezarovidiu on 17 Jan 13 - No Cached
  • For the fourth consecutive year, Gartner, Inc. has named Oracle as a Leader in its “Magic Quadrant for Master Data Management of Product Data Solutions.” (1)
  • “MDM is a technology-enabled discipline in which business and IT staff work together to ensure the uniformity, accuracy, stewardship, semantic consistency and accountability of the enterprise's official, shared master data assets. Master data is the consistent and uniform set of identifiers and extended attributes that describes the core entities of the enterprise, such as customers, prospects, citizens, suppliers, sites, hierarchies and chart of accounts,” according to Gartner.
  • By enabling organizations to consolidate product information from heterogeneous systems, Oracle Product Hub creates a single view of product information that can be leveraged and shared across functional departments in the enterprise, as well as externally with trading partners.
  • ...1 more annotation...
  • "In any product company, accurate product information is a foundation for all major business initiatives, and this requires a robust, comprehensive and flexible product MDM solution,” said Jon Chorley, vice president, supply chain management product strategy, Oracle. "We believe Oracle's position in Gartner's Magic Quadrant for Master Data Management of Product Data Solutions highlights our ability to provide best-in-class functionality across the industry’s most complete MDM portfolio. By using Oracle MDM solutions, companies can obtain a high-quality, common enterprise product record and are better able to support their key business initiatives.”
  • cezarovidiu on 17 Jan 13
     
    "Gartner Positions Oracle in Leaders Quadrant for Master Data Management of Product Data Solutions"
cezarovidiu

Magic Quadrant for Sales Force Automation - 0 views

www.gartner.com/...reprints.do

crm

shared by cezarovidiu on 11 Jan 13 - No Cached
  • cezarovidiu on 11 Jan 13
     
    "Market Definition/Description Sales force automation (SFA) applications support the automation of sales activities, processes and administrative responsibilities for B2B organizations' sales professionals. Core functionalities include account, contact and opportunity management. Additional add-on capabilities focus on improving the sales effectiveness of salespeople, such as sales configuration, guided selling, proposal generation and content management, and sales performance management support, including incentive compensation, quota, sales coaching and territory management."
cezarovidiu

Difference between CRM lead and an opportunity - Pipeliner CRM Blog - 0 views

blog.pipelinersales.com/...en-crm-lead-and-an-opportunity

CRM documentation blog

shared by cezarovidiu on 31 Mar 15 - No Cached
  • Any individual fish or pod of fish in your sea represents one lead.
  • Your Nemo will not be the first or the second fish that you catch. At the beginning, you will have very little information about the Nemo you would like to catch. You will start to examine your fish and create some criteria as to how Nemo should look like. In other words, you are qualifying your fish.
  • Lead = Any Fish in The Sea. Opportunity = Nemo
  • ...6 more annotations...
  • The process of examination and adding the criteria represents your sales pipeline strategy. It’s always true that: “Without a commitment to pursue working together (something that results in this company potentially buying from you) there is no opportunity.” - Anthony Iannarino
  • At the end of your examination ie. of your sales process, you will either let the fish swim back into your sea (lost opportunity) or you will put Nemo into your aquarium (won opportunity). Won Opportunity = You have found Nemo Lost Opportunity = You have not found Nemo
  • A Lead – is a contact or an account with very little information. It could be just a person who you might have met at a conference. You will need to retrieve more information regarding this lead in order to create (qualify) an opportunity in your sales pipeline.
  • A old sales rule says: “If you have never contacted your contact, it’s a lead.”
  • An Opportunity - is a contact or an account which has been qualified. This person has entered into your buying cycle and is committed to working with you. You have already contacted, called or met him and know their needs or requirements. The old sales rule says: “The opportunity is a deal that you have the possibility to close!”
  • “Think about the difference between a lead and an opportunity as an evolving process i.e. each lead needs to be qualified to an opportunity. There will always be plenty of leads in your sales territory, but only few of them will qualify to become real sales opportunity.”
cezarovidiu

Moving Sugar to Another Server - SugarCRM Support Site - 0 views

support.sugarcrm.com/...Moving_Sugar_to_Another_Server

sugarcrm

shared by cezarovidiu on 20 Mar 13 - No Cached
    • cezarovidiu
      cezarovidiu on 20 Mar 13
       
      japtone   Senior Member Join Date Nov 2010 Posts 49  Re: Transferring SugarCRM to a new server If you're using Linux try to have the same version of PHP, Apache, and DB (MySQL for instance) in order to avoid compatibility issues. In your production server tar up the sugarcrm root directory, transfer it to the new server and untar wherever your new root directory will be.  Next take a db dump of your database, transfer it to the new server and do a restore. Make sure apache is configured on the new server to point to the root of sugarcrm and start it up.  Make sure to modify config.php to account for any change in paths and hostname.  that's what I've found to be the easiest way to 'clone' sugar.
  • mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
  • Extract the Database
  • ...5 more annotations...
  • Copy Filesystem Copy all your files to the new server.  This can be done simply by locating the root directory on your old instance and copy and pasting it to the new server location.
  • Import Database Import the mysql database into the new server.  Here's how you would restore your custback.sql file to the Customers database. mysql -u sadmin -p pass21 Customers < custback.sql Here's the general format you would follow: mysql -u [username] -p [password] [database_to_restore] < [backupfile]
  • Check Files and Permissions Check Config.php Open <sugarroot/config.php> and make sure that all settings still apply to the new server, such as: array ( 'db_host_name' => 'localhost', 'db_user_name' => 'root', 'db_password' => 'PASSWORD', 'db_name' => 'DATABASE_NAME', 'db_type' => 'mysql', ), 'site_url' =>, etc...
  • Check htaccess Open <sugarroot/.htaccess> and ensure that the new server URLs are used correctly.
  • Check Permissions Check that the permissions are correct on the new server. That is the entire custom and cache directories (and all the sub directories) in addition to the config.php file are owned and writable by the user that runs the application on the server.
1 - 9 of 9
Showing 20▼ items per page