DBA Data[Home] [Help] [Dependency Information]

TABLE: AP.AP_AUD_RULE_SETS

Object Details
Object Name: AP_AUD_RULE_SETS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_AUD_RULE_SETS
Subobject Name:
Status: VALID


AP_AUD_RULE_SETS is an audit-specific table that contains audit rules.
The data in this table controls which expense reports are audited and when an employee is placed on the audit list. The primary key for this table is RULE_SET_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_AUD_RULE_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_SET_ID
AP_AUD_RULE_SETS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_SET_NAME
AP_AUD_RULE_SETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_SET_TYPE
Columns
Name Datatype Length Mandatory Comments
RULE_SET_ID NUMBER (15) Yes Rule set unique identifier.
RULE_SET_NAME VARCHAR2 (60) Yes Rule set name.
RULE_SET_TYPE VARCHAR2 (30) Yes Rule set type. Value RULE is used for rule sets to determine whether an expense report is audited. Value AUDIT_LIST is used for rule sets to determine whether an employee is placed on the audit list.
DESCRIPTION VARCHAR2 (240)
Rule set description.
START_DATE DATE

Start date for the rule set.
END_DATE DATE

End date for the rule set.
PAPERLESS_AUDIT_CC_ONLY_FLAG VARCHAR2 (1)
Determines whether paperless audit is used for expense reports that contain corporate credit card transactions only.
PAPERLESS_AUDIT_VIOLATION_FLAG VARCHAR2 (1)
Determines whether paperless audit is used for expense reports that have policy violations.
PAPERLESS_AUDIT_PDM_ONLY_FLAG VARCHAR2 (1)
Determines whether paperless audit is used for expense reports that claim only per diem and/or mileage expenses.
ASSIGN_AUDITOR_STAGE_CODE VARCHAR2 (30)
Determines at which stage an auditor is assigned to an expense report.
AUDIT_ALL_VIOLATIONS_FLAG VARCHAR2 (1)
Determines whether all expense reports with policy violations are audited.
AUDIT_ALL_FROM_AUDIT_LIST_FLAG VARCHAR2 (1)
Determines whether all expense reports from employees on the audit list are audited.
AUDIT_ALL_OLD_RECEIPTS_FLAG VARCHAR2 (1)
Determines whether all expense reports with receipts older than a specified time limit are audited.
AUDIT_ALL_RECEIPT_DAYS_LIMIT NUMBER

Time limit used to determine whether expense reports with old receipts are audited.
RANDOM_AUDIT_FLAG VARCHAR2 (1)
Determines whether expense reports are randomly audited.
RANDOM_AUDIT_PERCENTAGE NUMBER

Probability that an expense report is randomly audited.
IGNORE_CREDIT_ONLY_FLAG VARCHAR2 (1)
Determines whether the random audit ignores expense reports that contain credit lines only.
IGNORE_RJ_NOT_REQ_ONLY_FLAG VARCHAR2 (1)
Determines whether the random audit ignores expense reports that contain only expense types where receipt and justification are not required.
AUTO_APPROVAL_TAG VARCHAR2 (80)
Indicator printed on the expense report submission confirmation page indicating that the expense report is automatically approved.
REQUIRES_AUDIT_TAG VARCHAR2 (80)
Indicator printed on the expense report submission confirmation page indicating that the expense report requires audit.
PAPERLESS_AUDIT_TAG VARCHAR2 (80)
Indicator printed on the expense report submission confirmation page indicating that paperless audit is used for the expense report.
RECEIPT_DELAY_RULE_FLAG VARCHAR2 (1)
Determines whether employees sending receipts later than a specified time limit are placed on the audit list.
RECEIPT_DELAY_DAYS NUMBER

Time limit used to determine whether employees sending receipts late are placed on the audit list.
MONTHLY_TOTAL_RULE_FLAG VARCHAR2 (1)
Determines whether employees submitting more than a specified cumulative total of expense reports per month are placed on the audit list.
MONTHLY_TOTAL_ALLOWED NUMBER

Number limit used to determine whether employees submitting expense reports with large totals are placed on the audit list.
MONTHLY_VIOLATIONS_RULE_FLAG VARCHAR2 (1)
Determines whether employees submitting expense reports with more than a specified number of policy violations per month are placed on the audit list.
MONTHLY_VIOLATIONS_ALLOWED NUMBER

Limit used to determine whether employees submitting expense reports with policy violations are placed on the audit list.
MONTHLY_REPORTS_RULE_FLAG VARCHAR2 (1)
Determines whether employees submitting more than a specified number of expense reports per month are placed on the audit list.
MONTHLY_REPORTS_ALLOWED NUMBER

Limit used to determine whether employees submitting several expense reports are placed on the audit list.
AUDIT_TERM_DURATION_DAYS NUMBER

Number of days an employee remains on the audit list.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
NOTIFY_RCT_OVERDUE_DAYS NUMBER

Time limit in days that determines when the system sends a receipt package overdue notification
NOTIFY_ACTION_REQUIRED_DAYS NUMBER

Time limit in days after which reminders are sent to an employee who has not taken action on the first notification.
NOTIFY_DOCUMENT_REQUIRED_CODE VARCHAR2 (30)
Determines whether a physical document is required when the employee declares receipts missing.
NOTIFY_RESPONSE_OVERDUE_DAYS NUMBER

Time limit in days after employee response to determine if receipt package is overdue
NOTIFY_RCT_RECEIVED_CODE VARCHAR2 (30)
Determines whether employee is notified when a receipt package is received.
HOLD_CODE VARCHAR2 (30)
Determines the circumstances under which payments are put on hold.
HOLD_RCT_OVERDUE_DAYS NUMBER

Time limit in days after which expense report payments are put on hold because of late receipts
HOLD_RCT_OVERDUE_BP_CC_CODE VARCHAR2 (30)
Determines whether to hold payments on credit card expenses in the Both Pay scenario because of late receipts.
AUDIT_ALL_AMOUNT_CODE VARCHAR2 (30)
Determines whether all expense reports with an amount greater than a specified amount are audited.
AUDIT_ALL_AMOUNT_LIMIT NUMBER

Maximum amount allowed for an expense report without audit.
AUDIT_ALL_AMOUNT_CURRENCY_CODE VARCHAR2 (15)
Currency of the maximum amount allowed for an expense report without audit.
AUDIT_ALL_RECEIPTS_CODE VARCHAR2 (30)
Determines whether all expense reports with at least one expense line that requires receipts are audited.
AUDIT_ALL_JUSTIFICATION_CODE VARCHAR2 (30)
Determines whether all expense reports with at least one expense line that requires justification are audited.
AUDIT_ALL_INACTIVE_CODE VARCHAR2 (30)
Determines whether all expense reports of individuals with an inactive status are audited.
AUDIT_ALL_UNUSED_ADVANCES VARCHAR2 (30)
Specifies whether all expense reports with unapplied advances are required to be audited.
CASH_LIMIT_ENABLED VARCHAR2 (1)
Cash Limit Enabled
CASH_LIMIT NUMBER

Cash Limit
CARD_LIMIT_ENABLED VARCHAR2 (1)
Card Limit Enabled
CARD_LIMIT NUMBER

Card Limit
MILEAGE_LIMIT_ENABLED VARCHAR2 (1)
Mileage Limit Enabled
MILEAGE_LIMIT NUMBER

Mileage Limit
ALLOW_NEGATIVE_LINES VARCHAR2 (1)
Allow Negative Lines
IMAGE_RECEIPT_REQ VARCHAR2 (1)
Image Receipt Required
ORIG_RECEIPT_REQ VARCHAR2 (1)
Orig Receipt Required
IMAGE_PREV_SUB_FLAG VARCHAR2 (240)
Image Previos Sub Flag
IMAGE_REQ_JUST_FLAG VARCHAR2 (240)
Image Required Justification Flag
IMAGE_REQ_APPR_FLAG VARCHAR2 (1)
Image Required Approval Flag
NOTIFY_IMG_RCT_OVERDUE_DAYS NUMBER

Notify Image Receipt Overdue Days
NOTIFY_IMG_ACTION_REQ_DAYS NUMBER

Notify Image Action Required Days
NOTIFY_IMG_RESP_OVERDUE_DAYS NUMBER

Notify Img Response Overdue Days
AUD_IMG_RECEIPT_REQUIRED VARCHAR2 (1)
Audit Image Receipt Required
AUD_PAPER_RECEIPT_REQUIRED VARCHAR2 (1)
Audit Paper Receipt Required
RECPT_ASSIGN_STAGE_CODE VARCHAR2 (240)
Receipt Assign Stage Code
IMAGE_AUDIT_TAG VARCHAR2 (80)
Image Audit Tag
CURRENCY_CODE VARCHAR2 (15)
Currency Code
ALLOW_RECPT_DECL VARCHAR2 (1)
Allow Receipt Declaration
REQ_REAPPR_FLAG VARCHAR2 (1)
Required Reappr Flag
ALLOW_RECPT_MISSING VARCHAR2 (1)
Allow Receipt Missing
PAYABLES_IMAGE_REQ VARCHAR2 (1)
Payables Image Required
AUDIT_ALL VARCHAR2 (1)
Audit All receiptless reports
AUDIT_SPECIFIC VARCHAR2 (1)
Audit specific receiptless reports
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_SET_ID
,      RULE_SET_NAME
,      RULE_SET_TYPE
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      PAPERLESS_AUDIT_CC_ONLY_FLAG
,      PAPERLESS_AUDIT_VIOLATION_FLAG
,      PAPERLESS_AUDIT_PDM_ONLY_FLAG
,      ASSIGN_AUDITOR_STAGE_CODE
,      AUDIT_ALL_VIOLATIONS_FLAG
,      AUDIT_ALL_FROM_AUDIT_LIST_FLAG
,      AUDIT_ALL_OLD_RECEIPTS_FLAG
,      AUDIT_ALL_RECEIPT_DAYS_LIMIT
,      RANDOM_AUDIT_FLAG
,      RANDOM_AUDIT_PERCENTAGE
,      IGNORE_CREDIT_ONLY_FLAG
,      IGNORE_RJ_NOT_REQ_ONLY_FLAG
,      AUTO_APPROVAL_TAG
,      REQUIRES_AUDIT_TAG
,      PAPERLESS_AUDIT_TAG
,      RECEIPT_DELAY_RULE_FLAG
,      RECEIPT_DELAY_DAYS
,      MONTHLY_TOTAL_RULE_FLAG
,      MONTHLY_TOTAL_ALLOWED
,      MONTHLY_VIOLATIONS_RULE_FLAG
,      MONTHLY_VIOLATIONS_ALLOWED
,      MONTHLY_REPORTS_RULE_FLAG
,      MONTHLY_REPORTS_ALLOWED
,      AUDIT_TERM_DURATION_DAYS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NOTIFY_RCT_OVERDUE_DAYS
,      NOTIFY_ACTION_REQUIRED_DAYS
,      NOTIFY_DOCUMENT_REQUIRED_CODE
,      NOTIFY_RESPONSE_OVERDUE_DAYS
,      NOTIFY_RCT_RECEIVED_CODE
,      HOLD_CODE
,      HOLD_RCT_OVERDUE_DAYS
,      HOLD_RCT_OVERDUE_BP_CC_CODE
,      AUDIT_ALL_AMOUNT_CODE
,      AUDIT_ALL_AMOUNT_LIMIT
,      AUDIT_ALL_AMOUNT_CURRENCY_CODE
,      AUDIT_ALL_RECEIPTS_CODE
,      AUDIT_ALL_JUSTIFICATION_CODE
,      AUDIT_ALL_INACTIVE_CODE
,      AUDIT_ALL_UNUSED_ADVANCES
,      CASH_LIMIT_ENABLED
,      CASH_LIMIT
,      CARD_LIMIT_ENABLED
,      CARD_LIMIT
,      MILEAGE_LIMIT_ENABLED
,      MILEAGE_LIMIT
,      ALLOW_NEGATIVE_LINES
,      IMAGE_RECEIPT_REQ
,      ORIG_RECEIPT_REQ
,      IMAGE_PREV_SUB_FLAG
,      IMAGE_REQ_JUST_FLAG
,      IMAGE_REQ_APPR_FLAG
,      NOTIFY_IMG_RCT_OVERDUE_DAYS
,      NOTIFY_IMG_ACTION_REQ_DAYS
,      NOTIFY_IMG_RESP_OVERDUE_DAYS
,      AUD_IMG_RECEIPT_REQUIRED
,      AUD_PAPER_RECEIPT_REQUIRED
,      RECPT_ASSIGN_STAGE_CODE
,      IMAGE_AUDIT_TAG
,      CURRENCY_CODE
,      ALLOW_RECPT_DECL
,      REQ_REAPPR_FLAG
,      ALLOW_RECPT_MISSING
,      PAYABLES_IMAGE_REQ
,      AUDIT_ALL
,      AUDIT_SPECIFIC
FROM AP.AP_AUD_RULE_SETS;

Dependencies

[top of page]

AP.AP_AUD_RULE_SETS does not reference any database object

AP.AP_AUD_RULE_SETS is referenced by following:

SchemaAP
ViewAP_AUD_RULE_SETS#