Resetting admin password for dyn/admin

Resetting "admin" password for dyn/admin Password after resetting: "admin123" update das_account set password='c1f59dd0bb1078b65a6c7f19f312e83ef6823716da2ba864507f1bb2eb393799' where account_name='admin'; commit; OR Delete the admin row and reinsert. delete from  das_account where account_name='admin'; Insert into das_account (ACCOUNT_NAME,TYPE,FIRST_NAME,LAST_NAME,PASSWORD,DESCRIPTION, LASTPWDUPDATE) values ('admin',1,'Andy','Administrator', 'c1f59dd0bb1078b65a6c7f19f312e83ef6823716da2ba864507f1bb2eb393799',null,to_date( '07-NOV-12','DD-MON-RR')); commit;...

Read More

Clean up Profiles from DB

--Delete custom Profile tables from your Profile repository(Only if you have extended Profile Repository) delete from dps_user_prevpwd; delete from dps_user_org; delete from dps_user_address; delete from dps_user_roles; delete from dps_user_org_anc; delete from dps_user_mailing; delete from dps_user_scenario; delete from dps_scenario_value; delete from dps_user_slot; delete from dps_usr_markers; delete from dss_user_bpmarkers; delete from dcs_usr_actvpromo; delete from dcs_usr_usedpromo; delete from dcs_user; delete from dcs_user_wishlist; delete...

Read More

Clean up Orders from DB

--Delete custom Order tables from your order repository(Only if you have extended Order Repository)delete from dcspp_schd_errmsg;delete from dcspp_sched_error;delete from dcspp_scherr_aux;delete from dbcpp_sched_clone;delete from dbcpp_sched_order;delete from dcspp_manual_adj;delete from dcspp_order_adj;delete from dcspp_det_range;delete from dcspp_det_price;delete from dcspp_itmprice_det;delete from dcspp_shipitem_tax;delete from dcspp_ntaxshipitem;delete from dcspp_taxshipitem;delete from dcspp_shipitem_sub;delete from dcspp_price_adjust;delete...

Read More

Secured Repository

Secured Repositories The Oracle ATG Web Commerce secured repository system works in conjunction with the Oracle ATG Web Commerce Security System to provide fine-grained access control to repository item descriptors, individual repository items, and individual properties through Access Control List (ACL) settings.Features:•    Control access to repository item descriptors: Control who can create, add, remove, and query items defined by an item descriptor; similar to controlling access to a whole database table.•   ...

Read More

ATG - Database connections

ATG - Database connections The following diagram explains how ATG Apps connect to their schemas. Following scenario consider three Apps, i.e Production, Staging and Publishing (CA) Application servers. Image is self explanatory. More detailed information will be updated sooner. ATG - Schema connections Note: Staging App is assumed to be Non-switching Datasource App. In next post, will detail out how ATG's Production and CSC(Customer...

Read More

ATG 10 Sample Questions- III

QUESTION NO: 56What can be done to prevent inventory data deadlocks in the database?A. UseinventoryRepository's built locking mechanism to avoid this issue.B. No additional step needed. Transaction Manager has a dead lock listener.C. It is controlled via theinvontoryLockEngine on the Client Lock Manager, which lockstheinventory.D. Useinventory Manager's acquireinventoryLocks and releaselnventoryLocks methods.E. Apply database optimistic locking on theinventory table.F. Use Custom extensions to theinventory System.Answer: DQUESTION NO: 57How does...

Read More

ATG 10 Sample Questions- II

QUESTION NO: 26Identify three methods that are supported by the Out of the Box Form handlerRepositoryFormHandler.A. RepositoryFormHandler does not provide any methods.B. CreateC. DeleteD. SelectE. UpdateF. Select AllAnswer: B,C,EQUESTION NO: 27Which three statements are true regarding slots and targeters?A. Slots offer a caching mechanism.B. Targeters offer a caching mechanism.C. The TargetingForEach droplet can accept both a slot and a targeter asinputD. Slots can be created and configuredinthe BCC.E. Targeters can be created and configuredinthe...

Read More

ATG 10 Sample Questions- I

QUESTION NO: 1 Which two ASE tasks can be performed from the ACC but not the BCC? A. creating a custom product catalog B. creating targeters C. creating scenarios D. creating slots E. creating products and SKUs Answer: C,D QUESTION NO: 2 Which three reasons justify why customers should choose Oracle ATG Web Commerce as their cross channel commerce platform? A. It is the most complete andintegrated e-commerce solutioninthe market. B. It has the most flexible, modular, and elegant architecture compared to other competing solutions. C. It features...

Read More