tag:blogger.com,1999:blog-193164852024-03-14T09:34:11.479+07:00Miftakh ZeinJust Another BlogMiftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.comBlogger112125tag:blogger.com,1999:blog-19316485.post-78254853904741169112018-08-24T13:55:00.000+07:002018-08-24T13:55:51.211+07:00[PostgreSQL] Truncate Table and Reset SequenceIf we need that after TRUNCATE table, also reset the SEQUENCE then we can do this step :
1. Set the minimum value of the sequence
alter sequence mytable_id_seq minvalue 0 start with 1;
2. Now either reset it:
SELECT setval('mytable_id_seq', 0)
OR we can reset it while truncating:
truncate mytable restart identity;
Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com1tag:blogger.com,1999:blog-19316485.post-61126423369349457792018-08-09T12:54:00.001+07:002018-08-09T12:54:34.307+07:00[Oracle EBS] GL Journals Stuck With Funds Status In ProcessOur finance team has an issue with their journals. The GL Journal Batch is stuck with Funds Reservation “In Process”. This journal cannot be posted or edited.
CAUSE
The issue usually has been caused by getting a connection/network error or PC hanging while in the process of reserving Funds for a GL Journal Entry.
SOLUTION
A datafix has been required to fix these issues. The Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-7771688214619255102018-04-16T15:51:00.001+07:002018-04-16T15:51:42.688+07:00Manajemen Risiko Keamanan DataAkses jaringan internet di lingkungan kerja, serta kebebasan dalam menggunakan perangkat seperti MP3, USB, flashdisk, CD dan lainnya di kantor menjadikan kejadian pencurian data rentan terjadi. Oleh karena itu, perusahaan perlu mengambil sejumlah langkah untuk mengamankan data di lingkungan kerja.
Data merupakan sesuatu yang sangat vital bagi bisnis. Jika data sensitif sampai jatuh ke tangan Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-66579490160451886802018-01-23T15:39:00.003+07:002019-01-24T23:27:09.868+07:00[Oracle EBS] Fixed Asset Error APP-OFA-48392 in Asset Workbench
We have some issue when attempting to add a new asset in Assets Workbench, the following error occurs.
ERROR
-----------------------
APP-OFA-48392 Assets Transaction upgrade is either running or incomplete for one or more reporting currencies associated with primary depreciation book. You must first complete the upgrade before entering transactions in this book
ROOT CAUSE :
ThereMiftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-59040220091730617922018-01-23T15:08:00.001+07:002018-01-23T15:28:04.466+07:00[Linux] Upgrade PHP 5 to PHP 7 using Yum on Oracle RHEL 6.3 SantiagoMy Apache Web Server was running PHP version 5.3. But my developer need to use PHP 7.0, because they running on Laravel Framework 5.5. So I decided to upgrade PHP 5.3 to PHP 7.0. Although this is a development web server, I don’t want to disturb the existing setup and also, I don’t want to have multiple versions on PHP installed. So it should be a pure upgrade of PHP.
My environment is :
Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-20978962990922168012017-09-04T11:04:00.002+07:002017-09-04T11:12:21.504+07:00[Linux] Install php-mbstring On ORHEL 6.3I am running Oracle Red Hat Enterprise Linux Server release 6.3 (Santiago) with PHP Version 5.3.3 and Apache/2.2.15 (Oracle) installed.
Problem :
Recently, I have a new apps and got some errors:
Fatal
error: Call to undefined function mb_detect_encoding()
Cause:
This error occurs because the new application requires mbstring extension.
Solution:
So here is the solution.
1. Check phpinfoMiftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-63456478128981807942017-07-25T15:19:00.002+07:002017-07-25T15:19:58.674+07:00[Oracle EBS] ORA-01591 In-Doubt Transactions
Problem :
ORA-01591: lock held by in-doubt distributed transaction.
Saat sedang melakukan query ke database oracle untuk mengambil data tertentu dengan filter/kondisi where,
tau2 terjadi error. Padahal itu adalah query dengan kondisi where biasa
dan tidak terlalu rumit. Saat dicoba query tanpa kondisi where, tidak
terjadi error. Errornya adalah :
ORA-01591: lock held by in-doubt distributedMiftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-86634805067547924002017-07-25T11:52:00.005+07:002017-07-25T15:22:38.512+07:00 [Oracle EBS] Query to list Reports assigned to a Responsibility
On Oracle E Business Suites, if we want to view any report that attaches to a responsibilities, we can use this following Query.
SELECT fcpl.user_concurrent_program_name "REPORT NAME",
fnrtl.responsibility_name, frg.request_group_name,
&Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-55730803806412545122017-07-24T12:00:00.000+07:002017-07-25T13:53:32.713+07:00[Oracle EBS] Query Period Status
Period status didalam Oracle Application (EBS / E-Business Suite) sangat
penting. Karena saat mau melakukan posting maupun memproses transaksi
dibutuhkan period yang open/future tergantung pada Aplikasi (modul) yang
dipergunakan. Suatu perusahaan atau organisasi bisa menggunakan banyak
modul seperti General Ledger, Inventory, Payables, Receivables, dan
lain-lain. Jika kita ingin memeriksa Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-76156345680625746262016-12-09T17:32:00.000+07:002017-01-05T17:41:49.491+07:00[Linux] SSL Certificates, Private Keys and CSRs with OpenSSLOpenSSL is an open-source implementation of the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS) protocols.
Generate a Private Key and a CSR
This begins the process of generating two files: the Private-Key
file for the decryption of your SSL Certificate, and a certificate signing request (CSR)
file (used to apply for your SSL Certificate).
# openssl req -new Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-10894505261434334832016-12-06T11:03:00.000+07:002017-01-04T11:11:46.772+07:00[Apache] Redirect HTTP To HTTPSIf we want to redirect our web site to always be sent over SSL (HTTP TO HTTPS). We can do this :
1. Using Virtual Host
Just add this into apache config
<VirtualHost *:80> ServerName example.com Redirect / https://example.com/</VirtualHost>
<VirtualHost _default_:443> ServerName secure.example.com DocumentRoot /usr/Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-62673621981531646312016-10-24T09:37:00.000+07:002016-12-06T10:14:34.705+07:00[Linux] Transfer Files Or Folder Using SCPIt is very easy to transfer files on linux operating system, we can use scp (secure copy). scp allows files / folder to be copied to, from, or between different hosts. It uses ssh for data transfer and provides the same authentication and same level of security as ssh.
1. Copy from local host to remote host
scp /path/to/source-file user@remotehost:/path/to/destination-folder/
2. Copy from Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-92125247942234728972016-10-04T10:29:00.001+07:002016-10-05T18:15:36.401+07:00 [Oracle EBS] Query To Find Application Name And Short NameThis query can be used to lists all the applications related information and to find the APPLICATION_SHORT_NAME of a module (eg. Payables, Receivables, Order Management, etc.)
SELECT fa.application_id "Application ID", fat.application_name "Application Name",Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-67748312341485357242016-10-04T10:29:00.000+07:002016-10-05T09:16:07.012+07:00[Oracle EBS] Change EBS User Password Using PL/SQLIf you have a locked EBS user account or need to change the user passwords using FND_USER_PKG.changePassword API with PL / SQL then you can use the following script
declarebeginif FND_USER_PKG.changePassword ('USERNAME','NEW_PASSWORD')
then dbms_output.put_line(1);
else
dbms_output.put_line(2) ;end if;end;
Don't forget to commit.Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-76059681031981257122016-09-22T09:22:00.000+07:002016-09-28T11:46:11.943+07:00[Oracle Siebel CRM] Query Last User ActiveOracle Siebel CRM 8.1 use dba_users table for the application user. But the user activitiy history is stored into table at siebel schema. Here the query to get the user last active / last login date.
SELECT LOGIN, MAX(TANGGAL) LAST_TRANS_DATEFROM (SELECT S.LOGIN, MAX(TRUNC(PEL.LAST_UPD)) TANGGALFROM SIEBEL.S_ASSET_RDNG PEL, SIEBEL.S_USER SWHERE PEL.LAST_UPD_BY =S.ROW_IDAND EXISTS (SELECT 1 Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com1tag:blogger.com,1999:blog-19316485.post-22898770771334585112016-08-26T14:34:00.000+07:002016-09-14T14:36:50.346+07:00 [Oracle EBS] Archive and Purge GL Balances and Journals
We can archive and purge account balances, as well as journal batches, entries, lines, and associated journal references for one or more accounting periods, provided the periods are permanently closed.
To Archive, navigate to Responsibility General Ledger Super User - Setup - System - Purge
The Archive process is move data from GL table to GL archive tables. Data from tables is Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-23007734196315717642016-08-08T16:13:00.000+07:002016-08-10T17:07:52.638+07:00[Oracle EBS] Purge Concurrent Request and/or Manager DataOne of the important area of Concurrent Manager tuning is monitoring the space usage for the subsets within each concurrent manager. When the space in FND_CONCURRENT_PROCESSES and FND_CONCURRENT_REQUESTS exceed 50K, you can start to experience serious performance problems within your Oracle Applications. When you experience these space problems, a specific request called “Purge Concurrent Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-59472458420869549502016-05-12T19:02:00.001+07:002016-05-12T19:07:31.582+07:00[Oracle] How To Execute INSERT Statements From File(en)
How to execute a sql script on oracle? Use this command :
SQL> @<path>\<filename>
(id)
Cara untuk melakukan insert data ke database Oracle dari file (bisa berupa .txt maupun .sql) yang berisi insert statement, bisa menggunakan command berikut ini :
SQL> @<path>\<filename>
Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-8443609585478152762016-02-22T10:48:00.001+07:002016-02-22T10:48:58.866+07:00 [Oracle EBS] Query Apply Patch ListingQuery untuk melihat list apply patch :
SELECT patch_name, patch_type, maint_pack_level, creation_dateFROM applsys.ad_applied_patchesORDER BY creation_date DESC Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-81631603011983323532015-11-02T09:38:00.001+07:002015-11-02T09:38:45.197+07:00[Oracle EBS] Query to list Reports assigned to a ResponsibilityUntuk melihat Report apa saja yang menempel pada suatu responsibilities bisa menggunakan Query berikut ini :
SELECT fcpl.user_concurrent_program_name "REPORT NAME",
fnrtl.responsibility_name, frg.request_group_name,
Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-24213219142045517732015-03-10T15:00:00.000+07:002017-08-28T16:25:56.735+07:00KriptografiKriptografi adalah suatu ilmu yang mempelajari bagaimana cara menjaga agar data atau pesan tetap aman saat dikirimkan, dari pengirim ke penerima tanpa mengalami gangguan dari pihak ketiga. Menurut Bruce Scheiner dalam bukunya "Applied Cryptography", kriptografi adalah ilmu pengetahuan dan seni menjaga message-message agar tetap aman (secure).
Dalam kriptografi terdapat dua konsep utama yakni Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-40779705732830525172014-11-12T16:30:00.000+07:002018-04-17T10:15:44.746+07:00PDCA (Plan, Do, Check, Act) Pada ISMSDi dalam ISO/IEC 27001:2005 disebutkan bahwa ISMS (Information Security Management System) / SMKI (Sistem Manajemen Keamanan Informasi) merupakan suatu proses yang disusun berdasarkan pendekatan risiko bisnis untuk merencanakan (Plan), mengimplementasikan dan mengoperasikan (Do), memonitor dan meninjau ulang (Check) serta memlihara dan meningkatkan atau mengembangkan (Act) terhadap keamanan Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-54958330865650516032014-05-11T21:17:00.000+07:002015-11-02T09:39:27.708+07:00 [Oracle EBS] Query to list Active Responsibilities assigned to Active User Kadang-kadang kita kesulitan untuk mengelola user yang ada di Oracle EBS. Untuk mempermudah dalam melakukan audit user dan responsibility yang ada di oracle EBS kita bisa menggunakan query berikut ini untuk memunculkan user-user dan responsibility yang aktif.
SELECT fu.user_name, frv.responsibility_name, TO_CHAR (furgd.start_date, 'DD-MON-RRRR') "START_DATE", TO_CHAR (furgd.end_date, 'DD-MON-RRRRMiftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-17750104883833829312014-05-11T12:07:00.000+07:002017-08-28T14:59:40.141+07:00Don't Look BehindSudah lama sekali rasanya saya tidak mengunjungi, lebih-lebih menulis di blog ini. Saya baca-baca lagi yang ada di blog ini, bahasanya kok aneh pake bangeeet... Hahaha...
Gila bener, postingan awal adalah tahun 2005, itu adalah awal-awal saya kuliah dan postingan akhir adalah tahun 2007. Tulisannya acak adul. Dan syukurlah tidak ada yang mengunjungi blog ini. 100% mati suri.
Eniwei, Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0tag:blogger.com,1999:blog-19316485.post-27608334072261593892013-05-05T10:21:00.000+07:002017-08-28T10:38:27.724+07:00One Time PadOne Time Pad adalah salah satu contoh metode kriptografi dengan algoritma jenis simetri. Ditemukan pada tahun 1917 oleh Major Yoseph Mouborgne dan Gilbert Vernam pada perang dunia ke dua. Metode ini telah diklaim sebagai satu-satunya algoritma kriptografi sempurna yang tidak dapat dipecahkan.
Suatu algoritma dikatakan aman, apabila tidak ada cara untuk menemukan plaintext-nya Sampai saat ini, Miftakh Taptozanihttp://www.blogger.com/profile/17284206950892283557noreply@blogger.com0