sivakandigatla.blogspot.com
Oracle Knowledge Center: Missing leading Zeros in XML Publisher report or BI Publisher report in EXCEL Output
http://sivakandigatla.blogspot.com/2015/07/missing-leading-zeros-in-xml-publisher.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Thursday, July 23, 2015. Missing leading Zeros in XML Publisher report or BI Publisher report in EXCEL Output. In XML publisher report RTF need to ass this tag not not removing leading zero's. Subscribe to: Post Comments (Atom). Alter Session in PLSQL. Shell Scripts in Oracle apps. There was an error in this gadget.
sivakandigatla.blogspot.com
Oracle Knowledge Center: Connecting to Linux using putty
http://sivakandigatla.blogspot.com/2014/12/connecting-to-linux-using-putty.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Sunday, December 7, 2014. Connecting to Linux using putty. Connecting to Linux using putty. For connecting a linux machine(I have installed Ubuntu on an old laptop to play around), we have to install the OpenSSH Server. Command for doing that. Sudo apt-get install openssh-server. Subscribe to: Post Comments (Atom). Alter Session in PLSQL.
sivakandigatla.blogspot.com
Oracle Knowledge Center: Creating Soft Link or Symbolic Link in Oracle Applications or Oracle Apps
http://sivakandigatla.blogspot.com/2014/11/creating-soft-link-or-symbolic-link-in.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Tuesday, November 18, 2014. Creating Soft Link or Symbolic Link in Oracle Applications or Oracle Apps. Soft Link or Symbolic Link is required to read a shell script (.prog file) through a concurrent program. We can create soft links or symbolic links for Concurrent Manager program files as follows:. Step 1:Go to the custom top as below:. Alter Session in ...
sivakandigatla.blogspot.com
Oracle Knowledge Center: Intransit Receipts using Receiving Open Interface - How to Receive Intransit Shipment (Inter-org transfer) for Lot / Serial Controlled Items via Receiving Open Interface
http://sivakandigatla.blogspot.com/2015/08/intransit-receipts-using-receiving-open.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Wednesday, August 5, 2015. Intransit Receipts using Receiving Open Interface - How to Receive Intransit Shipment (Inter-org transfer) for Lot / Serial Controlled Items via Receiving Open Interface. Formatted on 8/5/2015 2:46:34 PM (QP5 v5.265.14096.37972) */. L transaction id NUMBER;. L GROUP ID NUMBER := rcv interface groups s.NEXTVAL;. LAST UPDATE DATE,.
sivakandigatla.blogspot.com
Oracle Knowledge Center: REF CURSOR Procedure as a OUTPUT variable in Oracle as a result set output for JAVA and VB.NET or C#
http://sivakandigatla.blogspot.com/2014/12/ref-cursor-procedure-as-output-variable.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Tuesday, December 30, 2014. REF CURSOR Procedure as a OUTPUT variable in Oracle as a result set output for JAVA and VB.NET or C#. CREATE OR REPLACE PACKAGE APPS.PRICE BOOK PKG. TYPE R CURSOR IS REF CURSOR;. PROCEDURE GETPRICEBOOKDATA (P PRICEBOOK REQUEST ID IN NUMBER,. Cur pricebookdata OUT R CURSOR);. END PRICE BOOK PKG;. Cur pricebookdata OUT R CURSOR).
sivakandigatla.blogspot.com
Oracle Knowledge Center: PO Receipts and inventory Material Transactions Link Query RCV_SHIPMENT_LINES and mtl_material_transactions
http://sivakandigatla.blogspot.com/2015/08/po-receipts-and-inventory-material.html
Objective of this blog is to share my oracle knowledge with the people who are working in oracle. Alter Session in PLSQL. Shell Scripts in Oracle apps. Thursday, August 6, 2015. PO Receipts and inventory Material Transactions Link Query RCV SHIPMENT LINES and mtl material transactions. Select b.* from apps.RCV SHIPMENT LINES a, apps.mtl material transactions b. Where a.creation date to date('29-JUL-2015', 'DD-MON-YYYY') and a.creation date to date('30-JUL-2015', 'DD-MON-YYYY'). Alter Session in PLSQL.
zett7.blogspot.com
Math.random() ++: Notes
http://zett7.blogspot.com/p/short-notes.html
Programming is an art, a form of expression only the logic side of our brain could appreciate. 1 avoid creating unnecessary objects and always prefer to do Lazy Initialization. Is the technique of delaying a computation until the result is required. 2 avoid making public instance variables. Make it private then create getter/setter methods. 3 always try to minimize the mutability. Managing immutable (unmodifiable) objects have performance impact. Oracle R12 / OAF. Http:/ www.javapractices.com. 4 years ex...
easyoracleapps.blogspot.com
Oracle Apps@Keerthipati: Aging Periods Setup In AP
http://easyoracleapps.blogspot.com/2011/09/aging-periods-setup-in-ap.html
Friday, 9 September 2011. Aging Periods Setup In AP. Setup Calendar Aging Periods. Use the Aging Periods window to define time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during four periods that you specify in the Aging Periods window. Enter each aging period:. Enter the range of days for the period. For example, to define a period that reports invoice payments due during the next 7 days, enter From –7 days To 0 days. Special Calendar Se...
easyoracleapps.blogspot.com
Oracle Apps@Keerthipati: September 2011
http://easyoracleapps.blogspot.com/2011_09_01_archive.html
Wednesday, 21 September 2011. Developing XML Reports without RDF ,SQL Query to develop BI Publisher Reports. The XML Publisher(XMLP / BI Publisher ) requires a Template layout and Data XML to generate the report in PDF, EXCEL, RTF or HTML format .The Data XML can be generated from Oracle Report, OA Framework and Data Template.Using this approach, you can develop BI Publisher reports in Oracle EBS, without having to develop an RDF report. Data Structure : Definition of the Output XML Structure. XML Publis...
easyoracleapps.blogspot.com
Oracle Apps@Keerthipati: Payment Formats Setup In AP
http://easyoracleapps.blogspot.com/2011/09/payment-formats-setup-in-ap_09.html
Friday, 9 September 2011. Payment Formats Setup In AP. A payment format is to be defined for a combination of Payment method i.e. Check, and Currency. This Payment format is attached to the Payable Document name in the Bank Account window. Each payment format must be unique for that payment method i.e. Check, Electronic, Wire or Clearing. Fig 13.1 Payment Formats. Enter a unique name for Payment Format. The naming convention will be XXOAS-Currency E.g. XXOAS-OMR. Select the Payment Method. Choose the sta...