sanjib

• Feb 27th, 2017

In the same instance of Oracle Apps, multiple organizations are their if we don't use staging table other organization data comes into scenario & it will create ambiguity.

KV

• Jun 1st, 2016

Hi sir,

The flat file generated by us should be based on staging table or interface table? and if there are no interface tables then based on what should we create the flat file?

Thanks and regards
KV

Answer Question  Select Best Answer

arpita bharanibharani

• Feb 27th, 2018

The suppliers are ones, who sell the goods/services to the vendors, and from the vendors, these goods/services are sold directly to the customers.

raji

• Aug 18th, 2011

Suppliers: who sells the goods to the vendor whereas vendor sells the material to the client or end customer.for example x company making a component for their vendors.The same vendor sell to their client with OH's

Answer Question  Select Best Answer

The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs.   

Kuna Sahu

• May 12th, 2016

Cursor is a SQL private memory area which is used to retrieve multiple record and process record by record process.

Vijaya bhaskar

• Jul 27th, 2012

You can fetch the more rows and insert into another table easily

Answer Question  Select Best Answer

hari

• Aug 20th, 2012

To run a application in oracle application

we have 4 type

Ashok Verma

 Profile Answers by Ashok Verma Questions by Ashok Verma

• Dec 15th, 2006

Sorry Dear , I haven't seen yur Hierarchy. Yea it is correct.User->Application->Responsibilty->Site

Answer Question  Select Best Answer

G M RAM

• Sep 21st, 2011

RCV_SHIPMENT_HEADERS

RCV_TRANSACTIONS

RCV_SHIPMENT_LINES

In case of any errors, i.e. if the receipt is not processed you can check in the below tables

RCV_TRANSACTIONS_INTERFACE

RCV_HEADERS_INTERFACE

PO_INTERFACE_ERRORS ( Reason its stuck in Interface)

velichetiraghav

 Profile Answers by velichetiraghav Questions by velichetiraghav

• May 21st, 2009

RCV_SHIPMENT_HEADERSRCV_TRANSACTIONSRCV_SHIPMENT_LINESIn case of any errors, i.e. if the receipt is not processed you can check in the below tablesRCV_TRANSACTIONS_INTERFACERCV_HEADERS_INTERFACEPO_INTERFACE_ERRORS ( Reason its stuck in Interface)Thanks,Raghav

Answer Question  Select Best Answer

LM

• Dec 14th, 2017

Data conversion is a translation process where data from one format is translated to another so that it can be used in SAP system.

Data Migration is the process of loading the data from legacy system into SAP system thru several load programs/jobs.

whitebox

 Profile Answers by whitebox Questions by whitebox

• Aug 26th, 2014

As an integral part of your team, White Box will provide value throughout the life-cycle of your data management project while minimizing risk. Throughout the process, we are committed to providing yo...

Answer Question  Select Best Answer

Ram Panday from Saturn e-solutions pvt.ltd

• Feb 13th, 2013

Credit memo is used to reduce the balance due for a transaction and Debits that we assign to a customer to collect additional charges like freight charges,taxes,or finance charges.

peterson1975

 Profile Answers by peterson1975 Questions by peterson1975

• Dec 12th, 2009

A credit memo is an invioce that reduces the amount due to a  customer's invioce. This usually occurs becuase the customer has returned some of the goods (goods returned ) the adjustments ca...

Answer Question  Select Best Answer

vishalaksha vyas

• Nov 16th, 2007

How data is dumped from?OM tables to OM interface tables we have to run some open interface or it is automatically dumped.

Guest

• Jan 12th, 2007

I would like to add few steps to it.If you want to have India Localization Taxes to be captured in your business transactions.then you need to run : India Local concurrent request ofr processing order lines to AR.

Answer Question  Select Best Answer

chandra2001

 Profile Answers by chandra2001 Questions by chandra2001

• Jan 20th, 2009

Dunning is the process of methodically communicating with customers to ensure the collection of accounts receivable. Communications progress from gentle reminders to almost threatening letters as acco...

sdsmt

 Profile Answers by sdsmt Questions by sdsmt

• Mar 20th, 2008

Dunning Letter: A letter which is sent to customers to inform about the past due debit items is know as 'Dunning Letter'

Answer Question  Select Best Answer

dsk

• May 8th, 2015

Both are same... But any modification are made in form called customization....

Bonthu Nagi Reddy

• Mar 8th, 2012

Customization is making the changes to the Oracle applications using Oracle tools like Forms, Reports etc....

Personalization is just changing the properties with out making any changes.

Answer Question  Select Best Answer

vikas

• Aug 12th, 2015

/u01/app/ilcomdb/apps/apps_st/appl/XXWOMS/12.0.0/bin

venu

• Apr 29th, 2007

Source we can keep in custom folders but we need to link the file to AU/....fnd? folder likeln -s /XXXXX/app/applmgr/product/10.7.0/fnd/6.1.1/bin/fndcpesr

Answer Question  Select Best Answer

Sangram Mahekar

• Jun 2nd, 2014

Picking is the process of removing items from stock and moving them to the shipping dock to be shipped. The shipping dock is usually the default location for the outgoing items that you have defined o...

ajith kumar s

 Profile Answers by ajith kumar s Questions by ajith kumar s

• Nov 9th, 2012

The item moving from staging area to sub inventory is called as PICK RELEASE

Answer Question  Select Best Answer

Adi_phaniK

 Profile Answers by Adi_phaniK Questions by Adi_phaniK

• Sep 20th, 2009

_all tables would be typically for transactions. it stores multi org information.
Eg: oe_order_headers_all ...stores information of sales order headers information of different OU's.

But oe_order_headers stores order header info of a particular OU (to which it has been set)

neela manohar

• Jan 8th, 2007

_all tables will store information about multiple oraganizations. these table contain ORG_ID column that  picks particular organizations from multiple organizations. _all tables will be created when we install multiorg.

Answer Question  Select Best Answer

Adi_phaniK

 Profile Answers by Adi_phaniK Questions by Adi_phaniK

• Sep 20th, 2009

Organization ID refers to a unique id of an inventory organization (mtl_parameters)Org_id refers to a operating unit (hr_operating_units)Below is the hirerarchy for your reference.Set of Books? |OU? |inv org? |sub inventory? |Locator

veersh

• Sep 27th, 2006

Organization_id is one of the column of inventory orgnization column(operating unit table column). But org_id is the profile value for Mo: Operating unit.When you open profilethru application develope...

Answer Question  Select Best Answer

sajasand

 Profile Answers by sajasand Questions by sajasand

• May 6th, 2009

You can access the Global parameter value by :GLOBAL. inside form PL/SQL Coding

Sandeep

• Sep 14th, 2007

Navigate to Help >> Diagnostics >> Properties >> Item  Then you mention Object as Global variable, Object 4 as Global variable name you can get its value

Answer Question  Select Best Answer

velichetiraghav

 Profile Answers by velichetiraghav Questions by velichetiraghav

• May 21st, 2009

OE_ORDER_HEADERS_ALL
nOE_ORDER_LINES_ALL
nWSH_DELIVERY_DETAILS
nWSH_NEW_DELIVERIES
nWSH_DELIVERY_ASSIGNMENTS
nWSH_TRIPS
nWSH_TRIP_STOPS
nWSH_DELIVERY_LEGS
nRA_INTERFACE_LINES_ALL
nRA_CUSTOMER_TRX_LINES_ALL
nRA_CUSTOMER_TRX_ALL

snehaniranjana

• Jul 6th, 2007

AR: Ra_customer_trx_all
Ra_customer_trx_lines_all
Ra_cust_trx_gl_dist_all
AR_payment_schedules_all
RA_cust_trx_types_all

Answer Question  Select Best Answer

menonsandeep1982

 Profile Answers by menonsandeep1982 Questions by menonsandeep1982

• Aug 20th, 2008

When you complete an invoice schedules are created in ar payments schedules all and the transaction distributions are elgible to send to GL

menonsandeep1982

 Profile Answers by menonsandeep1982 Questions by menonsandeep1982

• Aug 20th, 2008

A credit card order is same as any other order for accounting. i.e. DR Rec CR RevBut the receipt process can be different depending on ur clients requirements to categorize remitted receipts and clear...

Answer Question  Select Best Answer

Cadie_H

 Profile Answers by Cadie_H Questions by Cadie_H

• Aug 10th, 2008

An spfile and a pfile are both init parameter files.The pfile is a readable text file which you can edit directly in Notepad (Windows) or vi (Unix). The pfile's name is initSID.ora.The s...

suvashnaidu

 Profile Answers by suvashnaidu Questions by suvashnaidu

• Aug 7th, 2008

Sfile is text file spfile is binary fileIt can be maintained using a standard operating system editorspfile is maintained by the Oracle Server.

Answer Question  Select Best Answer

Is it possible to have a single inventory organization associated to Multiple Operating Units?If Yes, How can we query it from the database?

job4ronny

 Profile Answers by job4ronny Questions by job4ronny

• Nov 28th, 2009

No, we cannot have single Inventory with multiple Operating units.Let us suppose if it happened then it wlll screwup material transactions. Material transaction will not be able to provide correct inf...

san1975

 Profile Answers by san1975 Questions by san1975

• May 29th, 2009

Once the item is assigned to an Organization, we can remove the same. It can be done thru Organization Item.. query for the item and make in "Inactive". Importantly it cannot be done by unchecking the Organization Assignment check box - Santosh Pandey

Answer Question  Select Best Answer

What are the Tools used to transfer data from flat file to staging table in oracle apps other than SQL LOADER?

Himanshu

• Dec 29th, 2012

There are other ways too like we can use sql*loader or an fnd file

naga

• Apr 27th, 2012

UTL and external tables can be used to load data

Answer Question  Select Best Answer