For loop in oracle plsql jobs

hallo, i tryed to make voll Backup and recovery via RMAN, i made all the commandos step for step, i don,t get any Error but after recovery of the database i don,t get the old data. i make that just for training i need an expert oracle admin to solve the problem , so we can make that in TEAMS together about 15 minute and you show me , why is this problem in my oracle.

I'm in need of a seasoned Oracle HCM Consultant who specializes in Core HR, Payroll, and Talent Management functionalities. Your primary location must be India, with the ability to travel to Dubai/Kuwait for a contract period of 6 months. Key Responsibilities: - Functional setup of the Oracle HCM system - Planning and executing system tests - Conducting end-user training sessions Ideal Skills and Experience: - Minimum of 6 years experience in Oracle HCM, specifically with Core HR, Payroll, and Talent Management modules - Comfortable with significant international travel Application Requirements: To apply, please include detailed descriptions of your past work in Oracle HCM systems, specifically working with the afore...

I am looking for an expert to transform my existing Oracle database for visualization in Grafana. The objective is to achieve an efficient data transfer and a fully functional system optimized for data visualization. The scope of the project includes: 1. Identifying the ideal intermediate database for the integration. 2. Implementing a reliable mechanism for data transfer from Oracle to the chosen intermediate DB. 3. Establishing a seamless interface between the intermediate DB and Grafana, and ensuring successful data publication. For this task, understanding of Oracle databases, knowledge of third-party integration tools, and expertise in Grafana is crucial. Please note, the data to be visualized are control...

I'm in need of an Oracle database expert versed in advanced database design. Your tasks will encompass creating a comprehensive design that incorporates stored procedures, views, triggers among others. The database structure is complex, therefore demanding a mastery of the aforementioned advanced concepts. The ideal candidate should: - Have demonstrable experience in Oracle database design. - Be proficient in forming complex relationships between multiple tables. - Show competency in creating stored procedures, views, triggers, and other advanced database features. Your understanding of our needs and execution will greatly influence our company's operational efficiency.

Looking a python script that can automate my tee time booking when the booking opens at a specific time in a number of days advance. Would include opening web browser chrome url to booking page input username input password click login select date of booking select preferred time enter same 4 names within player slots provided All has to be completed within a cpl of seconds Unable to select the tee time until the booking opens perform action at a specific time of day and on a selected day or run loop until action is completed - Automating tee time booking site is if you want to ID and PW, I will let you know

I am looking for a professional who can create a captivating black and white doodle video aimed at education, running for more than 3 minutes. The video is made by combining five voice clips and one video clip that I will provide. Three of the audio clips will require simple static title text. Two of the cards will require a whiteboard/cartoon/doodle style animation. The ideal candidate should: - Have experience in creating doodle videos, particularly in black and white style. - Understand how to convey educational content through engaging visuals. - Be able to able to combine audio and video clips smoothly and balance the overall sound level. Final output is a single video provided in both Quicktime and MP4 formats in a way that would be suit...

...consultant to provide information for integrating external system invoices and credit notes into Oracle Fusion Cloud ERP. Primary role will be to research and supply detailed specifications, including API endpoints, payload requirements, constraints, and mandatory data fields for successful API integration. Key Deliverables: 1. API Endpoint Information: The exact URL(s) for the API endpoint(s) that can be used to create and manage invoices and credit notes in Oracle Fusion Cloud ERP. 2. API Payload Requirements: Detailed structure of the API request payload, including all required and optional fields for invoices and credit notes, specifically tailored to the context of exporting goods. 3. Constraints and Limitations: Any constrain...

I am in the hunt for a skilled Python & SQL specialist who can help with optimizing my database. The exact type of database is yet to be specified. I am not experiencing specific performance issues at this time. However, I am looking to proactively improve its efficiency. The ideal candidate should have: - Proven experience in database management and optimization using Python and SQL. - Expert understanding of various databases and how to best optimize them. - An analytical mindset to manage and prevent possible future challenges. Experience with both MySQL, PostgreSQL, and Oracle would be advantageous, as I have yet to decide the final database type. Your input will be expected. Please include your approach to this project, relevant experiences, and re...

I am in need of a seasoned professional for my database migration project. My existing database resides on SQL Server 2022 and I am aiming to migrate it to Oracle 19c. - The size of my SQL Server database is small, amounting to under 1 GB, but there are around 450 procedures and functions which have to be migrated - Experience with handling similar sized databases and an in-depth understanding of SQL Server 2022 and Oracle 19c is a must. - Proficiency in SQL and database migrations are critical, along with a problem-solving attitude. - The freelancer must ensure smooth transition with no data loss and optimal functionality post migration. - An established process, clear communication and deadline adherence are necessary. This is a challenging rol...

1) We hade a PsgSQL database with ticker financhial data. We need to create another stre...database with ticker financhial data. We need to create another streaming data table with 1 min aggregated data for each transaction. Data table should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present ...

1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable...should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database Bot check: write price fo...

1) We hade a PsgSQL database with ticker financhial data. We need to create another stre...database with ticker financhial data. We need to create another streaming data table with 1 min aggregated data for each transaction. Data table should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present ...

Please don't use AI for your reply. So easy to spot as all AI-replies are looking very similar. Write a personal reply addressing the issues and ask relative questions regarding assignment. I want to see a good and engaging reply, excellent reviews and sample pictures. I'm looking for a PCB-designer can design and make and send me a PCB with CANBUS and connectors for NPN proxy sensors, Close loop stepper motors - RC-model servos - industrial servo motors etc. Please read the attached PDF, and as proof that you have read it, start your reply with the model number of one of the tilt-sensors we plan to use. Im not an electronic nor programmer, but a mechanical engineer, so bear with me if i don't understand the terminology all the time. Please sp...

I'm in need of an Oracle database expert versed in advanced database design. Your tasks will encompass creating a comprehensive design that incorporates stored procedures, views, triggers among others. The database structure is complex, therefore demanding a mastery of the aforementioned advanced concepts. The ideal candidate should: - Have demonstrable experience in Oracle database design. - Be proficient in forming complex relationships between multiple tables. - Show competency in creating stored procedures, views, triggers, and other advanced database features. Your understanding of our needs and execution will greatly influence our company's operational efficiency.

I'm searching for a talented designer to create an abstract and artistic loopable video to be implemented onto my website's hero section. I've found this package of backgrounds that I truly like: The package contains various colors of BG but I need only one loopable video that transitions through at least 5 colors every few seconds. Be creative with the transitions! Wipes, gradient transitions, glitches, etc., be creative! If you came up with different colors that aren't available on the package feel free to put it on the loop! Ideally, you have: - Experience in creating abstract and artistic video content. - Proficiency in producing high-quality, loopable videos for web use. I have pretty similar weekly projects, so if everythi...

I am in search of an Oracle Expert, especially skilled in working with Oracle 12c, who can assist me in setting up outbound EDI for the purpose of inventory and shipment data exchange. Here are what the tasks essentially entail: - Review and understand the EDI documents and mappings that I currently have - Assist in setting up the outbound EDI using Oracle B2B Adapter on an Oracle 12c platform The ideal candidate for this project would have solid experience handling B2B Adapter in Oracle, expertise in outbound EDI setup and a thorough understanding of EDI documents and mapping. Experience in managing inventory and shipment details on EDI will be a significant advantage.

I am in need of an experienced data entry professional who can effectively update my databases. You will only be required to work less than three hours a day from your home. Key Responsibilities: - Updating Database regularly - Ensuring data integrity and accuracy - Solving any database related issues Ideal Skills and Experience: - Proficient in Oracle, MySQL, SQL Server - Exceptional attention to detail - Prior experience in Database updating Get in touch if you fit this profile. This could be your chance to establish a regular, part-time, work-from-home position.

**Description:** Need a Motion Graphics Designer to create a vibrant, loopable animation of our logo with a vibrating effect and colorful lighting. Must be engaging for 8 hours of continuous play. **Skills:** Adobe After Effects, loop animations, vibrant effects. **Deadline:** Tomorrow. **Deliverables:** High-res, loopable animation file, suitable for large screens.

I am seeking a skilled mobile app developer to create a soccer-centric application for Android. This engaging app should feature: - Live scores: Keep users in the loop with real-time scores. - Betting integration: Seamlessly integrate with external sports betting platforms. Prior exposure to similar integration appreciated. - Club and Player Statistics: Display comprehensive data about soccer clubs and individual players. This project demands a strong understanding of sports betting systems and a passion for soccer. The ideal candidate will have a history of developing apps with similar functionality. Knowledge of live score updating features and sports statistics is a plus.

I'm looking for a freelancer with extensive experience in Business Intelligence (BI) and Oracle Database. Your task will be to develop a comprehensive BI dashboard that pulls data from an Oracle Database in real-time. Specifically, the dashboard needs to: - Connect with Oracle Databases and retrieve comprehensive data reliably. - Display a variety of data, including, but not limited to, sales figures, customer demographics, and inventory levels. - Update the displayed data in real-time to ensure that we always have the most accurate and up-to-date information. Ability to work speedily without compromising on quality is a must. Prior experience with Oracle Database is crucial. Please share your past work samples or portfolio i...

I'm in need of an Oracle database expert versed in advanced database design. Your tasks will encompass creating a comprehensive design that incorporates stored procedures, views, triggers among others. The database structure is complex, therefore demanding a mastery of the aforementioned advanced concepts. The ideal candidate should: - Have demonstrable experience in Oracle database design. - Be proficient in forming complex relationships between multiple tables. - Show competency in creating stored procedures, views, triggers, and other advanced database features. Your understanding of our needs and execution will greatly influence our company's operational efficiency.

...be a fully merged and seamless video in 4K Ultra High definition. Accuracy and precision are crucial elements because the inserted footage must fit into the background video naturally as if it was originally part of it. Brief: edit footage into a background video scene and add vintage tv effect to footage so it looks realistic? Inspiration: Background Video scene: You can loop the footage to cover entire duration of “tv footage” just make sure it looks realistic Tv footage to insert: Please include all footage in video

Android APK or ROOT Needed. We want to promote our content through Tiktok Live Stream. So it will be 24/7 content promotion. You must create an android settings for the phone where it can play the loop instead of showing the front camera. So front camera view needs to be switched to loop and it must pass TikTok Detection REQUIREMENT - CHANGE CAMERA SETTINGS INTO LOOP CONTENT - SO WHENEVER WE OPEN CAMERA IT MUST PLAY LOOP CONTENT INSTEAD SHOWING ACTUAL FRONT CAMERA

Configure cron for lottery_for_woocommerce: It is a loop lottery plugin, but the server cron needs to be configured to automatically restart the lottery after the lottery ends. Now you need to configure the plugin status to update every 2 minutes. Implement automatic restart. Document:

I'm in search of a proficient database engineer whose area of expertise lies in ERD design, SQL, PLSQL, and database application. The selected candidate will be tasked with: - Designing a medium complexity ER diagram with numerous relationships. - Implementing a PostgreSQL database application for the purpose of storing substantial customer information. The ideal candidate must have a sound knowledge of PostgreSQL, SQL, PLSQL, and be able to create succinct yet comprehensive ER diagrams with multiple relationships. Proven experience in similar projects and a knack for developing reliable storage solutions will be a plus.

I'm in need of an experienced individual who is proficient in utilizing Terraform to provision AWS services, primarily focusing on RDS databases, API gateway, lambda, and VPC. The specifications are as follow: - Implement an Oracle-based RDS instance. - Set up API Gateway alongside Lambda. - Prepares for a low traffic load. Ideal candidates will have significant experience in AWS, Oracle RDS, VPC, Terraform, and API Gateway setup. An understanding of efficient low-traffic management is a plus. Clear and frequent communication is expected for the duration of the project.

Require an experienced Oracle Linux admin to assist with the following tasks: - System Configuration - Package Installation and Updates - User and Group Management In addition to those primary tasks, there are specific security requirements that need to be addressed: - Firewall Configuration - User Access Control - Log Monitoring Skills and experience needed: OS installation( Oracle Linux) OS installation as per PDD bonding configuration for all vlans as per PDD Bios & server OS time sync OS Tunning parameters Configuration of PCS cluster as per details provided in PDD. SNMP hardware alarm integration with customer SNMP Manager audit log configuration IP tables/Network Manager/ Selinux configuration Kernel upgrade Logrotation NTP configuration...

I'm seeking a talented animator to bring my logo to life. Your primary tasks will include: - Crafting a smooth animation that elegantly fades in and out in synchronicity with the fluid movement of the logo elements. - Designing a crisp and clean animation that lasts no longer than 1-3 seconds on loop. This job is ideal for someone with a knack for minimalistic design and a proven track record in logo animation. Please include examples of previous work in your proposal. I look forward to witnessing your creativity.

I am seeking an expert in Oracle BICC and AWS S3 for a new project. The primary task is to assist in the extraction of data from Oracle BICC and transition it to an S3 bucket on AWS. Essential skills and knowledge include: - Proficiency with Oracle BICC, focusing mainly on data extraction. - Proficient knowledge in AWS, specifically with S3 service. - An understanding of the relationships between PVOs. - The ability to recommend the most suitable data format, since I haven't chosen a specific data format requirement yet. If you have these skills and are interested, I welcome your bid. Please share your previous experience with similar projects.

We are looking for an Oracle Data Integrator ODI 12C expert to support our ongoing data integration project. The ideal candidate should have experience working with ODI 12C and be able to provide ongoing support and maintenance. Scope: - Full project implementation BEST Practices Performance Optimizations KM customization - Partial integration for specific systems/modules - Data migration from one system to another Data Sources: - We have specific data sources that need to be integrated Support: - On-going support and maintenance is required Skills: - Strong knowledge of Oracle Data Integrator ODI 12C - Experience with data integration, migration, and transformation - Ability to provide ongoing support and maintenance for the project

I'm looking for a skilled animator with expertise in creating motion graphics to construct a 10-second logo sting ANIMATED GRAPHIC featuring two of my brand logos. The Life Molecular Imaging Logo attachment first, then the Neuraceq logo attachment. DO NOT alter these logos. THIS IS NOT A LOGO REDESIGN. I also don't want them appearing together in the same frame - one after the other please. Needs: - I will be using this on loop at a conference on video screens and would like a fun way to show both logos one after the other. Expectations and Requirements: - The design must incorporate my two brand colors namely red and blue for the first logo and chartreuse and teal for the second one. Both logos are attached. For reference, the...

I'm looking for an Oracle Flexcube expert, particularly skilled in customization and training. The project will focus on: - **Customization**: Your task will be to customize reports and the user interface according to our specific needs. - **Report Customization**: The aim is to improve data visualization and streamline report generation. Knowledge in creating bespoke reports from Oracle Flexcube is essential. - **User Interface Customization**: We need our interface to be more user-friendly and intuitive. Your experience in making this happen will be highly valued. - **Training**: After the customization, I'll need you to train our team to continue using and maintaining the system. The ideal candidate will have strong Oracle...

I am looking for a freelancer with experience in using FEMM (Finite Element Method Magnetics) for a project. The goalis to develop a simulation that shows the dynamics of moving magnets. The key deliverable is a Lua script that will construct the model and animate its motion in a looping sequence. Each cycle of the loop should produce an image file, which will be assembled into an animated GIF for a dynamic portrayal. It is important that the freelancer has prior experience in creating similar simulations. Precision in magnetic force calculations is not critical; however, the simulation should visually mimic the example shown on the site. The purpose of this project is to create a visual aid, not a scientifically accurate model, to b...

I am in search of an Oracle professional to lead the crucial task of migrating our less than 1TB Oracle 10g database to the 19c version. I have a comprehensive backup of the database, so data integrity and recovery won't be an issue. However, specific areas that we need expertise on are: - Oracle 19c migration - Enhanced security implementation Skills & Experience required: - Minimum of 4 years' experience with Oracle databases - Proven experience with database migration, preferably from Oracle 10g to 19c - Sound understanding of Oracle 19c's security features and how to maximize these for our business operation - Detail-oriented capability to ensure a seamless migration with minimum downtime. Your role will be ...

I'm seeking a skilled Oracle database specialist to perform various tasks such as data migration, performance tuning, and query optimization. Your experience and past work will be essential, so please include detailed project proposals. The database plays a crucial role in storing and managing data, analyzing and reporting, and integration with other systems in my project. Key Requirements: - Proven Oracle database management experience - Expertise in data migration, performance tuning, and query optimization - Ability to analyse data and produce clear reports - Expertise in integrating databases with other systems Please make sure to detail your Oracle DB experience, including any past projects you've worked on - especially i...

...build for me. On the front end users will need to be able to enter how many Brake tokens they want to buy. there will be 65,000 Brake tokens available at $1 each The Token Pricing will need to be able to Calculate the price of Brake Tokens dynamically based on the current exchange rate between BNB and USD. You can use a price oracle or external API to get the current BNB/USD price. Token Purchase Process: Display the current price of Brake Tokens in USD on the future website. Allow users to enter the amount of Brake Tokens they want to purchase. Dynamically fetch the price of BNB from an oracle, you would need to integrate with a decentralized finance (DeFi) protocol or an oracle service that provides real-time price data for BNB. This would...

I am looking for a freelancer who can help me automate specific tasks using Power Automate. I need the automation to be run whenever required, as the frequency may vary depending on the project. Skills and experience required for this project include: - Proficiency in Power Automate If you have the required skills and experience, please submit your proposal. Thank you.

I'm in need of a competent developer proficient in Python, Docker, and PyMongo for microservices development. I have the code in which the lambda function integrated with S3 Storage bucket , Need to modify it and integrate with OCI Storage bucket. OCI Is Oracle Cloud services. Second need to make build and deploy it on docker and test Key Responsibilities - Development of microservices using Python, Docker, and Pymongo - Employing best practices in microservices development to enhance flexibility Ideal Candidate Skills - Profound understanding and experience in Python programming - Extensive experience with Docker and Pymongo - Proven track record in microservices development - Strong understanding of flexible microservices...

A financial platform that analyzes, suggests, alerts and accompanies the user based on the information he/she enters. The idea is to be very user friendly Oracle or similar If it can be in a "Google" environment, the better Preferably web access The information is entered in Excel or PDF, which will require a PDF reader and also the possibility of manual entry into the platform. Possibility to be interactive with chat Lots of graphs and user friendly ways of displaying the information

I'm looking to develop a vector controlled Variable Frequency Drive (VFD) for 3 phase, with 3x400VAC input and 9kW output. The focus of this project is creating a VFD that smoothly operates machine controls in an industrial environment. The ideal candidate will have understanding and experience in: - Designing and constructing VFDs - Familiarity with the variances between pump, fan, and conveyor controls, specifically machine controls - Experience in industrial machine operation The specific required control modes for the VFD are: - V/F Control - Sensorless Vector Control - Closed-Loop Vector Control Additionally, Modbus communication capability in the VFD design is essential. I expect the freelancer to deliver a reliable, effectiv...

I need assistance with a specific aspect of my Shopify store - modifying product pages to integrate them with our inventory system. Objective: Modify the stock status display logic on the product page in Shopify to accurately reflect the availability of stock considering incoming stock transfers. Current Logic (Summary): Retrieve the current date and the date of the next incoming stock transfer. Calculate the difference in weeks between the current date and the next incoming date. Determine if the product is in stock based on the current inventory and incoming stock. Display appropriate messages based on the stock status. Proposed Modifications: Iterate through each incoming stock batch to collect the dates and quantities. Calculate the combined inventory conside...

I urgently need an expert coder well-versed with Database Management System. The specific DBMS that will be used is ...specific DBMS that will be used is not specified yet, so the ideal freelancer will be someone comfortable working with multiple types including MySQL, Oracle, SQL Server, PostgreSQL, MongoDB etc. Key requirements: - Extensive knowledge and experience in various Database Management Systems - Flexibility and adaptability to any DBMS - Ability to deliver high-quality work on a urgent timeline This project has a high level of priority, so I need someone who can start working immediately. I'm looking for a freelancer who can communicate effectively and complete the project ASAP. Your expertise in navigating different DBMS will be a significan...

In need of an SQL/PLSQL developer proficient in writing intermediate SQL queries, specifically JOIN operations and subqueries. The project involves manipulation of numerical/textual data. The ideal candidate should have: - Strong experience in SQL/PLSQL development - Proven track record of writing advanced SQL queries including JOIN operations and subqueries - Excellent understanding of numerical data manipulation - Demonstrated ability to deliver efficiently and accurately This is a short-term project with the potential for future collaborations. Your responsiveness and attention to detail will be appeciated.

We have a Wordpress site where people register their children for a sports league through Gravity Forms. After registration, their info is pushed into into another system called FreeAgent through custom code and the FreeAgent API. Last season, some enries didn't get pushed over and we were missing data, so we want to create an automated verification process that will verify the data was passed over, and if it's missing, push the data over again. Details are below. 1. All code can be found in our child theme and childtheme/funcincludes/ 2. I've setup a dev site for you to work on 3. The form is here: (pw: play) 4. Form id is 118 5. We would like to open up registration on Tuesday 3/26. Looking

I am on a quest for an innovative and inventive mind who masters the art of graphic design, logo design, and website design. Your mission, if you choose to accept it, will be to help me in my brand-building journey. Key Responsibilities: - Crafting of an impactful, unique logo that stands out - Graphic designing that's aimed at engaging a specific demographic - Web design that truly shines my brand's unique personality The ultimate goal of this project is branding. Ideal Skills and Experience: - Proven experience in graphic, logo and website design - Ability to understand target audiences and translate insights into designs - Experience in creating designs for specific demographics - Strong branding understanding. I expect from you to provi...

The Project: We have successfully migrated our sites to 14 but have identified a critical performance bottleneck: the event loop metric, as measured through New Relic, has tripled in size. This increase is primarily attributed to the changes in the 14 app router. We are looking for a Performance Specialist to diagnose, address, and optimize this issue to meet our stringent performance benchmarks. Responsibilities: Conduct a thorough analysis to identify the root causes of the increased event loop size in our Node VMs post-migration. Develop and implement strategies to optimize the event loop, specifically focusing on mitigations related to the 14 app router changes. Work closely with our development team to implement performance ...

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

...substantial experience in Oracle Service Bus integration to help in integrating my entire system. As an integral part of this project, the primary focus will revolve around integrating our CRM, ERP, and e-commerce platform using the Oracle Service Bus. Essential Functions: • The freelancer will be tasked with integrating other business process data as part of the project execution. • An essential part of this project will require the integration of an analytics tool. Ideal Skills: • Proficiency in Oracle Service Bus Integration • Experience with CRM and ERP system integration • Proficiency in analytics tool integration • Strong collaborative abilities and problem-solving skills This project offers an e...

1. Creation of an abstract logo that both captures attention and clearly communicates our brand's identity. 2. Usage of cool color #3F51B5 and others. 3. The logo stands for p, c and g. 4. The logo also stands for Chinese oracle word 君 like it in the attachments. 5. Provide original design files (ie. psd), one color version and another gray version from the same original design file.

I'm in need of an expert who can adeptly build a less than 10-table database on MySQL or Oracle. Its purpose will cover three key areas: - Storing customer information - Managing inventory - Tracking sales data Given that the data involved is non-sensitive, its security requirement is low. However, I value accuracy and efficiency with an emphasis on user-friendly navigation. Ideal candidates should have experience with MySQL or Oracle database creation and management, including effective table structuring and data optimization. Familiarity with inventory management and sales tracking is a plus.