Outstanding Encumbrance Errors Report (POR009)
- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Outstanding Encumbrance Errors Report (POR009)
- Updated on 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
Outstanding Encumbrance Errors Report will extract encumbrance details that are marked as Error or Warning during Budget Check. Can be extracted on demand to get encumbrance details for any selected Business Unit, Purchase Order (PO) Origin, Supplier SetID, Supplier ID, PO ID, PO Status, PO Date Range.
Report Navigation: Main Menu > Enterprise Components > WorkCenter/Dashboards > Configure Pagelets > Reports/Processes tab
Query Name: FLP_POR009_PO_ENC_ERROR
See the sample layout report below.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Business Unit | Required |
Supplier SetID | Optional |
Supplier ID | Optional |
Purchase Order (PO) Origin | Optional |
PO ID | Optional |
PO Status | Optional |
Exclude Confidential | Optional |
PO Date From | Optional |
PO Date To | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD Mapping |
|---|---|
Business Unit | PS_PO_HDR.BUSINESS_UNIT |
Purchase Order (PO) Origin | PS_PO_HDR.ORIGIN |
PO ID | PS_PO_HDR.PO_ID |
PO Reference | PS_PO_HDR.PO_REF |
PO Date | PS_PO_HDR.PO_DT |
PO Total Amount | Fetch sum of all the line amounts of PO. |
Accounting Date | PS_PO_HDR.ACCOUNTING_DT |
Supplier SetID | PS_PO_HDR.VENDOR_SETID |
Supplier ID | PS_PO_HDR.VENDOR_ID |
Supplier Name | PS_VENDOR.VENDOR_NAME |
PO Line Number | PS_PO_LINE_DISTRIB. LINE_NBR |
PO Schedule Number | PS_PO_LINE_DISTRIB. SCHED_NBR |
PO Distribution Line Number | PS_PO_LINE_DISTRIB. DISTRIB_LINE_NUM |
PO Merchandise Line Amount | PS_PO_LINE_DISTRIB. MERCHANDISE_AMT |
Budget Date | PS_KK_EXCPTN_TBL.KK_TRAN_DATE |
Organization | PS_PO_LINE_DISTRIB.DEPTID |
Account | PS_PO_LINE_DISTRIB.ACCOUNT |
| Fund | PS_PO_LINE_DISTRIB.FUND_CODE |
| Budget Entity | PS_PO_LINE_DISTRIB.BUDGET_REF |
Category | PS_PO_LINE_DISTRIB.PRODUCT |
State Program | PS_PO_LINE_DISTRIB. CHARTFIELD2 |
Grant | PO_LINE_DISTRIB.PROGRAM_CODE |
Contract | PO_LINE_DISTRIB.CHARTFIELD1 |
Other Accumulator 1 (OA1) | PO_LINE_DISTRIB.CLASS_FLD |
Other Accumulator 2 (OA2) | PO_LINE_DISTRIB.CHARTFIELD3 |
PC Business Unit | PO_LINE_DISTRIB.BUSINESS_UNIT_PC |
Project | PO_LINE_DISTRIB.PROJECT_ID |
Activity | PO_LINE_DISTRIB.ACTIVITY_ID |
PC Source Type | PO_LINE_DISTRIB.RESOURCE_TYPE |
PC Category | PO_LINE_DISTRIB.RESOURCE_CATEGORY |
PC Subcategory | PO_LINE_DISTRIB.RESOURCE_SUB_CAT |
Asset Profile ID | PO_LINE_DISTRIB.PROFILE_ID |
PO Status | PS_PO_HDR.PO_STATUS |
Budget Header Status | PS_PO_HDR. BUDGET_HDR_STATUS |
Exception Type | Fetch PS_KK_EXCPTN_TBL.EXCPTN_TYPE value based on prefix. Display Error for ‘E’ and Warning for ‘W’ in the report. |
Exception Message | Fetch long translate value from psxlatitem based on exception type in KK_EXCPTN_TBL |
Hold Status | PS_PO_HDR. HOLD_STATUS Display Yes for ‘Y’ and No for ‘N’ in the report. |
Confidential | |
Source System User ID | PS_PO_HDR.TAX_EXEMPT_ID |
Version History
Date | Revision Description |
|---|---|
12/01/2023 | Original Version |
Was this article helpful?
