Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jan 26, 2012, 2:01 am
The script below is used to populate the order import interface tables using data from an existing sales order.
Interface Tables:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PAYMENTS_INTERFACE
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
Base Tables:
OE_ORDER_HEADERS_A... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jan 19, 2012, 11:17 pm
Transact Move Order
Allocating Move Order using inv_replenish_detail_pub.line_details_pub.
To delete the lot allocation record use inv_trx_util_pub.delete_lot_ser_trx and to insert new lot allocation record use inv_trx_util_pub.insert_lot_trx.
Transact Move Order using inv_pick_wave_pick_confirm_... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jan 19, 2012, 10:47 pm
The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so t... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jun 1, 2011, 2:59 am
If you have rows on the view DBA_2PC_PENDING, do the below actions (Just enter the TRANSACTION ID, got from the ORA-1591 error):
Connect as SYS or SYSDBA
DELETE FROM pending_trans$ WHERE local_tran_id = ‘&TRANSACTION_ID’;
DELETE FROM pending_sessions$ WHERE local_tran_id = ‘&TRANSACTION_ID... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 8, 2011, 4:55 am
Saya adalah ibu dari tiga orang anak dan baru saja menyelesaikan kuliah saya. Kelas terakhir yang harus saya ambil adalah Sosiologi. Sang Dosen sangat inspiratif, dengan kualitas yang saya harapkan setiap orang memilikinya.
Tugas terakhir yang diberikan ke para siswanya diberi nama “Smiling... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 3, 2011, 7:42 am
Below steps are required to override email address for all workflow notifications (please don’t try these steps on Production Environment, or else you will end up doing users work):
Login to Responsibility “Workflow Administrator Web Applications“
Choose “Workflow Manager” under “Oracl... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jul 12, 2010, 11:44 pm
Login as sysdba in SQL *plus
EXEC UTL_RECOMP.recomp_parallel(4);
or
Login as sysdba
run the utlrp.sql script from the $ORACLE_HOME/rdbms/admin
Filed under: Oracle Tagged: ebiz, query, troubleshooting Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jul 12, 2010, 12:02 pm
Create a Function and assign Form name “Run Reports”
Request:
Pass parameters PROGRAM_APPL_SHORT_NAME=”” CONCURRENT_PROGRAM_NAME=””
Request Group:
Pass parameters REQUEST_GROUP_CODE=”” REQUEST_GROUP_APPL_SHORT_NAME=””
Request Set :
Pass parameters REQUEST_SET_NAME = “”... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jul 12, 2010, 7:10 am
When you open the “Requisition Summary” form in “Oracle Purchasing” Responsibility, you get the Application Emergency Message “Message Dictionary couldn’t open the ICX application message file. Cannot open file /u1/oracle//apps/apps_st/appl/icx/12.0.0/mesg/US.msb for reading”.
Pleas... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jun 21, 2010, 10:19 pm
Seorang anak mengeluh pada ayahnya mengenai kehidupannya dan menanyakan mengapa hidup ini terasa begitu berat baginya. Ia tidak tahu bagaimana menghadapinya dan hampir menyerah. Ia sudah lelah untuk berjuang. Sepertinya setiap kali satu masalah selesai, timbul masalah baru. Ayahnya, seorang kok... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Jun 15, 2010, 2:34 am
Uang, siapun butuh uang. Orang Dewasa, Remaja bahkan anak – anak kecil sekalipun kenal dengan benda yang namanya uang. Memang uang penting dalam kehidupan, tanpa alat tukar ini kita tidak mukin bisa memenuhi kebutuhan hidup. Uang membuat sebagian orang bisa melakukan banyak hal daripada orang yang... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Apr 18, 2010, 3:31 pm
Make sure Oracle Forms already in version 10.1.2.3.0, see Note 559067.1 to install ODS 10.1.2.3 (Patch 5983622) on Windows Vista.
Steps for solve this issue are:
Download patch 7047034 (Bugs Fixed for DB 10.1.0.5 Patch 26, Windows 32 Bit)
Download OPatch Universal Installer (Release 10.1.0.0.0 for... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Apr 21, 2009, 9:49 pm
Please visit my new domain at http://ediyanto.co.cc
C U there…
Update (as of 08-Nov-2009):
- Can’t Open Form (Crash) Within Form Builder in MS.Windows Vista
- Oracle Top-N Query
- Bersyukurlah…
- Cinta Sejati
- Nice Story
- 5 Tips Agar Tak Mudah Lelah
- Belajar dari Alphabet
- How T... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Apr 19, 2009, 5:40 am
Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
MetaLink has a very detailed and informative article concerning ORA-... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 23, 2009, 1:45 am
Skenario 1
Andaikan kita sedang naik di dalam sebuah kereta ekonomi. Karena tidak mendapatkan tempat duduk, kita berdiri di dalam gerbong tersebut. Suasana cukup ramai meskipun masih ada tempat bagi kita untuk menggoyang-goyangkan kaki. Kita tidak menyadari handphone kita terjatuh. Ada orang y... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 13, 2009, 1:19 am
Hari ini (5/3-09) saya dan temen2 SD/SMP yang seangkatan sama David Hartanto (Ming2) kita sama2 main kerumah keluarga Hartanto, sekedar untuk menyampaikan bela sungkawa, serta mencari kebenaran yang sesungguhnya karena kami tahu kalau David tidak akan melakukan hal-hal yang seperti diberitakan o... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 6, 2009, 11:37 pm
Table of the main UNIX commands
Unix Commands
Description
Options
ls
lists the content of a directory
-a
Displays all files, including hidden files
-I
Displays a detailed listing
-R
Displays the files recursively (i.e. in the sub-directories)
-d
Displays only the directories and not their content
... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 6, 2009, 11:27 pm
One of the most often uses of the pseudo column rownum is to provide sequence numbers to the records in a query. This feature is widely used in reports to represent systematic display of information.
SELECT ROWNUM, rcta.trx_number, rcta.trx_date
FROM ra_customer_trx_all rcta;
ROWNUM TRX... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Mar 5, 2009, 8:26 pm
The below steps for activate special menu on Receipts form and invoice custom form “Receipt DT” when clicked on the special menu on Oracle Application (E-Business Suite)
Open the Receipts Form on Receivables Manager Responsibility
Open the Personalization form using the navigation “Help > Dia... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Feb 28, 2009, 1:38 am
Kehidupan pernikahan kami awalnya baik2 saja menurutku. Meskipun menjelang pernikahan selalu terjadi konflik, tapi setelah menikah Mario tampak baik dan lebih menuruti apa mauku.
Kami tidak pernah bertengkar hebat, kalau marah dia cenderung diam dan pergi kekantornya bekerja sampai subuh, baru pul... Comment - Like
Edi Yanto posted an article on
Edi Yanto (何 萬 新)
-
Feb 28, 2009, 12:55 am
Segala sesuatu memang bisa saja terjadi di Dunia, namun bila sebuah kejadian yang jarang terjadi secara merata di berbagai daerah, maka kejadian yang terjadi tersebut dianggap merupakan sebuah fenomena yang luar biasa. Berikut adalah beberapa fenomena alama yang luar biasa yang terjadi diberbagai da... Comment - Like
Recent Discussions
