Total Pageviews

Tuesday, December 18, 2012


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