Oracle Apex Projects

Oracle Apex reporting

I need you to do reporting for an already established Application. The following are to be configured: 1. User Login and Roles: I. To be able to use Email to login based on their CARD_NUMBER and COMPANY_ID II. Verify the Email Address and Change Password III. Different Roles as Per Administrator per company and users per company IV. ADMINISTRATORS: This will be per company have access to APPROVAL and the whole access to the application for the COMPANY_ID V. USERS: Have Access to Specific templates and REPORTS 2. USER ACCESS to the following: I. USER_DETAILS TABLE (ONLY THE SPECIFIC RECORDS) II. REPORTS (ONLY THE SPECIFIC RECORDS) III. INITIAL CONTRIBUTION FORM - CREATE/EDIT/CANCEL (THIS IS SUBJECT TO ADMINISTRATOR APPROVAL) IV. INITIAL LOAN FORM - CREATE/EDIT/CANCEL (THIS IS SUBJECT TO ADMINISTRATOR APPROVAL) 3. Reform the user report: I. USER_DETAILS report II. CONTRIBUTION REPORT TO HAVE LINK TO EDIT/CANCEL (Contribution Type is C then color Blue, When W then color Red, others Green) III. LOAN_DETAILS REPORT TO HAVE LINK TO EDIT/CANCEL IV. LOAN_REPAYMENT_DETAILS REPORT TO HAVE LINK TO EDIT/CANCEL V. WITHDRAWAL REPORT TO HAVE LINK TO EDIT/CANCEL VI. OPENING_BALANCE REPORT TO HAVE LINK TO EDIT/CANCEL VII. MONTHLY REPORT VIII. ACCOUNTING SUMMARY Target is a day delivery and price negotiable

pre-funded

SAlesforce Problem solving

Problem Consider the following problem: Our sales organization uses Salesforce. It also frequently uses an external system (call it “Foobar”) in which the sales reps search for specific contacts. Once they have assembled a list of contacts, they request Foobar to inject these contacts into Salesforce as Leads. Foobar uses the sales rep’s credentials via OAUTH to authenticate to Salesforce and injects the Leads via the Salesforce API. The list may be as short as one Lead or as long as several hundred Leads. Our Marketing team wants these leads to be grouped via Salesforce Campaign records. That is, all the leads injected as a list by the sales rep from Foobar in a short period should be grouped, even if they arrive in more than one batch. Instructions Please set up a Salesforce instance (a Trailhead playground or a standard developer org) where you implement this using Apex and give us access to this instance. Your code should: Respond to insertions of Leads. Recognize leads injected by Foobar based on LeadSource = “Foobar”. Whenever the sales rep requests Foobar to inject one or more leads into Salesforce, recognize that a new list is being inserted and create a new Campaign to group them. Leads inserted within a short period should be part of the same campaign. The campaign should have a name that includes the string “Foobar”, the sales rep’s name, and a representation of the time the list was injected. All the Leads in the list should be associated with the Campaign via CampaignMember records. Be covered by unit tests. Follow Apex developer best practices. As this is a proof-of-concept, you are not expected to solve all possible operational and scaling issues now. However, please note in the code why you decided to take a shortcut or how it can be addressed in the future as a TODO item for the code reviewer. You will also be asked for a plan to address these concerns in your delivered project . Decide which abstractions are essential and which can be added later to meet these time constraints. It is also perfectly acceptable to submit a partial solution. Of course, the more complete the implementation, the better the advantage over partial ones. I will need explanation for each code and also a video Q&A Session afterwards to explain the solution.

Operations Assistant (Supply Chain & Procurement)

We are looking to hire an A TYPE PERSONALITY FAST MOVING PLAYER assistant for our beauty e-commerce & B2B Wholesale operations. Hard-working individual, who strives for excellence & is looking for a long-term partnership. We are one of the leading ecommerce beauty companies in the UK specializing in high-quality beauty products. We are committed to delivering exceptional customer experiences and maintaining strong relationships with our B2B partners. Our innovative and fast-paced environment offers a great opportunity for growth and development. Job Description: We are seeking a highly organized and detail-oriented Supply Chain & Procurement Assistant to join our team. In this role, you will support the supply chain operations, ensuring efficient and effective processes that meet the needs of our e-commerce and B2B operations. The ideal candidate will have a passion for the beauty industry, excellent communication skills, and the ability to thrive in a dynamic work environment. Key Responsibilities: • Assist in the overall supply chain management • Coordinate with suppliers and vendors to ensure timely delivery of products. • Monitor and track shipments, resolving any issues that arise. • Maintain accurate records of inventory, orders, and shipments. • Support the procurement process by preparing purchase orders and managing supplier relationships. • Collaborate with the logistics team to streamline distribution processes. • Generate and analyze reports on inventory levels, order status, and supply chain performance. • Assist in the implementation of supply chain strategies to improve efficiency and reduce costs. • Provide administrative support to the supply chain team as needed. Qualifications: • Study in Business management, logistics, business administration, or a related field preferred. • Previous experience in a supply chain, logistics, or related role, preferably in the ecommerce or beauty industry. • Proficiency in supply chain management software (e.g., SAP, Oracle, or other ERP systems) and Microsoft Office Suite (Excel, Word, PowerPoint). • Strong organizational skills and the ability to manage multiple tasks simultaneously. • Excellent communication and interpersonal skills. • Attention to detail and a high level of accuracy in data entry and documentation. • Ability to analyze data and generate reports. • Problem-solving skills and the ability to resolve issues efficiently. • Flexibility to adapt to changing environments and responsibilities. Preferred Qualifications: • Certifications in supply chain management or logistics • Knowledge of the beauty industry and its supply chain processes. Interested candidates are invited to submit their resume and cover letter detailing their qualifications and experience with the subject line: A Type Personality Supply Chain Operations Assistant Application. Preferred Working Hour: 9:00 - 17:00 BST Flexible Time. On-going Part Time are welcome to apply Please state at least 3 core values towards work and attach your CV when you submit your proposal. Thank you.

opportunity

Saas software developer

The project description is as follows: We are looking for a skilled Saas software developer to join our team and help us develop and maintain our platform. The ideal candidate should have experience with Saas development, be familiar with modern web technologies, and have a strong understanding of software development principles. Responsibilities: Develop and maintain the Saas platform, including front-end and back-end components. Work with a team of developers to design and implement new features and functionality. Write clean, efficient, and scalable code. Collaborate with other team members to ensure that the platform meets the needs of our users. Stay up-to-date with the latest trends in Saas development. Requirements: Bachelor's degree in Computer Science or a related field. Strong experience with Saas development, including experience with popular Saas platforms such as Salesforce, Oracle, or SAP. Experience with modern web technologies, including HTML, CSS, JavaScript, and React. Strong understanding of software development principles, including object-oriented programming, design patterns, and testing. Excellent problem-solving skills and attention to detail. Ability to work independently and as part of a team. Excellent communication skills. If you are a skilled Saas software developer with a passion for building great products, we would like to hear from you. Please submit your resume and cover letter for consideration.

Need artwork resized for printers

Hi I’ve been helping a client design her oracle cards for printing but the printing company keeps coming back looking for specific resizing that I don’t have the time to do. I’ve all the artwork on Canva so I just need someone to check and if needs be slightly resize everything ( cards, box and guidebook) to the measurements the printers need. I’m not to familiar with bleed areas etc. Need asap

opportunitypre-funded

1 hr advanced training Salesforce Flow HTTP Post w/nested JSON

Hello! I am an advanced Salesforce.com consultant/Flow user/developer and require a screen-sharing Zoom training on the advanced use of the relatively new Salesforce Flow HTTP Post callout function required for a specific purpose. I have been struggling to take in a single JSON text string with a 3 level nest of JSON objects in one HTTP Post callout response to Salesforce (I.e. a list of Grandparents, Parents and Children records. I have the objects and Flow built, the HTTP Post callout and the web service responding with the JSON response successfully but somehow in the setting up of the External Service action/response sample, I am struggling to take the data in and map it so that I can create the records in Salesforce. I presume that we can create the records either with a series of progressive loops in the Flow, (but ideally we would map and use the Transform element. Is this possible and if so, would we be able to do a paid consulting hour (I am based in the UK) on my Zoom account to show me how to do it? I believe that the solution lies in some error in the Apex defined variables used in the creation of the external service. Please only reply if: - you fully understand the requirements and how to solve this issue (I am confident in building Flows and using HTTP callouts. I am not looking for general training on this - it is the multi-nested response and Apex record variable callout response specific help needed. If you don't know the answer, the hour session will not be enough for a trial and error approach. I have done this already and gone round in circles :-) - You can solve the issue in Flow only. I am not looking for a suggestion of an alternative Apex only solution - We can hold the Zoom screen share session in English The solution to this I think should be able to be delivered in 20 minutes, so if we can do that, I am happy to end the session right there and complete the project and payment. I will have prepared the org, data and Flow and will these ready for us to jump straight in, so having described the requirement above, will be expecting us to jump straight into the solution (there is only 2 fields to map - Name and Age) in the Grandparent, Parent, Child schema. Thanks and look forward to hearing back! Will

opportunity

Structural Design of 12m x 24m Steel Portal Frame Building

I have a preliminary design (3 sample pages are attached) for a 12m x 24m steel portal frame building, with an overall height of 3.9m to the apex, a 6° roof slope and externally clad in a restraining-type metal profiled sheet. The building will be located in East-Norfolk, UK. This preliminary design gives an overview of what I’d like to achieve, including the use of inset purlins to comply with planning restrictions on overall building height. Extra to the standard design, I would also be interested in your opinion on the best method for including roof overhangs, the last page of the preliminary design ('AH-SPFW-8.png' attached) details a brief overview of what I’d like to achieve. I have also had a ground report completed on the site where the building will be located. The project requirements: Structural analysis and structural design calculations for the primary steelwork of the 12m x 24m steel portal frame building, ensuring the design complies with the relevant British Standards and Eurocodes for structural design. This includes • Design of portal frames and gable frames providing sizes and specification of members with all the necessary details for manufacture. • Design of stability bracing • Connections design and detailing, including at the haunch, at the apex and at the base considering fire boundary conditions. • Design of suitable strip and pad footings • Design of ground bearing slab capable of carrying a forklift and other small plant. • Opinions on best method for including roof overhangs in the design and including the relevant design details and specifications for manufacture if required. • Advice on UK fire boundary conditions I’m proficient with Fusion 360 and am happy to create the design file using details from your calculations.

Sourcing Datasets for Audit Analytics

I need assistance in sourcing high-quality, industry-relevant datasets for internal audit data analytics, particularly within the finance industry, focusing on internal audit and risk management. The datasets should simulate real-world scenarios, showcasing cross-system integrations where data flows between systems- free to use, distribute, and modify without restrictions. Key requirements: • Cross-system data flows to replicate real-world business processes. • Dataset size: Large enough to enable meaningful analytics but manageable for analysis, with enough data points to perform rule-based testing, fraud detection, anomaly detection, and machine learning. Areas for datasets: 1. Customer Relationship Management: o CRM Systems: Data related to customer interactions, such as sales pipelines, customer support, and service requests. Integration with workflow systems for task assignment and tracking. Ticketing system data for resolution tracking and escalation workflows. o Eg: Salesforce, HubSpot, Microsoft Dynamics. 2. Financial Transactions: o Financial Approval Systems: Approval workflow data for purchase orders, vendor payments, and authorisation processes. o Execution Systems: Systems responsible for the actual execution of transactions (e.g., ERP systems for payments). o Fund Transfer Systems: Bank transaction records, transfers between accounts, reconciliation, and intercompany fund transfers. o Eg: SAP, Oracle Financials, QuickBooks. 3. Human Resources (HR): o HR Management Systems: Payroll data, employee records, leave management, and performance evaluation data. Data on employee onboarding, compensation, benefits, and termination. o Time Management Systems: Time tracking and attendance data, leave balance calculations. o Eg: Workday 4. IT and Cybersecurity: o Cybersecurity Systems: Network logs, firewall events, and data from security incident and event management (SIEM) systems. Incident response workflows, access control logs, and vulnerability management. o IT Operations: Systems data related to IT asset management, software updates, and system performance monitoring. o Examples: Splunk, Cisco Security, Palo Alto Networks, CrowdStrike, ServiceNow. 5. Operations and Workflow: o Workflow Management Systems: Workflow and task management systems that track operational processes and task completion. o Operations Data: Task tracking, issue resolution workflows, and operations performance metrics. o Ticketing Systems: Data on incident management, service desk requests, and help desk tracking. Eg.ServiceNow, JIRA, Monday.com. 6. Governance, Risk, and Compliance: o GRC Systems: Risk assessment data, internal audit trails, and compliance monitoring. Data on policy enforcement, internal controls, and external regulatory compliance. o Regulatory Reporting Systems: Data related to mandatory reporting, such as GDPR compliance, Sarbanes-Oxley (SOX) compliance, and financial reporting regulations. o Eg. RSA Archer, MetricStream, IBM OpenPages, TeamMate. 7. Supply Chain Management: o Procurement Systems: Data on vendor management, purchase orders, contract tracking, and supplier performance. o Inventory Management Systems: Stock levels, reorder points, warehouse operations, and shipping data. o Vendor Payment Systems: Data on vendor payments, reconciliation, and procurement-to-pay cycles. o Eg.SAP Ariba, Oracle SCM, Coupa. 8. Trading and Portfolio Management Systems: o Front Office:  Trade Execution Data: Information on executed trades, including timestamps, volumes, prices, and counterparties.  Market Data: Real-time or historical market prices for stocks, bonds, derivatives, etc.  Portfolio Management: Data on holdings, asset allocation, and portfolio performance analytics.  Order Management Systems: Buy/sell orders, amendments, and cancellations. Eg. Aladdin o Middle Office:  Risk Monitoring: Risk exposure, Value at Risk (VaR), compliance with investment mandates, and stress testing data.  Trade Settlement: Data on trade confirmation and settlement, including pending or failed trades.  Regulatory Reporting: Compliance data for regulatory frameworks like MiFID II, EMIR. o Back Office:  Clearing & Settlement: Data related to clearing processes and settlement of transactions.  Custody Data: Information on safekeeping of assets, including securities, corporate actions, and dividends.  Reconciliation Data: Cash and securities reconciliation between systems, custodians, and brokers. o Related Systems:  Collateral Management: Data on margin calls and collateral allocation for derivatives.  Cash Management: Data on cash flows, fund transfers, and account balances.  FX Hedging: Currency hedging positions and exposures.  Derivative Trading: Data on options, futures, swaps, and their valuations. Deliverables: • Well-documented, accurate & complete datasets in structured/CSV format for business areas mentioned above with clear explanations of how the systems connect and data flows.

opportunity

Council Analytics Project - SQL Analysis & Power BI

hi, I have a requirement for a client project to develop a council data warehouse solution and to develop analytical data sets for end users to exploit data. The tech stack is a combination of source data in Oracle / SQL server / Excel spread sheets being loaded into a Azure SQL database. The scope will be to design and develop data sets for analysis using SQL and then to develop a set of Power BI Reports Local Council or similar experience required. Regards Pally

ONYX and ORACLE Sheffield / combine logo

I need to combine ONYX and ORACLE logo I can send your the logo for these 2

Oracle EBS Sql development please

Hi, i have a small collection of reports that i need constructed using generic EBS Sql statements. For example. "I need all general ledger data in a single sql statement with filters on the BU and period" and then you can go find the most generic SQL statement possible and get that together and send me the SQL. I need a bunch of SQL statements written for generic EBS modules, for example: 1. time and labour; 2. receivables; 3. general ledger; 4. payables; 5. purchasing; 6. hr; 7. Assets; So in each module, i'd need SQL statements that can return the granular data for those contexts. I need the SQL to be EBS generic sql so nothing fancy or over the top... raw data views basically. I'm looking for someone who can motor through the list, generate SQL statements for me and I can quickly test and OK them. This is a specific EBS resource required, with SQL specialisation.

Oracle Developer

I need a designer that is an oracle developer for an urgent a project price generate is placeholder and the task will be decided with the developer. Interested applicant should contact us

opportunity

Database Module for .NET application

I have a running application currently working and the data exchange part is by using APIs for Oracle and saving some data locally. Now will by moving to SAP S/4HANA with its own set of APIs, as well as the local data would be organized and saved into Postgresql databases. I need to create a database module that would seamlessly integrate with the application and perform the data exchange related tasks with the multiple databases. The application is .NET desktop windows application. POSTGRESQL Databases are with network access on linux. SAP S/4HANA database is cloud based, with its API provided and has minimal data exchange.

Oracle APEX Application Import Automation

We are looking for an Oracle APEX expert to develop a solution that automates the import process of large APEX applications into our Oracle APEX environment without encountering the common timeout issues associated with the standard import process. The goal is to streamline application deployments, allowing for more efficient updates and management of our APEX applications. Objectives: • Automate Application Import: Develop a procedure or set of procedures that can programmatically import an Oracle APEX application using APEX_APPLICATION_INSTALL and other relevant APEX APIs. • Background Process Implementation: Utilize DBMS_SCHEDULER or a similar approach to run the import process as a background job, ensuring that the process can complete without timing out, regardless of the application size. • Error Handling and Logging: Implement comprehensive error handling and logging mechanisms to capture and report any issues that occur during the import process. • User Interface for Upload: Create an Oracle APEX page that allows users to upload application export files and trigger the automated import process. This interface should be user-friendly and include basic validations of the uploaded files.

Full-Stack Developer with React.js and Node.js Expertise

Job Description: We are seeking a highly skilled and experienced Full-Stack Developer to join our team on a large-scale project. The ideal candidate will have a strong background in both front-end and back-end development, with specific expertise in React.js for front-end and Node.js for back-end services. This project involves building a robust, scalable, and high-performance web application that will be used by a wide range of users. Responsibilities: ● Develop and maintain the front-end of the application using React.js, ensuring high performance and responsiveness. ● Build and maintain back-end services and APIs using Node.js that will support the functionality of the web application. ● Collaborate with designers and other team members to convert designs and wireframes into high-quality code. ● Design and implementation of data storage solutions, including databases and server-side logic. ● Ensure the entire stack is designed and built for speed and scalability. ● Integrate various third-party services and APIs such as payment gateways, social media, geolocation, etc. ● Write clean, maintainable, and efficient code. ● Perform code reviews and enhance the performance of existing applications. ● Stay plugged into emerging technologies/industry trends and apply them into operations and activities. ● Provide detailed updates to project managers and stakeholders regarding development progress. Skills and Qualifications: ● Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model. ● Thorough understanding of React.js and its core principles, along with popular React.js workflows (such as Flux or Redux). ● Proficiency in Node.js and frameworks available for it (such as Express, StrongLoop, etc). ● Familiarity with RESTful APIs and experience in API design and development. ● Understanding of front-end technologies, such as HTML5 and CSS3. ● Experience with user authentication and authorization between multiple systems, servers, and environments. ● Integration of multiple data sources and databases into one system. ● Understanding of database systems such as MySQL, MongoDB, Oracle, and/or PostgreSQL. ● Knowledge of code versioning tools such as Git. ● Excellent problem-solving skills and ability to perform well in a team-oriented environment. Additional Requirements: ● Bachelor’s or master’s degree in Computer Science, Engineering, or a related subject. ● Proven track record of delivering large-scale projects successfully. ● Excellent communication skills and fluency in English. Project Details: ● Duration: 6+ months ● Hourly Rate: Negotiable based on experience ● Commitment: Full-time preferred, minimum 40 hours per week How to Apply: Interested candidates should submit a proposal detailing their qualifications, a portfolio of relevant projects, and at least two references. Please include your expected hourly rate and availability. This is a fantastic opportunity to work on a project that will be utilized globally and to expand your skills in a dynamic and supportive environment. We look forward to your applications!

opportunity

Figma desing for existing SPA Angular, AngularMaterial, ApexChar

I wrote a SPA (Angular, Angular Material, normal CSS, ApexCharts) [1]. And need to improve its UI (and maybe do some changes to UX). However I am not good at styling, therefore your main task will be to create an appealing, good looking design in Figma (take as input already existing code and UI and propose improvement) . As result of this assignment allowed fonts, their sizes, colour palettes should be specified During design limitations of Apex Charts and Angular Material should be considered [2] (not every possible design idea can be implemented due to this limitations). Execution time is one week (not later than in about 3-4 days after starting work a draft should be shown; after 7 days a final version should be handed over). It is desirable, that a logo should be designed as well, but it is not critical. Design should support only normal desk/laptop screen resolution and tablets (no need to support mobile phones). All Figma artefacts (also interim design version) should be given to the buyer by handover. I am interested to have a positive collaboration and trustful relationship. I wont be checking you or telling you how to work. If you have questions, feel free to ask. [1] https://drive.google.com/drive/folders/1U0YT8c9uD6prMHY_Kn4NdX98CJBATJ6v [2] Apex Chart - https://apexcharts.com/docs/options/theme/ - https://apexcharts.com/javascript-chart-demos/dashboards/dark/ Angular Material - https://v6.material.angular.io/guide/theming - https://m1.material.io/style/color.html#color-color-tool - https://material.angular.io/guide/theming-your-components

Cad designer - I will not reply to generic responses

People per hour Please do not reply to this advert if you don't have CAD or related software, and you haven't read my brief properly. We need you to extract several scale drawing from the 3d files of this bench alcove. We don't have 3D software. We need the scale drawings in png or pdf form. WHAT IS REQUIRED 4 plan sections with the angles of curvature and other dimensions in each: 1/curve of the bench (angle of curvature ). Please show this in plan view, also indicating the width of the bench in your plan 2/Plan section through the top of the back-rest 3/Plan section - - roughly where the ILLUMINATED clock is situated 4/Plan section through the apex (top) of the alcove. This we transfer contains the 3d files and indicates position we need the 4 sections in https://we.tl/t-UmJyzZIl7s We also need a front view and a back view of the alcove giving the - the distance between the wooden uprights - the height of the bench from the floor, - The width of the entire structure - the height of the entire structure