Subscribe to:
Post Comments (Atom)
-
What is Collection? A Collection is an ordered group of elements of particular data types. It can be a collection of simple data type or...
-
Q1) Display those who have joined in 81. Q2) Display those whose name start with A and job ends with K. Q3) Display those whose salary inclu...
-
PROCEDURE otb_setup_mat_sscatg(p_comp_code VARCHAR2,p_main_code varchar2,p_cat_code varchar2) -- u is cursor disp_period_cur is s...
How many flex fields are there in AR and what are they?
ReplyDeleteIn R12 we have 2 key flexifields and those 2 are optionals
1) Sales tax location key flexield: this flexfiled is used to calculate tax based on the location wise
2) Territory key flexfiled: By using this key flexfield we can find out the the sales information based on the location wise
Answered by: Shoukath Ali on: Aug 30th, 2007
There are 2 kff in AR
1. Sales tax location flexfield
2.Territory flexfield.
What is auto invoicing? Explain?
ReplyDeleteAuto invoice is a facility provided by Oracle Receivables, that the transactions in Legacy system can be taken in to Receivables through interface.. To setup auto invoice you need to ensure the syste...
How to close periods in ar?
ReplyDelete1.first check the Transactions for the period being closed. 2.Reconcile transaction activity for the period. 3.Reconcile customer outstanding balances 4.Review unapplied receipts register 5.Run Receip...
What is the use of lockboxes?
4 answers
To import receits from a bank file using lockboxes.
Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. ARLPLB (auto lockbox program) imports, Validates and loads the payment receipt recor...
What are the interface and API table for receipts conversion in Oracle receivables .
ra_interface_lines_all is the interface table for AR Transactions.
AR_PAYMENTS_INTERFACE_ALL
AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
AR_CASH_RECEIPTS_ALLAR_CASH_RECEIPT_HISTORY_ALLAR_DISTRIBUTIONS_ALLAR_RECEIVABLE_APPLICATIONS_ALLAR_PAYMENT_SCHEDULES_ALL
AR and cash management
Asked By: arameshofc | Asked On: Dec 28th, 2007
1 answer
What are the things you should match at the time of reconciliation between AR and cash management? And AP and cm?
Answered by: jaswantjaiswal on: Apr 30th, 2009
For AR and CM : Receipt Number is Required and
For AP and CM : Payment Document Number is required
---------------------------------------------AOL-----------------------------------------------------------
1.How can we delete a concurrent program which is already registered?
We can delete the Concurrent Program from Back End.
begin
FND_PROGRAM.delete_executable(executable_short_name=>xxexe,application=>XXMZ Custom);
commit;
end;
begin
FND_PROGRAM.DELETE_PROGRAM(program_short_name=>XXCONC,application=>XXMZ Custom);
commit;
end;
2.How do I submit a sherie of requests from PL/SQL?
we can submit 2 or more programs from backend by using below FND
FND_CONCURRENT.WAIT_FOR_REQUEST
Answered by: suneel on: Sep 20th, 2011
if we need to submit 2 or more programs serieally
we need to submit from back end by using below FND
FND_CONCURRENT.WAIT_FOR_REQUEST
How will you use flexfield in report?
Asked By: syedrafi123 | Asked On: Jan 19th, 20121 answerWhat is it's need?
Answered by: gokul on: Jan 20th, 2012
Flexfields is a collection of Segments. Flexfields are two types.
1. Key flexfields(KFF),
2. Descriptive flexfields(DFF).
Key Flexfields :- Mandatory Information, it is stored in Segments.
Descriptive Flexfields :- Additional Information, it is stored in Attributes.
Dependent Parameters in Oracle Applications
ReplyDeleteRequirement:
Say there is a concurrent program that lets you retrieve employee details based on employee name or employee number.
The concurrent program has 3 parameters:
1.Search Criteria is a value set containing “Employee Name” and “Employee Number” as values
2.Employee Name
3.Employee Number
When the user wants to search employee based on Employee number, he selects Employee Number in the parameter “Search Criteria”.
Automatically Employee name parameter should be disabled so that user can enter only number in the parameter Employee number to search that employee.
Similarly if the users wants to to search employee based on Employee name, Employee number parameter should be disabled thus preventing the users to search based on Employee number.
clip_image002