-
Register Table
How to register table in Oracle Apps?
astaputra
- Jul 7th, 2008
you have to use AD_DD package for registering your tables and columns.Here is the codeAD_DD.register_table(p_appl_short_name => ,p_tab_name => ,p_tab_type => )AD_DD.register_column(p_appl_sho...
-
O2C Cycle Process
What is O2C Cycle? Explain the process.
patitapan
- Jul 4th, 2008
O2C REFFERS TO "Order To Remittance".This means for any sale or distribution done in the Order Management, Oracle Receivables is responsible for the remittance of amount sold.So the total process of r...
-
What is the difference between D2K Reports and Oracle Apps Reports?
raman av
- Jun 12th, 2008
Differences between D2k Report and Apps Report(1) in D2k Report there is no fecility to schedule the program where as in Apps report we have that fecility(2) in D2k Report we can't use User-Exits ...
AMIT SONI
- Aug 15th, 2007
D2K reports and Oracle Reports basically have no difference the main difference between them is only that simple D2k report run in any environment and we always use Tables if we want to run a repo...
-
Display "No Records Found" In Report Output
In a report output, How to display "no records found", if no records have been retrieved?
Rampraas
- Jun 8th, 2008
Dear anishajain,Define a Summary Column in Data Model with source of any driving column. Add a boilerplate text with "NO Records Found".Defin code in Format trigger for the same as followsfu...
-
What are the standard programs for Oracle GL,AP,PO modules open interfaces?
-
Hi to all, iam very new to oracle apps.when did order closes on header level in order management module?
mallikarjunekmn
- May 16th, 2008
Hi,As per my Knowledge as per ERP ProcessSteps:1. Purchase Order will be in Fresh Status when it is created.2. It will be in Approved Status after it is approved by Purchase Dep Head or correspon...
AYAN BASU
- Sep 29th, 2006
Please consider two situtions:1. An order with a single line2. An order with a multiple lineIn a single line order , when the entire quantity is fullfilled i.e shipped and AR interface being run the l...
-
What is a template?What is a token?
kader_bathusha
- May 14th, 2008
Template is predefine , future purpose like expenses template,or quick codes ,Token is unique no every user entering orcle gateway used owen token same thing any problam or issuse share probalm ...
knarender
- Jun 27th, 2007
Template.fmb is a predefined standard form ,which is having 21 libraries to support oracle application structureToken is a field in the parameter window of a concurrent program which is used to map concurrent program parameter with the report builder bindvariable.
-
What is R2R Cycle in Apps?
vsn0208
- May 6th, 2008
R2R stands for Record 2 Report i.e. Record Jounal entries in the General Ledger and Report to the Financial Managers using reporting tools such as hyperion. Below modules come under R2R cycle1) Genera...
-
What is FlexField?
Oracle Application uses Flexfield to capture information about Your organization. Flexfield have flexible structure for storing key information. Like Company, Cost Center, and Account. They also give u highly adaptable Structure for storing customized information in oracle Applications.
shrikantgarud
- Apr 25th, 2008
Simple way to descriptive flexfield are the flexible data fields designed and customised according to business needs. Types1. kff- key flexfeilds 2. dff- descriptive flex fieldsThe basic steps in de...
Dawson
- Apr 20th, 2007
KFF - DFFWrong. Please follow GL Module document. in OTN
-
How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.
vipulgosai
- Apr 25th, 2008
Hi,Use Base table instead of multi-org table. Mean to say...use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.
PREM
- Oct 30th, 2006
IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.
-
What r the changes that we will make to a report when we r installing it as a concurrent program?
azamtulla
- Apr 22nd, 2008
Apart from general emplementation of oracle repots we do the following thing: --> create prameter P_CONC_REQUEST_ID as number--> add following user exits: ...
-
Can any one solve this, let me know the process steps?In HRMS Module i terminated one employee on 4-May-2006 with the Settlement date of 31-May-2006 and the Actual date is 5-May-2006, In this case on which date is going see the 'Person Type as: Ex.Employee' and What date we are going to see in effective date?
rashve
- Apr 14th, 2008
The settlement date is of no importance.The user has added the termination of the employee on 04-may-2006 for the 05-May-2006.This means that the last working of the employee will be 05-May-2006 , so ...
rahul.gatade
- Apr 12th, 2008
Why the employee type ex_employee is upto 31-dec-4712...I mean why upto the year 4712....
-
How do you find the output of a concurrent program is in character mode or in bitmap mode?
subbupdk
- Apr 14th, 2008
Go to concurrent progam define window and see the out put style, if it's text means character mode or it's in PDF means bitmap.
-
What is the various Return codes in the registration of PL/SQL concurrent program?Trouble shooting in Interfaces and various Oracle Application modules?
rahul.gatade
- Apr 13th, 2008
For Registering any PL/SQL stored Procedure as a concurrent program we need to include two mandatory parameters for that procedure,1) ERRBUF OUT VARCHAR22) RETCODE OUT NUMBERThe 1st ...
Vijay Gurme
- Jun 21st, 2006
There are two two types of codes that arereturn while registering the PL/SQL procedureThese are 1) errbuf2)retcode
-
Hi,can anybody explain me the flow of AP & AR in oracle financials upto the GL accounting transactions.
swarna
- May 14th, 2007
Well explaining about the? AP ModuleAP ----------->GLAP Module consists of the following? steps1)creation of the invoices2)creation of the payments3)transfer it to gl by predefined program.AR ------...
-
.... becoz of the fact that out parameters are write only ... we only can assign values to out parameters but we can't assign out parameters value to any variable inside the procedure or function....but in my case I had created a simple procedure and used out parameters in it let give me the example of the code first ....>create or replace procedure test_out_parameter(out_parameter out number) isv_temp number;beginv_temp := out_parameter;out_parameter :=10 ;dbms_output.put_line (out_parameter);end ;here i read the value of out parameter (out_parameter) in the variable v_temp but this procedure was created sucessfully and throws no error..... and also run sucessfully with no error or warnings... i want to know where i m doing the mistake ...thanks
rahul.gatade
- Apr 11th, 2008
Yes..I am totally agree with what XYZ replied.There is such kinda restriction only for IN parameter..that means if you are trying to assign value to IN parameter, then that procedure won't get com...
xyz
- May 7th, 2007
It is limited only for in parameter..You can only read in parameters, we cannot assign any value to in parameter.if you try to do so, it wont even allow you to compile your code.Thanksxyz
-
What is a segment qualifier and how is it set for the segments of a KFF ?
Pradeep_R
- Apr 5th, 2008
Segment qualifiers contain information about a value rather than the segment that uses the value.After you have saved your segment qualifier values, the values for your segment qualifiers appear in th...
Venkata Ramana G
- Aug 23rd, 2007
Segment Qualifier : From this we can identify the account is relating to which type ie whether the particular account is for expenses or for revenue or assets or liabilities or fund balance.While...
-
Flex Fields
What are Flex fields in Oracle Apps Technical? What is different between Flex Fields and User Parameter.What r types of Flex Fields?
harishkrishnagowda
- Apr 3rd, 2008
A flexfield, as the name suggests, is a flexible data field that your organization can customize to your business needs without programming
vineetjoshi5
- Feb 3rd, 2008
Types of Flex-fields :1> Key Flexfields2> Descriptive Flex-fields3> Range Flexfields
-
What is the interface error table for order management
-
What is cost allocation in HRMS?
Oracle Apps Technical Interview Questions
Ans