AP System Parameters Report

Control Reports

The Payables system parameters per business unit — default payment terms, tolerance template, date basis, and discount allocation — used to confirm invoice-processing controls are set consistently.

Sample build of the AP System Parameters Report — reconciled, and rendered tool-neutral so it runs in Power BI, ThoughtSpot, or Tableau.

Sample build · illustrative

Filters

Sample

Business units

Tolerance templates

Control gaps

Business Unit	Default Terms	Tolerance Template	Terms Date Basis	Discount Method
US Operations	Sample	Standard	2026-04-30	Standard
EMEA	—	Corporate	2026-03-31	Corporate
APAC	Sample	Standard	2026-02-28	Standard
LATAM	—	Default	2026-01-31	Default
US Operations	Sample	Standard	2025-12-31	Standard
US Operations	Sample	Standard	2026-04-30	Standard

AI Analyst · active

reading

The report reads AP_SYSTEM_PARAMETERS_ALL with the assigned terms in AP_TERMS_TL and the tolerance templates in AP_TOLERANCE_TEMPLATES per business unit.

flag

Three business units have no tolerance template assigned — invoices in those units skip quantity and price tolerance checks entirely, which is a control gap.

root cause & next step

Assign the corporate tolerance template to those three units so matching holds fire consistently; until then their invoices match without tolerance enforcement.

Illustrative data. The live interactive version — drill-through, filters, export, and the AI Analyst — runs on your warehouse. See it live →

This is the report's BI Publisher data model — the SQL data set BI Publisher runs against Oracle tables to produce the output. The same SQL becomes a dbt model in your warehouse, so one definition drives both the formatted report and the analytics layer.

Data sources

LOOKUP_CODE
FND_LOOKUP_VALUES_TL
AP_SYSTEM_PARAMETERS_ALL
FUN_ALL_BUSINESS_UNITS_V
AP_TERMS_TL
AP_TOLERANCE_TEMPLATES
GL_CODE_COMBINATIONS
TERM_DATE
PAY_DATE
ACC_DATE
BUDGET_DATE
DISC_ALLOC_METHOD

How it interconnects: this data set reads the physical tables above. Those same tables surface in OTBI as subject areas and in BICC as PVOs — three lenses on one source. Open any table to trace its subject areas and View Objects.

SQL data set · genericized · parameterized · no hardcoded segments

Show / hide SQL

SELECT
BU_NAME,
REQUIRE_INVOICE_GROUP_FLAG,
PAY_DOC_CATEGORY_OVERRIDE,
ALLOW_PAID_INVOICE_ADJUST,
ALLOW_INV_THIRD_PARTY_OVRD,
RECALC_PAY_SCHEDULE_FLAG,
CREATE_AWT_INVOICES_TYPE, /*check*/
DISALLOW_ATTACHMENT_DEL_FLAG,
RELEASE_DUP_INVOICE_HOLD_FLAG,
PAYMENT_CURRENCY_CODE,
VENDOR_PAY_GROUP_LOOKUP_CODE,
PAYMENT_PRIORITY,
inv_terms,
TERMS_DATE_BASIS,
PAY_DATE_BASIS,
GL_DATE_BASIS,
BUDGET_DATE_BASIS,
ACCOUNTING_METHOD_OPTION,
RECEIPT_ACCEPTANCE_DAYS,
INVOICE_CURRENCY_CODE,
ALLOW_FINAL_MATCH_FLAG,
ALLOW_FLEX_OVERRIDE_FLAG,
TRANSFER_DESC_FLEX_FLAG,
QUANTITY_TOLERANCE,
TOTAL_AMT_TOLERANCE,
DISC_IS_INV_LESS_TAX_FLAG,
EXCLUDE_FREIGHT_FROM_DISCOUNT,
ALWAYS_TAKE_DISC_FLAG,
dis_alloc_method,
prepay_terms,
ADD_DAYS_SETTLEMENT_DATE,
ACCOUNT_DEFAULT_BASIS_CODE,
PREPAYMENT_AVAILABLE_MESG_FLAG,
APPROVAL_WORKFLOW_FLAG,
ALLOW_FORCE_APPROVAL_FLAG,
VALIDATE_BEFORE_APPROVAL_FLAG,
SECONDARY_ACCOUNTING_METHOD,
AUTO_CALCULATE_INTEREST_FLAG,
INTEREST_TOLERANCE_AMOUNT,
int_alloc_method,
CONCATENATED_SEGMENTS,
pay_req_terms,
pay_req_pay_grp,
pay_req_pri,
SS_LIMIT_TO_SINGLE_PO_FLAG,
SS_INVOICE_BACKDATING_FLAG,
SS_QTYMATCH_OVERBILL_FLAG,
SS_AMTMATCH_OVERBILL_FLAG,
SS_UPRICE_CHANGE_FOR_QTYMATCH,
ATTACHMENT_MANDATORY_SS_FLAG,
POST_DATED_PAYMENTS_FLAG,
ALLOW_SUPPLIER_BANK_OVERRIDE,
PAY_DOC52,
ALLOW_PYMT_THIRD_PARTY_OVRD,
WHEN_TO_ACCOUNT_PMT,
MAKE_RATE_MANDATORY_FLAG,
DEFAULT_CONV_RATE_DATE_BASIS,
BANK_CHARGE_DEDUCTION_TYPE,
ESCHEATMENT_ELIGIBILITY_PERIOD
FROM

(
WITH TERM_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'TERMS DATE BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,PAY_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'POZ_PAY_DATE_BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 0) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,ACC_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'ACCOUNTING DATE BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,BUDGET_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'BUDGET_DATE_BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,DISC_ALLOC_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'DISCOUNT_DIST_OPTIONS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,INTEREST_ALLOC_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'INTEREST_ALLOCATION_OPTIONS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,ACCOUNT_DERIVATION_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'ORA_ACCOUNT_DERIVATION_METHOD' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
SELECT
FABUV.BU_NAME,
ASPA.REQUIRE_INVOICE_GROUP_FLAG,
ASPA.PAY_DOC_CATEGORY_OVERRIDE,
ASPA.ALLOW_PAID_INVOICE_ADJUST,
ASPA.ALLOW_INV_THIRD_PARTY_OVRD,
ASPA.RECALC_PAY_SCHEDULE_FLAG,
ASPA.CREATE_AWT_INVOICES_TYPE, /*check*/
ASPA.DISALLOW_ATTACHMENT_DEL_FLAG,
ASPA.RELEASE_DUP_INVOICE_HOLD_FLAG,
ASPA.PAYMENT_CURRENCY_CODE,
ASPA.VENDOR_PAY_GROUP_LOOKUP_CODE,
ASPA.PAYMENT_PRIORITY,
ATT.NAME inv_terms,
TD.MEANING TERMS_DATE_BASIS,
(CASE WHEN UPPER(PD.MEANING)='DUE' 
     THEN 'Due Date'
     WHEN UPPER(PD.MEANING)='DISCOUNT'
     THEN 'Discount Date'
     END)  AS PAY_DATE_BASIS,
AD.MEANING GL_DATE_BASIS,
BD.MEANING BUDGET_DATE_BASIS,
--ASPA.TERMS_DATE_BASIS,
--ASPA.PAY_DATE_BASIS_LOOKUP_CODE,
--ASPA.GL_DATE_FROM_RECEIPT_FLAG,
--ASPA.BUDGET_DATE_BASIS,
ADM.MEANING ACCOUNTING_METHOD_OPTION,
--ASPA.ACCOUNTING_METHOD_OPTION,
ASPA.RECEIPT_ACCEPTANCE_DAYS,
ASPA.INVOICE_CURRENCY_CODE,
ASPA.ALLOW_FINAL_MATCH_FLAG,
ASPA.ALLOW_FLEX_OVERRIDE_FLAG,
ASPA.TRANSFER_DESC_FLEX_FLAG,
ATT1.QUANTITY_TOLERANCE,
ATT1.TOTAL_AMT_TOLERANCE,
ASPA.DISC_IS_INV_LESS_TAX_FLAG,
ASPA.EXCLUDE_FREIGHT_FROM_DISCOUNT,
ASPA.ALWAYS_TAKE_DISC_FLAG,
DAM.MEANING dis_alloc_method,
ATT1.NAME prepay_terms,
aspa.ADD_DAYS_SETTLEMENT_DATE,
ASPA.BUILD_PREPAYMENT_ACCOUNTS_FLAG ACCOUNT_DEFAULT_BASIS_CODE,
--ASPA.ACCOUNT_DEFAULT_BASIS_CODE,
ASPA.PREPAYMENT_AVAILABLE_MESG_FLAG,
ASPA.APPROVAL_WORKFLOW_FLAG,
ASPA.ALLOW_FORCE_APPROVAL_FLAG,
ASPA.VALIDATE_BEFORE_APPROVAL_FLAG,
CASE WHEN ASPA.APPROVAL_TIMING='N' THEN 'Account regardless of approval status' 
     WHEN ASPA.APPROVAL_TIMING='Y' THEN 'Require accounting before approval'
	 WHEN ASPA.APPROVAL_TIMING='A' THEN 'Require approval before accounting'
	 END AS SECONDARY_ACCOUNTING_METHOD,
--ASPA.SECONDARY_ACCOUNTING_METHOD,
ASPA.AUTO_CALCULATE_INTEREST_FLAG,
ASPA.INTEREST_TOLERANCE_AMOUNT,
IAM.MEANING int_alloc_method,
GCC.CONCATENATED_SEGMENTS,
ATT2.NAME pay_req_terms,
ASPA.EMPLOYEE_PAY_GROUP_LOOKUP_CODE pay_req_pay_grp,
ASPA.EMPLOYEE_PAYMENT_PRIORITY pay_req_pri,
ASPA.SS_LIMIT_TO_SINGLE_PO_FLAG,
ASPA.SS_INVOICE_BACKDATING_FLAG,
ASPA.SS_QTYMATCH_OVERBILL_FLAG,
ASPA.SS_AMTMATCH_OVERBILL_FLAG,
ASPA.SS_UPRICE_CHANGE_FOR_QTYMATCH,
ASPA.ATTACHMENT_MANDATORY_SS_FLAG,
ASPA.POST_DATED_PAYMENTS_FLAG,
ASPA.ALLOW_SUPPLIER_BANK_OVERRIDE,
ASPA.PAY_DOC_CATEGORY_OVERRIDE PAY_DOC52,
ASPA.ALLOW_PYMT_THIRD_PARTY_OVRD,
CASE WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='PAYMENT ONLY' THEN 'At payment issue'
     WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='CLEARING ONLY' THEN 'At payment clearing'
	 WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='BOTH' THEN 'At payment issue and clearing'
END AS WHEN_TO_ACCOUNT_PMT	 ,
PAY_TBL.MAKE_RATE_MANDATORY_PMT_FLAG MAKE_RATE_MANDATORY_FLAG,
PAY_TBL.DEFAULT_PMT_EXCHANGE_RATE_TYPE DEFAULT_CONV_RATE_DATE_BASIS,
CASE WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='S' THEN 'Standard'
     WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='N' THEN 'Negotiated'
	 WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='x' THEN 'None'
	 WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE IS NULL THEN 'None'
END AS BANK_CHARGE_DEDUCTION_TYPE, 
ASPA.ESCHEATMENT_ELIGIBILITY_PERIOD

FROM
AP_SYSTEM_PARAMETERS_ALL ASPA,
FUN_ALL_BUSINESS_UNITS_V FABUV,
AP_TERMS_TL ATT,
ap_tolerance_templates ATT1,
GL_CODE_COMBINATIONS GCC,
AP_TERMS_TL ATT1,
AP_TERMS_TL ATT2,
TERM_DATE TD,
PAY_DATE PD,
ACC_DATE AD,
BUDGET_DATE BD,
DISC_ALLOC_METHOD DAM,
INTEREST_ALLOC_METHOD IAM,
ACCOUNT_DERIVATION_METHOD ADM,
(
SELECT
FSPA.ORG_ID,
FSPA.MAKE_RATE_MANDATORY_PMT_FLAG,
FSPA.DEFAULT_PMT_EXCHANGE_RATE_TYPE

FROM
FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
FUN_ALL_BUSINESS_UNITS_V FABUV
WHERE 1=1
AND FSPA.ORG_ID=FABUV.BU_ID
--AP_SYSTEM_PARAMETERS_ALL ASPA1
) PAY_TBL
WHERE 1=1
AND ASPA.ORG_ID=PAY_TBL.ORG_ID(+)
AND ASPA.ORG_ID=FABUV.BU_ID
--AND ASPA1.ORG_ID=FABUV.BU_ID
AND ASPA.TERMS_ID=ATT.TERM_ID(+)
AND ASPA.PREPAYMENT_TERMS_ID=ATT1.TERM_ID(+)
AND ASPA.EMPLOYEE_TERMS_ID=ATT2.TERM_ID(+)
AND ATT.LANGUAGE(+)='US'
AND ATT1.LANGUAGE(+)='US'
AND ATT2.LANGUAGE(+)='US'
AND ASPA.tolerance_ID=ATT1.tolerance_ID(+)
AND ASPA.INTEREST_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID(+)
AND ASPA.TERMS_DATE_BASIS=TD.LOOKUP_CODE(+)
AND ASPA.PAY_DATE_BASIS_LOOKUP_CODE=PD.LOOKUP_CODE(+)
AND ASPA.GL_DATE_FROM_RECEIPT_FLAG=AD.LOOKUP_CODE(+)
AND ASPA.BUDGET_DATE_BASIS=BD.LOOKUP_CODE(+)
AND ASPA.DISCOUNT_DISTRIBUTION_METHOD=DAM.LOOKUP_CODE(+)
AND ASPA.PRORATE_INT_INV_ACROSS_DISTS=IAM.LOOKUP_CODE(+)
AND ASPA.ACCOUNT_DEFAULT_BASIS_CODE=ADM.LOOKUP_CODE(+)
AND (FABUV.BU_NAME IN (:P_BU)
OR  'ALL' IN(:P_BU||'ALL'))
--AND FABUV.BU_NAME='POWERED UK'

UNION

SELECT
distinct
'' BU_NAME,
'' REQUIRE_INVOICE_GROUP_FLAG,
'' PAY_DOC_CATEGORY_OVERRIDE,
'' ALLOW_PAID_INVOICE_ADJUST,
'' ALLOW_INV_THIRD_PARTY_OVRD,
'' RECALC_PAY_SCHEDULE_FLAG,
'No Data' as CREATE_AWT_INVOICES_TYPE,
'' DISALLOW_ATTACHMENT_DEL_FLAG,
'' RELEASE_DUP_INVOICE_HOLD_FLAG,
'' PAYMENT_CURRENCY_CODE,
'' VENDOR_PAY_GROUP_LOOKUP_CODE,
TO_NUMBER('') PAYMENT_PRIORITY,
'' inv_terms,
'' TERMS_DATE_BASIS,
'' PAY_DATE_BASIS,
'' GL_DATE_BASIS,
'' BUDGET_DATE_BASIS,
'' ACCOUNTING_METHOD_OPTION,
TO_NUMBER('') RECEIPT_ACCEPTANCE_DAYS,
'' INVOICE_CURRENCY_CODE,
'' ALLOW_FINAL_MATCH_FLAG,
'' ALLOW_FLEX_OVERRIDE_FLAG,
'' TRANSFER_DESC_FLEX_FLAG,
TO_NUMBER('') QUANTITY_TOLERANCE,
TO_NUMBER('') TOTAL_AMT_TOLERANCE,
'' DISC_IS_INV_LESS_TAX_FLAG,
'' EXCLUDE_FREIGHT_FROM_DISCOUNT,
'' ALWAYS_TAKE_DISC_FLAG,
'' dis_alloc_method,
'' prepay_terms,
TO_NUMBER('') ADD_DAYS_SETTLEMENT_DATE,
'' ACCOUNT_DEFAULT_BASIS_CODE,
'' PREPAYMENT_AVAILABLE_MESG_FLAG,
'' APPROVAL_WORKFLOW_FLAG,
'' ALLOW_FORCE_APPROVAL_FLAG,
'' VALIDATE_BEFORE_APPROVAL_FLAG,
'' SECONDARY_ACCOUNTING_METHOD,
'' AUTO_CALCULATE_INTEREST_FLAG,
TO_NUMBER('') INTEREST_TOLERANCE_AMOUNT,
'' int_alloc_method,
'' CONCATENATED_SEGMENTS,
'' pay_req_terms,
'' pay_req_pay_grp,
TO_NUMBER('') pay_req_pri,
'' SS_LIMIT_TO_SINGLE_PO_FLAG,
'' SS_INVOICE_BACKDATING_FLAG,
'' SS_QTYMATCH_OVERBILL_FLAG,
'' SS_AMTMATCH_OVERBILL_FLAG,
'' SS_UPRICE_CHANGE_FOR_QTYMATCH,
'' ATTACHMENT_MANDATORY_SS_FLAG,
'' POST_DATED_PAYMENTS_FLAG,
'' ALLOW_SUPPLIER_BANK_OVERRIDE,
'' PAY_DOC52,
'' ALLOW_PYMT_THIRD_PARTY_OVRD,
'' WHEN_TO_ACCOUNT_PMT,
'' MAKE_RATE_MANDATORY_FLAG,
'' DEFAULT_CONV_RATE_DATE_BASIS,
'' BANK_CHARGE_DEDUCTION_TYPE,
TO_NUMBER('') ESCHEATMENT_ELIGIBILITY_PERIOD

FROM
AP_SYSTEM_PARAMETERS_ALL
WHERE NOT EXISTS(
WITH TERM_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'TERMS DATE BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,PAY_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'POZ_PAY_DATE_BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 0) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,ACC_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'ACCOUNTING DATE BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,BUDGET_DATE AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'BUDGET_DATE_BASIS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,DISC_ALLOC_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'DISCOUNT_DIST_OPTIONS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,INTEREST_ALLOC_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'INTEREST_ALLOCATION_OPTIONS' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
,ACCOUNT_DERIVATION_METHOD AS
(
SELECT MEANING ,
LOOKUP_CODE
FROM FND_LOOKUP_VALUES_TL  
WHERE ( ( (LOOKUP_TYPE = 'ORA_ACCOUNT_DERIVATION_METHOD' ) )  
AND ( (VIEW_APPLICATION_ID = 200) )  
AND ( (SET_ID = 0 ) )  
AND ( (LANGUAGE = 'US' ) ) )
)
SELECT
FABUV.BU_NAME,
ASPA.REQUIRE_INVOICE_GROUP_FLAG,
ASPA.PAY_DOC_CATEGORY_OVERRIDE,
ASPA.ALLOW_PAID_INVOICE_ADJUST,
ASPA.ALLOW_INV_THIRD_PARTY_OVRD,
ASPA.RECALC_PAY_SCHEDULE_FLAG,
ASPA.CREATE_AWT_INVOICES_TYPE, /*check*/
ASPA.DISALLOW_ATTACHMENT_DEL_FLAG,
ASPA.RELEASE_DUP_INVOICE_HOLD_FLAG,
ASPA.PAYMENT_CURRENCY_CODE,
ASPA.VENDOR_PAY_GROUP_LOOKUP_CODE,
ASPA.PAYMENT_PRIORITY,
ATT.NAME inv_terms,
TD.MEANING TERMS_DATE_BASIS,
(CASE WHEN UPPER(PD.MEANING)='DUE' 
     THEN 'Due Date'
     WHEN UPPER(PD.MEANING)='DISCOUNT'
     THEN 'Discount Date'
     END)  AS PAY_DATE_BASIS,
AD.MEANING GL_DATE_BASIS,
BD.MEANING BUDGET_DATE_BASIS,
--ASPA.TERMS_DATE_BASIS,
--ASPA.PAY_DATE_BASIS_LOOKUP_CODE,
--ASPA.GL_DATE_FROM_RECEIPT_FLAG,
--ASPA.BUDGET_DATE_BASIS,
ADM.MEANING ACCOUNTING_METHOD_OPTION,
--ASPA.ACCOUNTING_METHOD_OPTION,
ASPA.RECEIPT_ACCEPTANCE_DAYS,
ASPA.INVOICE_CURRENCY_CODE,
ASPA.ALLOW_FINAL_MATCH_FLAG,
ASPA.ALLOW_FLEX_OVERRIDE_FLAG,
ASPA.TRANSFER_DESC_FLEX_FLAG,
ATT1.QUANTITY_TOLERANCE,
ATT1.TOTAL_AMT_TOLERANCE,
ASPA.DISC_IS_INV_LESS_TAX_FLAG,
ASPA.EXCLUDE_FREIGHT_FROM_DISCOUNT,
ASPA.ALWAYS_TAKE_DISC_FLAG,
DAM.MEANING dis_alloc_method,
ATT1.NAME prepay_terms,
aspa.ADD_DAYS_SETTLEMENT_DATE,
ASPA.BUILD_PREPAYMENT_ACCOUNTS_FLAG ACCOUNT_DEFAULT_BASIS_CODE,
--ASPA.ACCOUNT_DEFAULT_BASIS_CODE,
ASPA.PREPAYMENT_AVAILABLE_MESG_FLAG,
ASPA.APPROVAL_WORKFLOW_FLAG,
ASPA.ALLOW_FORCE_APPROVAL_FLAG,
ASPA.VALIDATE_BEFORE_APPROVAL_FLAG,
CASE WHEN ASPA.APPROVAL_TIMING='N' THEN 'Account regardless of approval status' 
     WHEN ASPA.APPROVAL_TIMING='Y' THEN 'Require accounting before approval'
	 WHEN ASPA.APPROVAL_TIMING='A' THEN 'Require approval before accounting'
	 END AS SECONDARY_ACCOUNTING_METHOD,
--ASPA.SECONDARY_ACCOUNTING_METHOD,
ASPA.AUTO_CALCULATE_INTEREST_FLAG,
ASPA.INTEREST_TOLERANCE_AMOUNT,
IAM.MEANING int_alloc_method,
GCC.CONCATENATED_SEGMENTS,
ATT2.NAME pay_req_terms,
ASPA.EMPLOYEE_PAY_GROUP_LOOKUP_CODE pay_req_pay_grp,
ASPA.EMPLOYEE_PAYMENT_PRIORITY pay_req_pri,
ASPA.SS_LIMIT_TO_SINGLE_PO_FLAG,
ASPA.SS_INVOICE_BACKDATING_FLAG,
ASPA.SS_QTYMATCH_OVERBILL_FLAG,
ASPA.SS_AMTMATCH_OVERBILL_FLAG,
ASPA.SS_UPRICE_CHANGE_FOR_QTYMATCH,
ASPA.ATTACHMENT_MANDATORY_SS_FLAG,
ASPA.POST_DATED_PAYMENTS_FLAG,
ASPA.ALLOW_SUPPLIER_BANK_OVERRIDE,
ASPA.PAY_DOC_CATEGORY_OVERRIDE PAY_DOC52,
ASPA.ALLOW_PYMT_THIRD_PARTY_OVRD,
CASE WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='PAYMENT ONLY' THEN 'At payment issue'
     WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='CLEARING ONLY' THEN 'At payment clearing'
	 WHEN UPPER(ASPA.WHEN_TO_ACCOUNT_PMT)='BOTH' THEN 'At payment issue and clearing'
END AS WHEN_TO_ACCOUNT_PMT	 ,
PAY_TBL.MAKE_RATE_MANDATORY_PMT_FLAG MAKE_RATE_MANDATORY_FLAG,
PAY_TBL.DEFAULT_PMT_EXCHANGE_RATE_TYPE DEFAULT_CONV_RATE_DATE_BASIS,
CASE WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='S' THEN 'Standard'
     WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='N' THEN 'Negotiated'
	 WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE ='x' THEN 'None'
	 WHEN ASPA.BANK_CHARGE_DEDUCTION_TYPE IS NULL THEN 'None'
END AS BANK_CHARGE_DEDUCTION_TYPE, 
ASPA.ESCHEATMENT_ELIGIBILITY_PERIOD

FROM
AP_SYSTEM_PARAMETERS_ALL ASPA,
FUN_ALL_BUSINESS_UNITS_V FABUV,
AP_TERMS_TL ATT,
ap_tolerance_templates ATT1,
GL_CODE_COMBINATIONS GCC,
AP_TERMS_TL ATT1,
AP_TERMS_TL ATT2,
TERM_DATE TD,
PAY_DATE PD,
ACC_DATE AD,
BUDGET_DATE BD,
DISC_ALLOC_METHOD DAM,
INTEREST_ALLOC_METHOD IAM,
ACCOUNT_DERIVATION_METHOD ADM,
(
SELECT
FSPA.ORG_ID,
FSPA.MAKE_RATE_MANDATORY_PMT_FLAG,
FSPA.DEFAULT_PMT_EXCHANGE_RATE_TYPE

FROM
FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
FUN_ALL_BUSINESS_UNITS_V FABUV
WHERE 1=1
AND FSPA.ORG_ID=FABUV.BU_ID
--AP_SYSTEM_PARAMETERS_ALL ASPA1
) PAY_TBL
WHERE 1=1
AND ASPA.ORG_ID=PAY_TBL.ORG_ID(+)
AND ASPA.ORG_ID=FABUV.BU_ID
--AND ASPA1.ORG_ID=FABUV.BU_ID
AND ASPA.TERMS_ID=ATT.TERM_ID(+)
AND ASPA.PREPAYMENT_TERMS_ID=ATT1.TERM_ID(+)
AND ASPA.EMPLOYEE_TERMS_ID=ATT2.TERM_ID(+)
AND ATT.LANGUAGE(+)='US'
AND ATT1.LANGUAGE(+)='US'
AND ATT2.LANGUAGE(+)='US'
AND ASPA.tolerance_ID=ATT1.tolerance_ID(+)
AND ASPA.INTEREST_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID(+)
AND ASPA.TERMS_DATE_BASIS=TD.LOOKUP_CODE(+)
AND ASPA.PAY_DATE_BASIS_LOOKUP_CODE=PD.LOOKUP_CODE(+)
AND ASPA.GL_DATE_FROM_RECEIPT_FLAG=AD.LOOKUP_CODE(+)
AND ASPA.BUDGET_DATE_BASIS=BD.LOOKUP_CODE(+)
AND ASPA.DISCOUNT_DISTRIBUTION_METHOD=DAM.LOOKUP_CODE(+)
AND ASPA.PRORATE_INT_INV_ACROSS_DISTS=IAM.LOOKUP_CODE(+)
AND ASPA.ACCOUNT_DEFAULT_BASIS_CODE=ADM.LOOKUP_CODE(+)
AND (FABUV.BU_NAME IN (:P_BU)
OR  'ALL' IN(:P_BU||'ALL'))
)
)
ORDER BY
BU_NAME

:P_BU

The data-warehouse model — one fact surrounded by conformed dimensions (what you slice by) and measures (what you aggregate), expressed as dbt so it migrates with you. Grain: one row per source transaction.

●— fact → dimension join

Element	Type	Definition
FND_LOOKUP_VALUES_TL	dimension	dimension
AP_SYSTEM_PARAMETERS_ALL	dimension	dimension
FUN_ALL_BUSINESS_UNITS_V	dimension	dimension
AP_TERMS_TL	dimension	dimension
Amount	measure	measure

Runs on your cloud warehouse — Snowflake, BigQuery, Redshift, or Synapse on AWS, Google Cloud, Azure, or any provider. Reconciled to the source control total — 0% variance by design. You own the code, the model, and the data.

How the data gets here: a BICC bulk extract of the source tables above, on the same pattern for every report. See the extraction pattern & data flow →

See the complete model

How this report's fact and dimensions fit the full picture, via conformed keys.

Control Reports data model →Enterprise model →

Every source object behind this report. Each linked table has its own page with full column descriptions, drawn from the Oracle BICC lineage and articulated for practitioners.

Table	Reporting columns	Subject areas
LOOKUP_CODE	Setup / configuration table — joined for reference, not exposed for analytics
FND_LOOKUP_VALUES_TL	13	218
AP_SYSTEM_PARAMETERS_ALL	Setup / configuration table — joined for reference, not exposed for analytics
FUN_ALL_BUSINESS_UNITS_V	18	132
AP_TERMS_TL	2	20
AP_TOLERANCE_TEMPLATES	10	10
GL_CODE_COMBINATIONS	7	61
TERM_DATE	Setup / configuration table — joined for reference, not exposed for analytics
PAY_DATE	Setup / configuration table — joined for reference, not exposed for analytics
ACC_DATE	Setup / configuration table — joined for reference, not exposed for analytics
BUDGET_DATE	Setup / configuration table — joined for reference, not exposed for analytics
DISC_ALLOC_METHOD	Setup / configuration table — joined for reference, not exposed for analytics

Reporting columns = fields the report selects that are exposed as analytics attributes; subject areas = the OTBI subject areas the table appears in. Setup and configuration tables (master data, ledger and book setup, lookups) are referenced by the report's joins but aren't exposed as analytics columns or subject areas — that's expected, not a gap.