Tuesday, February 11, 2020

Budgetary Control Options in Oracle General Ledger(Lookups: FUNDS_CHECK_LEVEL,PTD_YTD and BOUNDARY_TYPE)

In Budgetory Control Options form we Funds Check Level, Amount Type, Boundary and Funding Budget.

We have Advisory, Absolute and None types of Funds Check Level.

Use Funds Check level when setting budgetary control options for account ranges, for source and category combinations in budgetary control groups, and for summary account templates.
  • Advisory: Use Advisory as Fund Check Level option for online notification when transactions fail funds checking. The system still reserves funds for transactions even when no funds are available.
  • Absolute: Use Absolute as Fund Check Level option to prohibit you from reserving funds for a transaction unless funds are available.
  • None: Use None as Fund Check Level option for no funds checking or funds reservation.

Funds Check Level is coming from Lookup Type "FUNDS_CHECK_LEVEL". Below is the query we can use.

Amount Type is coming from Lookup Type "PTD_YTD". Below is the query we can use.



Boundary is coming from Lookup Type "BOUNDARY_TYPE". Below is the query we can use.




2 comments:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)