Archive for January 26th, 2012
Populate Order Import Interface Tables From Existing Sales Order
Posted by: Edi Yanto on: January 26, 2012
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_ALL OE_ORDER_LINES_ALL OE_PRICE_ADJUSTMENTS OE_PAYMENTS OE_SALES_CREDITS OE_LOT_SERIAL_NUMBERS
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- BLOB Images in XML Publisher
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- Receiving and Return Transaction with Receiving Open Interface (ROI)
- Transact Move Order and Ship Confirm Using API
- Spell Number (Function Terbilang)
- Making Custom Reports Oracle Apps Compliant
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01591: lock held by in-doubt distributed transaction
- Edi Yanto: Hi Mandi, Have you tried the steps on my blog? Please send me your RTF, XML and RDF files to my gmail (edi.y4nto@gmail.com), I'll take a look when I'
- Mandi: Hi Edi, I am trying to incorporate signature and logo for check printing template in R12. I have converted the blob to clob using getbase64 function
- Edi Yanto: Hi Siva, Images on excel output are not scale itself, so you must change the image size according to what you want. More info about excel limitation
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Online Apps DBA
- Weekend Online Oracle R12 Apps DBA Training commencing from 03rd June 2012
- Weekend Online Oracle Weblogic Administrator 11g Training commencing from 02 June 2012
- Confused about Oracle IAM software version & release number ?
- ASM block corruption ORA-01115
- Oracle Adaptive Access Manager (OAAM) for beginners
Visitors
Users Online
Recent Comments