Internet expense report

dandan

•        goal: How to Setup Oracle Approvals Management (AME) for Internet Exepnses
•       
•        fact: Internet Expenses 11.5
•       
•        fact: Oracle Approvals Management 11.5
•       
•       


fix:


Here is an example of how to setup Internet Expenses to use Oracle Approvals
Management using a Supervisory Level Approval Type in a Vision Operations
database:

Navigate:  AME Application Administrator responsibility -> Approvals

1.  Setting up Transaction Type and Mandatory Attributes
Choose Admin tab
For Activity, choose "Maintain transaction types." and choose the
Continue button
Choose the "Add a Transaction Type" button
For Oracle Application, choose Oracle Payables and choose Continue
On the Enter Transaction-Type Details page, enter the following:

        Transaction-Type Description:  Internet Expenses
        Transaction-Type ID (if any):  APEXP
        Line-Item ID Query:  select distribution_line_number from
                ap_expense_report_lines_all where report_header_id =
                :transactionId order by distribution_line_number

Choose Continue button
On the Mandatory-Attribute Queries page, enter the following:

ALLOW_DELETING_RULE_GENERATED_APPROVERS Usage:  false
        Static Usage:  yes
ALLOW_REQUESTOR_APPROVAL Usage: false
        Static Usage:  yes
AT_LEAST_ONE_RULE_MUST_APPLY Usage:  true
        Static Usage:  yes
EFFECTIVE_RULE_DATE Usage:
        Static Usage:  yes
EVALUATE_PRIORITIES_PER_LINE_ITEM Usage:  false
        Static Usage:  yes
TRANSACTION_DATE Usage:  
select ame_util.versionDateToString(creation_date) from
ap_expense_report_headers_all where report_header_id = :transactionId
        Static Usage:  no
TRANSACTION_GROUP_ID Usage:  
select nvl(fsp.business_group_id, 0) from financials_system_params_all fsp,
ap_expense_report_headers_all exp where fsp.org_id = exp.org_id and exp.
report_header_id = :transactionId
        Static Usage:  no
TRANSACTION_ORG_ID Usage:  
select nvl(ORG_ID, 0) from ap_expense_report_headers_all where report_header_id
= :transactionId
        Static Usage:  no
TRANSACTION_REQUESTOR_PERSON_ID Usage:  
select nvl(employee_id, 0) from ap_expense_report_headers_all where
report_header_id = :transactionId
        Static Usage:  no
TRANSACTION_REQUESTOR_USER_ID Usage:  
select created_by from ap_expense_report_headers_all where report_header_id = :
transactionId
        Static Usage:  no
TRANSACTION_SET_OF_BOOKS_ID Usage:  
select nvl(asp.SET_OF_BOOKS_ID, 0) from ap_expense_report_headers_all exp,
ap_system_parameters_all asp where  exp.org_id = asp.org_id   and exp.
report_header_id = :transactionId
        Static Usage:  no
USE_RESTRICTIVE_LINE_ITEM_EVALUATION Usage:  false
        Static Usage:  yes
WORKFLOW_ITEM_KEY Usage:  
select report_header_id from ap_expense_report_headers_all where
report_header_id = :transactionId
        Static Usage:  no
WORKFLOW_ITEM_TYPE Usage: APEXP
        Static Usage:  yes

Choose Continue button

dandan

HATTY！可否解释一下其费用制度的审批层次关系及其设置步骤！多谢了！