Pengembangan Sistem Oracle Forms untuk Optimisasi Proses Penjualan di PT.XYZ

Ambrosius Ludang G.A; Evangs Mailoa

doi:10.35870/jimik.v5i2.711

Vol. 5 No. 2 (2024) • Articles

Open Access

Pengembangan Sistem Oracle Forms untuk Optimisasi Proses Penjualan di PT.XYZ

Ambrosius Ludang G.A

Universitas Kristen Satya Wacana

Evangs Mailoa

Universitas Kristen Satya Wacana

DOI: https://doi.org/10.35870/jimik.v5i2.711

Published: May 10, 2024 Pages: 1532-1542

Original Full-Text Article

Download published version for reading and archiving

Download PDF

Abstract

This research focuses on the development of an efficient sales system for PT. XYZ a retail company in Indonesia. The company faces challenges in its sales processes due to the lack of efficiency in the manual system, which is susceptible to errors. The research aims to optimize the sales process by utilizing Oracle Forms 10g and implementing the Rapid Application Development (RAD) methodology to ensure timely solutions. The developed system demonstrates a significant improvement in efficiency, accuracy, and speed. The use of Oracle Forms and SQL Developer simplifies data entry and management processes, while the implementation of List of Values (LOV) reduces errors and enhances data consistency. Furthermore, the system provides real-time insights into sales performance, enabling better decision-making and strategic planning for the company.

Keywords:

Sales Process Optimization PL/SQL Oracle Forms Rapid Application Development (RAD) List of Values (LOV) SQL Developer

Article Metrics & Downloads Graph

Monthly Download Trends:

Author Biographies

Ambrosius Ludang G.A Universitas Kristen Satya Wacana

Program Studi Teknik Informatika, Fakultas Teknologi Informasi, Universitas Kristen Satya Wacana, Kota Salatiga, Provinsi Jawa Tengah, Indonesia

Evangs Mailoa Universitas Kristen Satya Wacana

Program Studi Teknik Informatika, Fakultas Teknologi Informasi, Universitas Kristen Satya Wacana, Kota Salatiga, Provinsi Jawa Tengah, Indonesia.

How to Cite

G.A, A. L., & Mailoa, E. (2024). Pengembangan Sistem Oracle Forms untuk Optimisasi Proses Penjualan di PT.XYZ. Jurnal Indonesia : Manajemen Informatika Dan Komunikasi, 5(2), 1532-1542. https://doi.org/10.35870/jimik.v5i2.711

License

Creative Commons Attribution 4.0 International License (CC BY 4.0)

This is an open-access article distributed under the terms of the Creative Commons Attribution 4.0 International License .

Share: You are free to copy, distribute, and transmit the work in any medium or format.
Adapt: You are free to remix, transform, and build upon the work for any purpose, even commercially.
Attribution: You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Copyright & Retention: Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

References

Total: 13 References

Azzahra, Z. F., & Anggoro, A. D. (2022). Analisis Teknik Entity-Relationship Diagram dalam Perancangan Database Sebuah Literature Review. INTECH (Informatika dan Teknologi), 3(1), 8-11.
Cholifah, W. N., Yulianingsih, Y., & Sagita, S. M. (2018). Pengujian black box testing pada aplikasi action & strategy berbasis android dengan teknologi phonegap. STRING (Satuan Tulisan Riset dan Inovasi Teknologi), 3(2), 206-210. DOI: http://dx.doi.org/10.30998/string.v3i2.3048.
Helmud, E. (2021). Optimasi Basis Data Oracle Menggunakan Complex View Studi Kasus: PT. Berkat Optimis Sejahtera (PT. BOS) Pangkalpinang. Jurnal Informanika, 7(1), 80-86.
Hutabri, E., & Putri, A. D. (2019). Perancangan Media Pembelajaran Interaktif Berbasis Android Pada Mata Pelajaran Ilmu Pengetahuan Sosial Untuk Anak Sekolah Dasar. Jurnal Sustainable: Jurnal Hasil Penelitian Dan Industri Terapan, 8(2), 57-64.
Kase, J. S. P., & Saian, P. O. N. (2023). Pengembangan Aplikasi Reporting Penentuan Kuantitas Maksimum Pada Sistem Aplikasi Operasi Perusahaan XYZ Menggunakan Flask Framework. JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika), 8(4), 1288-1299.

Prasetyo, D. A. B. (2022). Implementasi Information Schema Database Pada PostgreSQL untuk Pembuatan Tabel Informasi dengan Menggunakan Python Di PT XYZ. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 9(3), 1961-1972. DOI: https://doi.org/10.35957/jatisi.v9i3.2221.
Purwoko, H. (2018). Pemanfaatan Basis Data Oracle Pada Sistem Informasi Work Order Pada PT XYZ Di Jakarta Timur. Journal of Computer Engineering System and Science, 3(2), 117-121.
Rahman, A. (2020). Rapid Application Development Sistem Pembelajaran Daring Berbasis Android. INTECH (Informatika dan Teknologi), 1(2), 20-25.
Santoso, B. B., & Saian, P. O. N. (2023). Implementasi Flask Framework pada Development Modul Reporting Aplikasi Sistem Informasi Helpdesk di PT. XYZ. Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi), 7(2), 217-226.
Sonata, F. (2019). Pemanfaatan UML (Unified Modeling Language) dalam perancangan sistem informasi e-commerce jenis customer-to-customer. Jurnal Komunika: Jurnal Komunikasi, Media Dan Informatika, 8(1), 22-31. DOI: https://doi.org/10.31504/komunika.v8i1.1832.
Sudiatmo, A. (2021). Sistem Informasi Manajemen Gudang Obat Menggunakan Database Dan Form Oracle Di Pt. Leuwitex. Naratif: Jurnal Nasional Riset, Aplikasi dan Teknik Informatika, 3(1), 64-70. DOI: https://doi.org/10.53580/naratif.v3i01.122.
Wahid, B. A. (2019). Penerapan Metode Rapid Application Development Terhadap Penjualan Fashion Distro Secara Online. Jurnal Esensi Infokom: Jurnal Esensi Sistem Informasi dan Sistem Komputer, 3(1), 33-39.
Winarti, W., Ihsan, M., & Wulandari, N. (2020). Perancangan Sistem Informasi Penjualan Berbasis Web pada Toko Campus Mart Unimuda Sorong dengan PHP Dan MySql. JURNAL PETISI (Pendidikan Teknologi Informasi), 1(1), 44-56. DOI: https://doi.org/10.36232/jurnalpetisi.v1i1.390.