janacallsu

 Profile Answers by janacallsu Questions by janacallsu

• Dec 25th, 2010

LINE_ID from OE_ORDER_LINES_ALL  is stored in INTERFACE_LINE_ATTRIBUTE6 in RA_CUSTOMER_TRX_LINES_ALL

MK

• Dec 29th, 2006

AR and OE are related by the following keys:1. sales_rep_id (oe_order_headers_all <-> ra_salesreps_all)2. invoice_to_org_id, site_use_id (oe_order_headers_all <-> ra_site_users_all)

Answer Question  Select Best Answer

bharathpulluru

 Profile Answers by bharathpulluru Questions by bharathpulluru

• Jun 17th, 2010

Qualifier means that behavioursegment qualifier means that it tells us abt behaviour of a segmentsegment qualifiers arefor company  ---   Balancing segmentDepartment   --- cos...

mirunalinimiru

 Profile Answers by mirunalinimiru Questions by mirunalinimiru

• Apr 24th, 2008

Segment qualifier are used to identify a particular segement within key flexfield

Answer Question  Select Best Answer

Hi,Can anybody tell from which table i can get the details of material receipt for which bill booking is not happened in AP.RegardsJothees Nair

Binuss

 Profile Answers by Binuss Questions by Binuss

• Mar 31st, 2010

In RCV_TRANSACTIONS Table  there is a field Invoice_status_code which shows whether invoice is made or not against the receipt.

Answer Question  Select Best Answer

viren56

 Profile Answers by viren56 Questions by viren56

• Mar 13th, 2010

In MultiOrg Environment, we can have 1+7 set of books (SOB) and hence can have 1+7 Chartsof Accounts or Accounting Flex fields.

Nitin Kanwar

• Feb 9th, 2006

No. You cannot have more than one Accounting Flexfields for a Set of Books in AR. Accounting Flexfield defines a Chart of Accounts. Having 2 different Accounting Flexfield structure implies that they ...

Answer Question  Select Best Answer

parthm

 Profile Answers by parthm Questions by parthm

• Dec 9th, 2009

These are Global Scheduling Rules or Logistics Rules use for Scheduling the Order in Order Management. 

Answer Question  Select Best Answer

parthm

 Profile Answers by parthm Questions by parthm

• Dec 9th, 2009

Full life cycle implementation involves various cross functional team and Project management team working together through different PHASES of Oracle Application life cycle (case: Legacy system roll o...

hyddude

 Profile Answers by hyddude Questions by hyddude

• May 2nd, 2006

Note: Please correct,if there are any mistakesFull Life Cycle means implementing a project from the begining to the production and maintenance stage.(1) System Planning:     &...

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

Oracle_World

 Profile Answers by Oracle_World Questions by Oracle_World

• Nov 24th, 2009

KFFs in Receivables (AR):- Sales Tax Location (code: MKTS)- Territory (code: CT#)You might also want to know the KFFs in ASSETS, which are:- Asset KFF (Code: KEY#)- Category (Code: CAT#)- Location (Code: LOC#)Hope it helps.Cheers!

Sridhar

• Jul 27th, 2006

There are 2 Kff's are there in AR1.Sales Tax Location FF-this is a mandatory one to implement2.Territory- its an optional one.

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

An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization.

san1975

 Profile Answers by san1975 Questions by san1975

• May 29th, 2009

Descriptive FlexFields are the additional fields provided by Oracle Apps to store any Additional Information which cannot be captured elsewhere in the form. There are maximum of 15 Attributes available in 11i whereas 30 Attributes that are available in R12.

Abhilash Awasthi

• Apr 18th, 2006

A flexfield is made up of sub-fields or segments.. A flexfield appers on ur form as a pop-up window that contains a prompt for each segment.Each segment has a name and a set of valid values..Two types...

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

velichetiraghav

 Profile Answers by velichetiraghav Questions by velichetiraghav

• May 21st, 2009

We can cancel the order if it is in booked status, but cannot be cancelled once the order is Shipped...

k.R.Selvaraj

• Jun 4th, 2006

hiorder status has changed to shipped/interfaced/closed these orders only not able to cancelremaining all other order status are possible to cancelregardskrselvaraj

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

ashingeeks

 Profile Answers by ashingeeks Questions by ashingeeks

• Apr 6th, 2009

Order Number -- Order Tab formWarehouse and Ship Locator --INVENTORY Tab form

mk

• Jan 2nd, 2007

Enter the order and book the order...maybe?

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

What is advance pricing and how do you define it in oracle application

bakerkha

 Profile Answers by bakerkha Questions by bakerkha

• Oct 30th, 2008

Oracle Advanced Pricing supports e-business applications by providing a flexible pricing engine that executes pricing and promotional calculations for Oracle Order Management and other Oracle Applicat...

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

Why should we have to give flexfield qualifiers for company and account segments?

menonsandeep1982

 Profile Answers by menonsandeep1982 Questions by menonsandeep1982

• Aug 20th, 2008

Segment qualifiers is the way off letting the system know how to for eg balance a company segment. Unless the system knows which segment is the company segment all reporting may not balance at the company level

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