How to create a Descriptive Flexfield in PO_DISTRIBUTIONS with default value SQL Based

Summary

Create a DFF with default value SQL

Content

I'd like to create a DFF in PO_DISTRIBUTIONS for automatically display Funds Available amount (XCC_BALANCES). With this information, be’ll posible compare distribution amount versus funds available.

When the Budget Amount is less Purchasing Distribution amount, I’d like to create a specific rule in Purchase Approval (BPM) requesting a different approval. This is because, when the purchase amount is equal or less Requisition amount, the system don’t check the Budget. The Funds status in this case is equal a Approved.

Is this possible?

Version

19D