REPORTS Questions in Oracle Apps:
OPEN-DEBIT MEMO REPORT?
This report shows all the open-debit memo transactions, based on customer number and dates.
Columns: - type, customer_no, trx_no, amt_due, remaining.
Parameter: - type, customer, from_date, to_date.
GENERATING POSITIVE PAY FILE FOR BANK REPORT?
Basically this report generates a flat file of all the payments in order to send in to the bank.
UPDATE POSITIVEPAY CHECKS REPORT?
This report which updates the data into the (AP) account payables system from the plot file, the file which is sent by bank
UPDATE POSITIVEPAY OUT STANDING CHECKS?
This report which shows the out standing checks
CUSTOMER PAYMENT DETAILS REPORT?
Which shows each customer original amount, amount pay and due amount based on transaction type (books, pens)
FLEX FIELDS?
Oracle applications provide flex fields to allow each organization the ability to define its own reporting structure.
DFF
|
KFF
|
Additional
|
Unique Info, Mandatory
|
Captured in attribute prefixed columns
|
Segment prefixed
|
Not reported on standard reports
|
Is reported on standard reports
|
To provide expansion space on your form With the help of []. [] Represents
descriptive Flex field.
FLEX FILED : DESCRIPTIVE : REGIGSTER
---FND_ID_FLEXS---
|
Used for entering and displaying key information
For example Oracle General uses a key Flex field called Accounting Flex field to
uniquely identifies a general account.
FLEX FILED : KEY : REGIGSTER
---FND_DESCRIPTIVE_FLEXS_VL---
|
COPY TO: - choose this button to create another concurrent programs using the same executables request and report information’s
$FLEX$: - (Bind variable) $FLEX$.VALUE_SET_NAME
1. Is used to get the previous parameter value
2. is used to give the profile value at runtime
3. basically we will use these two ways in the “where clause” and the default value of parameter window
No comments:
Post a Comment