How to default Requisition Header/Line DFF value derived from Distribution's Cost Center

Summary:

We have a requirement to default a DFF (Descriptive Flexfield) value on either the Requisition Header or Requisition Line (whichever is feasible). The value to be defaulted is “Bureau”, which needs to be derived from the Cost Center at the Requisition Distribution level.

Content:

The Bureau is defined in a tree structure, where Cost Center is a child node. We have the SQL logic (using FND_TREE_NODE) for deriving the Bureau based on Cost Center.

But the challenge we are facing is:

• At the Requisition Header/Line DFF level, we do not have the required bind variables to access the Distribution-level Cost Center.