sairamgoudmalla.blogspot.com
Oracle Apps: February 2015
http://sairamgoudmalla.blogspot.com/2015_02_01_archive.html
Thursday, February 26, 2015. Oracle Work in Process – Discrete Job Interface (WIP Mass Load) Common Errors. The following are some of the general errors we will be getting while running the WIP Mass Load. 1 Invalid or missing WIP Accounting Class. ANS): Set a default WIP accounting class in the WIP parameters for the organization. 2 Invalid value for Scheduling Method. 3 System cannot add or change operation because requested department id does not exist in bom departments table. ANS): You will be gettin...
sairamgoudmalla.blogspot.com
Oracle Apps: August 2015
http://sairamgoudmalla.blogspot.com/2015_08_01_archive.html
Thursday, August 27, 2015. How to join Projects and Customers tables. SELECT proj.segment1 project#, proj.NAME proj name,. Hcaccount number customer account number#. FROM pa projects all proj, pa project customers pc, hz cust accounts hc. WHERE 1 = 1. AND proj.project id = pc.project id. AND pc.customer id = hc.cust account id. Friday, August 21, 2015. Query to check before Disabling any Accounts in oracle. FROM xla ae headers xah, xla ae lines xal. WHERE 1 = 1. AND xah.gl transfer status code = 'N'.
sairamgoudmalla.blogspot.com
Oracle Apps: January 2015
http://sairamgoudmalla.blogspot.com/2015_01_01_archive.html
Friday, January 30, 2015. Query to check Internal Requisition Number and Internal Sales Order Number. Query to check Internal Requisition Number and Internal Sales Order Number. Select ORIG SYS DOCUMENT REF from OE ORDER HEADERS ALL. Select * from po requisition HEADERs all. 1 OE ORDER LINES ALL.SOURCE DOCUMENT LINE ID =. Po requisition lines all.REQUISITION LINE ID. 2 OE ORDER LINES ALL.ORIG SYS DOCUMENT REF=. Po requisition HEADERs all.SEGMENT1(Requisition Number). Tuesday, January 27, 2015. WHERE wsp&...
sairamgoudmalla.blogspot.com
Oracle Apps: July 2014
http://sairamgoudmalla.blogspot.com/2014_07_01_archive.html
Tuesday, July 15, 2014. SQL Query to print Column Values in Row wise. XXHeader seq,JOB1,value. Q GTF AUTOCLAVE LOAD DATA V. XX JOB 1,. XX JOB 2,. XX JOB 3,. XX JOB 4,. Select regexp substr('SMITH,ALLEN,WARD,JONES','[ ,] ', 1, level) from dual. Connect by regexp substr('SMITH,ALLEN,WARD,JONES', '[ ,] ', 1, level) is not null;. Wednesday, July 9, 2014. Oracle WebCenter Sites Check Patch. Oracle WebCenter Sites - Version 7.6.2 and later. There are a few ways to validate:. Subscribe to: Posts (Atom). UNIX Tu...
sairamgoudmalla.blogspot.com
Oracle Apps: May 2015
http://sairamgoudmalla.blogspot.com/2015_05_01_archive.html
Wednesday, May 27, 2015. Default subinventory is not defined in the destination organization. Default subinventory is not defined in the destination organization. Action: Either the transfer subinventory should be populated or a default subinventory should be setup for the destination organization using the inventory forms. ITS Fails With Error "Default Subinventory is not Defined in the Destination Organization" (Doc ID 1223013.1). 1 Navigate to Inventory Setup Transactions Item Transaction Defaults.
sairamgoudmalla.blogspot.com
Oracle Apps: June 2014
http://sairamgoudmalla.blogspot.com/2014_06_01_archive.html
Friday, June 20, 2014. PSON Number how to Map to Oracle Tables. PSON Number how to Map to Oracle Tables. From Payments perspecitve, PSON (tangibleid) is the only link between AR and IBY. You can confirm the receipt number using the PSON by below query. Select receipt number, approval code. From ar cash receipts all. Where payment server order num = '&PSON';. Select * from RA CUSTOMER TRX ALL where payment trxn extension id in. Select trxn extension id from iby fndcpt tx operations where transactionid in.
sairamgoudmalla.blogspot.com
Oracle Apps: November 2014
http://sairamgoudmalla.blogspot.com/2014_11_01_archive.html
Thursday, November 20, 2014. How does one set up a specific user to only have Create Class and Enroll Learners in a class functionality? How does one set up a specific user to only have Create Class and Enroll Learners in a class functionality? The simplest solution is to use the Learning Instructor Self-Service responsibility. Here are some items to verify and additional notes are referenced at the end of this document. They must be active at the time they are attempting to log in. D) System Profile: "O...
sairamgoudmalla.blogspot.com
Oracle Apps: March 2014
http://sairamgoudmalla.blogspot.com/2014_03_01_archive.html
Friday, March 21, 2014. Profile Options to set to perform Forms personalization. Profile Options to set to perform Forms personalization. 8216;FND: Diagnostics’ set to ‘Yes’. 8216;Hide Diagnostics menu entry’ set to ‘No’. 8216;Utilities:Diagnostics’ set to ‘Yes’. Subscribe to: Posts (Atom). View my complete profile. Oracle Apps Useful Links. Tom's Top Inventory FAQ Notes. Troubleshooting Stuck Pick Release and Shipping Transactions. UNIX Tutorial for Beginners. Technical Blog For Oracle Apps.
sairamgoudmalla.blogspot.com
Oracle Apps: April 2015
http://sairamgoudmalla.blogspot.com/2015_04_01_archive.html
Thursday, April 23, 2015. FRM-41034: Cannot set NAVIGABLE attribute of non-displayed item TOLINES BLK.SALES ORDER NUM. FRM-41034: Cannot set NAVIGABLE attribute of non-displayed item TOLINES BLK.SALES ORDER NUM. FRM-41034: Cannot set NAVIGABLE attribute of non-displayed item TOLINES BLK.SO LINE NUM". For example, you set these fields to Hidden using Folder Hide Field. TOLINES BLK.SALES ORDER NUM". TOLINES BLK.SO LINE NUM". How do you Change the Word "iRecruitment" on Each Page. Thursday, April 9, 2015.
sairamgoudmalla.blogspot.com
Oracle Apps: December 2014
http://sairamgoudmalla.blogspot.com/2014_12_01_archive.html
Sunday, December 14, 2014. Q1 What is a Drop Ship PO? A: Oracle Order Management and Oracle Purchasing integrate to provide Drop Shipments. Drop Shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently don't have the items in inventory, or because it's more cost effective for the supplier to ship the item to the customer directly. Drop Shipment was introduced in R11. Q2 How is a Drop Ship PO created? Inventory Item (INV) Optional. A: You...