-
Demand to Stock Cycle
What is Demand to stock cycle?
-
Where can we find the Provision
try thisselect a.vendor_name, b.vendor_site_code,u.organization_id, u.name,h.* from Po_headers_all h , po_vendors a, po_vendor_sites_all b,hr_organization_units uwhere h.segment1 = 228and a.vendor_id = h.vendor_idand a.vendor_id = b.vendor_idand h.vendor_site_id = b.vendor_site_idand h.org_id = u.organization_id
-
-
-
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
-
Y3 Error Status
What is the meaning of error status 'y3' in ra_customer_interface_all ?
-
What is in-bound interface and out bound interface
rajeshnrk8
- Mar 25th, 2009
Inbound interface: We load the data which we got from the legacy systems.Outbound interface : We extract the data for legacy systems.
anil kumar
- May 29th, 2007
Inbound Interface: The Data that is being brought in to oracle application from markets?Eg: Purchase Requisitions (From Market-->Oracle)Out Bound Interface: The data that is being sent to markets fro...
-
Profiles Options
What are the different types of profiles options while submitting report through SRS window.
rajeshnrk8
- Mar 25th, 2009
Profiles are nothing but the changable options.While developing the reports we use two user exists i.esrw.user_exist('fnd srwinit'); in before report trigger andsrw.user_exist('fnd srwexit'); in after report trigger.
-
What is an OPEN PURCHASE ORDER, What is the difference between POSTING JOURNALS and UNPOSTING JOURNALS, What is the need for posting journals in GL module?
rajeshnrk8
- Mar 25th, 2009
Posting journals will have the status as 'P'. We need to post the journals in order to reflect the journals amount in the financial statements.
rakesh.apps
- Aug 8th, 2007
Purchase Order whose status is OPEN is called?OPEN?Purchase?OrderThat means the PO is raised say some item x 50kgs,?but?the?supplier?send?the?x?item?say?25?in?one?shipment i.e?still?supplier?has?to?send the another 25kgs to fulfill?the?PO,?then?that?PO?is?said?to?be?OPEN?Purchase?Order.
-
What is the difference between base table and normal table?what is the difference between character mode and bitmap mode in reports?
rajeshnrk8
- Mar 25th, 2009
Base tables will store the data which is permanent. We should not delete that data. If you see in the purchase order. Base tables are po_headers_all, po_lines_all, po_distributions_all etc. Bit...
-
What are the main points in the report while at the time to register in the oracle Application Environment ?
rajeshnrk8
- Mar 25th, 2009
P_conc_request_id (user parameter)srw.user_exit('fnd srwinit'); ( in before report trigger)srw.user_exit('fnd srwexit'); (in after report trigger.)
-
-
Direct Path and Conventional Path
What is the difference between direct path and conventional path?
arifmahmud
- Apr 20th, 2009
When you use SQL loader by default it use conventional path to load data. This method competes equally with all other oracle processes for buffer resources. This can slow the load. A direct path l...
-
Why is my Purchase Order closing before a receipt is processed?
Because of the Receipt Close percentage defined in the Default tabbed region of Purchasing Options.
sajasand
- May 5th, 2009
If the invoice approval matching is set to the 2-way matching then the PO will close as soon as it approved
-
Journal Import
What is Journal Import.How do I import vendor info into purchasing.Thank u,
nakul.v
- May 6th, 2009
GL Journal Import is a Standard Open Interface Program provided by Oracle Applications to import Journal Data from legacy systems/or even from Payables,Receivables,Inventory into GL Tables.Interface Table :GL_INTERFACEBase Tables : GL_JE_BATCHESGL_JE_HEADERSGL_JE_LINESGL_BALANCES.
rajeshnrk8
- Mar 10th, 2009
Journal Import is the program is used to import the data from the Interface table to main table.
-
Tell me the difference between Conversions and Interfaces.Give example?
selvakumarapps
- May 20th, 2009
Conversions: It's nothing but transfer of data from other application ?to oracle application(it's one time data transfer). eg SAP(data) to Oracle APPS(data).Interfaces: It's nothing but transfer of d...
Christopher Joseph
- Aug 26th, 2006
Upgrading your data to a newer version is not Conversion, Its Data Migration.Conversion is as correctly mentioned, a One time activity to Convert the Data from a Legacy System to be loaded into Apps Tables. Interfaces: They are periodically run for exchange of data between Apps and Non-Apps Systems.
-
Receivables Transfer to GL
How to Run the Receivables Transfer to GL
-
How to handle ' , ' in the data of csv file
hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader
siddhshah
- Jun 22nd, 2009
One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.
harishkrishnagowda
- Apr 4th, 2008
Its better to remove ',' for that column using replace commandsFor egREPLACE(TRANSLATE(empname, ',{}[]%"?*~&$|/@''', ' '),' ')
-
How to create a new responsibility in the system to provide Inquiry only access?
Will there be any pre-defined responsibility in the system that can be used?
nileshtabhane
- Jun 23rd, 2009
For the responsibility you need to set the profile option HR:Query only mode as yes
-
Difference between Oracle 11i and R12
Hi, Can anyone of you give me some points on what are the major differences between Oracle 11i and R12 on the below modules 1. iProcurement 2. Purchasing 3. iStores Waiting for your reply. Thanks, Vikram
bhaskarapps
- Jul 2nd, 2009
1. In Oracle 11i 3c's i.e Currency, Calendar, Char of AccountIn R12 4c's
include sub-ledger account also2. In invoice screen invoice linesApps_Dragon
- Nov 28th, 2008
1) Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyers Work Center. Based on the latest web-based user interface models, the Work Center is a ce...
Oracle Apps Technical Interview Questions
Ans