Purging Service in BCC

PurgingService is service which is used to purge older versions of assets in Publishing Schema. This component is available in Publishing.base module.

Question: I am using this service for first time. Are there any prerequisites?
Answer: Yes, following are the prerequisites that needs to followed.

1. Delete all "Author" state projects which are not in use for week or month.
2. Close all the projects which are waiting for acceptance.
3. Halt the BCC deployments if any.
4. Do not Create any project till the Purging service is complete. Accessing BCC is not advisable during purging. 
5. Increase the DB Transaction time out to MAX for PUB JVM.
6. Last, Take a back up of File system and Publishing DB.



Question: Okies, I have achieved above prerequisites. How should I proceed further?
Answer: Access the Dyn/admin of BCC and search for component "PurgingService". Entire Purging service is divided into following sections.

1. Generating Report

Generate Report stating how many assets are going to be purged. Provide Days prior to which assets needs to purged.

2. Submit Purge

Once report is generated, you can submit the for purging or cancel.

Final result will be shown once the purge is complete.

Question: I am done with purging. Are there any post requisites?
Answer: Yes, Indexes in Publishing DB will be disturbed. Please rebuild indexes in Publishing DB.


Question: Cool. Are there any good to know information about Purging Service?
Answer: If you are planning to Purge assets older than 7 days, you can break it into small parts.
1. First purge assets older than 100 days.
2. Next purge assets older than 50 days.
3. And Lastly purge assets older than 7 days.

Before Running Purging Service in Production, it's good to be tried out in replica of Production first.

Read More

Supported Environments Matrix for Oracle Commerce 11.0.0.0

Oracle Commerce 11.0.0.0 Support for 3rd Party Environments
Application Server	Oracle WebLogic (WLS)	12.1.2
	IBM WebSphere (WAS)	IBM WebSphere (WAS)
	JBoss	6.1.0 EAP
Database	Oracle	Oracle Exadata5, 12c (12.1.0.0), 12c RAC (12.1.0.0), 11gR2 (11.2.0.2.0), 11gR2 RAC (11.2.0.2.0)
	IBM DB2	10.1
	MSSQL	2012
	MySQL	5.6.11
Operating System	Oracle Linux	5.7, 6.1
	Oracle Solaris	10, 11
	Red Hat Linux	5.7, 6.1 Advanced Platform
	Windows (64 bit)	2012 Standard, Standard 2008 R2 Standard, Enterprise, Datacenter 7, 8
JDBC Driver	Oracle Thin	11.2.0.3
	DB2 Universal Driver	3.58.81
	Microsoft SQL Server JDBC	4.0
	MySQL Connect (Dev Only)	5.1.24
JDK	Oracle Java	1.7.0_40 (64-bit)
	IBM SDK	1.7 SR1 (64-bit)
Browsers	Adobe Flash Player	11.9
	Firefox	24 ESR
	Internet Explorer	9, 10
	Chrome	30
	Safari	6
Coherence Cache	Oracle Coherence	12.1.2
Business Intelligence	Oracle Business Intelligence Enterprise Edition	11.1.1.7
Development Plugins	Eclipse	3.7 JEE (Beta)

Read More

What’s New in Oracle Commerce(ATG) 11

Abstract of What’s New in Oracle Commerce(ATG) 11 are listed below. For detailed information, visit oracle site.

Brand new version of ATG 11.0 (Oracle Commerce 11) has many new features which can be divided into following categories.

1. Oracle Commerce Naming
2. Oracle Commerce Platform
3. Oracle Commerce Business Control Center
4. Oracle Commerce Workbench
5. Oracle Commerce Service Center (CSC)
6. Oracle Commerce Reference Store (CRS)

1. Oracle Commerce Naming

New naming nomenclature is used for all the products.

Previous Name	New Name
Oracle ATG Web Commerce	Oracle Commerce Platform
Oracle ATG Web Commerce Merchandising	Oracle Commerce Merchandising
Oracle ATG Web Commerce Service Center	Oracle Commerce Service Center
Oracle Endeca Guided Search	Oracle Commerce Guided Search
Oracle Endeca Experience Manager	Oracle Commerce Experience Manager
Oracle Endeca Relationship Discovery	Oracle Commerce Relationship Discovery
Oracle ATG Web Commerce Developer and Administrator	Oracle Commerce Developer and Administrator
Oracle Endeca Developer	Oracle Commerce Guided Search and Experience Manager Developer

  

2. Oracle Commerce Platform

•  Single Sign On with Oracle Access Manager Integration-The Oracle Commerce Business tools (BCC and Workbench) have been integrated with Oracle Access Manager (OAM). The BCC and Workbench can work with OAM to utilize OAM as the point of authentication for access to the tools. This allows a user to access both tools using the same credentials. Once authenticated in one tool, links are provided for the user to jump directly to the other tool without reauthenticating. Likewise, logging out of one tool ends the session for both tools.

•  CA Data Import Performance Improvements - The CA data import API’s and Scripts to import data in CA project have been updated to improve performance. And performance of New API is 10 times faster compared to previous release. The new scripts use APIs that bypass the Repository layer and issue SQL directly to the underlying Database.

• CIM Internationalization (command line tool) - With Commerce 11, CIM’s prompts and menus have been translated into 22 languages. 22 languages are listed at bottom of this post.

• Environment Promotion Improvements- Oracle Commerce Guided Search and Experience Manager applications go through a life cycle of authoring, previewing, and live modes.

3. Oracle Commerce Business Control Center

• Product Content Management (PCM)

                ->Image Thumbnails in the Merchandising UI
                ->Site Context in Browse Mode
                ->Export Prices - This feature enables users to export prices from within the Merchandising Flex                                       UI into an Excel or CSV file. The set of exportable properties for the assets are                                             fixed and cannot be edited in the UI

                 ->Promotions Management

                         Get Group Discount – group discount is new template which lets to discount to group of                                                  items (SKUs, products, Categories)

                         Maximum Discounts Per Order

                         Maximum Coupons Per Order- Site level

4. Oracle Commerce Workbench

• Localization - Workbench can be operated in 22 languages listed below. Experience Manager cartridges that come out of the box are localized in the same languages as the rest of the Workbench. Custom built cartridges may also be localized.

• Automatic Phrasing - Business users can manage multi-word search terms that will then be treated as a phrase in search queries

• Relevance Ranking Evaluator - Business users can run multiple searches simultaneously, using different relevance ranking modules and other search parameters to compare the order and quality of results returned. Users can test one or more of the sixteen different relevance ranking modules to influence search

• User Segments - Experience Manager can now refer to user segments created in the BCC

• Experience Manager Preview - Experience Manager now allows business users to make edits and preview these changes without needing to mark their changes as live for production. Business users can preview changes made by one or more users at any point in time.

5. Oracle Commerce Service Center (CSC)

• Service Enablement - additional Web Services added to 11.0 are

            o    Initiating a return or an exchange

            o     Displaying refund amounts

            o     Displaying refund confirmation

            o     Receiving a return

            o     Cancelling a return or an exchange

            o     Granting, overriding, and removing promotions

            o     Searching for promotions and identifying lost or changed promotions

            o     Adding store credit

            o     Getting closeness qualifiers messaging

            o     Reviewing, modifying, and approving an order

            o     Creating, submitting, activating, deactivating, and confirming a scheduled order

            o     Working with scheduled order templates

            o     Changing price lists and catalogs

            o     Searching for catalogs

            o     Searching, browsing, creating, deferring, reassigning, printing, editing a ticket

            o     Changing other agent preferences such as password updates and logout

            o    Composing, uploading attachments, and sending emails

• ATG Search Replaced with Database-Optimized Search for Orders and Profiles

             Supported DBs are

             o    Oracle

             o    MySQL

             o    SQL Server

             o    DB2

        

• CSC Support for New Retail-Specific Promotions

               o    Get Group Discount

               o    Maximum discounts per order

               o    Maximum coupons per order

6. Oracle Commerce Reference Store (CRS)

Oracle Commerce provides starter CRS applications for the following three channels:

1. • Web
2. • Mobile Web
3. • iOS Universal (iPhone and iPad)

Following new features are added to all three channels.

• Home Page Driven by Experience Manager
• New Storefront Branding- The ATG Store has been rebranded as CRS Store and the ATG Home store has been rebranded as the CRS Home store

CRS Web additional features are

• Store Locator Pages
• SEO Best Practices
• Brand Landing Page
• Auto-Suggest: The CRS Web application now demonstrates the use of the Guided Search Auto-Suggest capabilities

CRS Mobile Apps features are

• Product Returns- The CRS product returns feature builds on the core Commerce returns functionality to enable a shopper to easily initiate a return on orders (both as a whole order, or as individual returnable items contained within the order) within the account management area.

The 22 Locales Supported in Workbench & CIM are

Chinese (Simplified)

Finnish

Hungarian

Russian

Chinese (Traditional)

French (France)

Italian (Italy)

Spanish (Intl Sort)

Czech

German (Germany)

Polish

Swedish

Danish

Greek

Portuguese (Brazil)

Thai

Dutch (Netherlands)

Japanese

Portuguese (Portugal)

Turkish

English, US

Korean

Additional Locales (for date & time formats)

English (US)

English (UK)

English (Australia)

English (Canada)

Visit "Oracle Commerce 11.0 Supported Environments Matrix"

Read More

New to ATG

I am new to ATG?

The Most awaited post is here. This post shall be explaining the step by step guidance for learning ATG (Oracle e-Commerce) for beginners.

Please watch out below Hyperlinks for detailed description on each topics. Hyperlinks will be enabled weekly basis.

Sl no	Code	Subject	PPT Link	VT Link
1	ECM01	Introduction to e-Commerce	ECM01_PPT
2	ECM02	Introduction Oracle Commerce
3	LAB01	Installation of JDK, JBOSS
4	LAB02	Installation of Eclipse, SQL
5	LAB03	Installation of ATG10.2
6	LAB04	Running CIM
7	LAB05	DB Set up
8	LAB06	Building ATG Ear, Starting Server
9	DAF01	Understanding ATG Modules
10	LAB07	Creating myModule in Eclipse using ATG Plugin
11	DAF02	Understanding Nuclues
12	DAF03	Understanding Repository concepts
13	LAB08	Repository Lab
14	DAF04	Understanding Droplet concepts
15	LAB09	Droplet Lab
16	DAF05	Understanding Formhandler concepts
17	LAB10	Formhandler Lab
18	DAF06	Understanding Pipeline concepts
19	LAB11	Pipeline Lab

Read More

Coming Soon

Watch out for following Topics soon!!!!!

Links to following topics will be enabled periodically.

1. About ATG Framework
2. ATG Interview questions and answers
3. ATG's Droplet
4. ATG's FormHandler
5. Understanding Profile Repository
6. Understanding Order Repository
7. PriceList association to Product Catalog
8. Understanding Shopping Cart
9. Installing ATG10.x on Windows 7 (With JRE, ATG, JBOSS/Weblogic, MySQL/Oracle)
10. Installing CRS10.x on Windows 7

Read More

How to delete project from Front end of BCC

Deleting project from Front End of BCC

Note: This shall delete project along with project's associated process, assets, history.

To delete projects from front end of BCC, perform following steps.

1. Include the following jsp in custom BCC module's war.

File Name: delete-process.jsp

<%@ taglib uri="/dspTaglib" prefix="dsp" %>

<dsp:page>
<%@page import = "atg.epub.project.*" %>
<%@page import = "atg.dtm.*" %>
<%@page import = "atg.nucleus.*" %>
<%@page import = "javax.transaction.*" %>
<link href="style.css" type="text/css" rel="stylesheet"/>

<div style = "padding: 5px;">

<% boolean rollback = true;

TransactionManager tm=(TransactionManager)Nucleus.getGlobalNucleus().resolveName("/atg/dynamo/transaction/TransactionManager");
TransactionDemarcation td= new TransactionDemarcation();
        try {
            td.begin(tm);
            atg.deployment.server.SecurityManager.becomeTheSuperDood();
            ProcessHome processHome = ((ProcessHome) ProjectConstants.getPersistentHomes().getProcessHome());
            String processId = request.getParameter("process_id");
            if (processId == null) {
            out.println("TRYING HYPNOSIS TO GUESS PROCESS ID..... FAILED. Try explicitly specifying a process_id request parameter. ");
            return;
            }
            atg.epub.project.Process process =processHome.findById(processId);
            if (process == null) {
            out.println("wrong process_id parameter; not such process");
            return;
            }
            Project project = process.getProject();
            if (project == null) {
            process.delete();
            rollback = false;
            out.println("Process was found but there was no project associated with it. Process was deleted successfully.");
            return;
            }
            project.delete("publishing");
            out.println("Process with id " + processId + " was found and deleted successfully.");
            %>
            <br/> <input type = "button"
            onclick = "window.close()"
            value = "Cancel/Close"
            style = "font-size: 10px; background-color: #C3593C; color: white;"/> <% rollback = false;
        } catch (Throwable t) {
            t.printStackTrace(System.out);
            out.println(t);
        } finally {
            atg.deployment.server.SecurityManager.becomeNOTTheSuperDood();
        try {
        if (td != null) td.end(rollback);
        } catch (TransactionDemarcationException e) {
        e.printStackTrace();
        }
        }
%>
</div>
</dsp:page>

2. Identify the process id from DB using the following query.

select process_id from epub_process where display_name='name_of_project';



3. Hit the delete process URL, and pass the process id through request header.

<BCC_URL_Including_HTTP_PORT>/<context-root>/delete-process.jsp?process_id=<process_id>

ex: http://localhost:7005/mybcc/delete-process.jsp?process_id=prc162001




4. Following message confirms that the entire project is deleted.

Read More