Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get the active encumbered amount in Oracle Fusion BIP report

Question
1
Views
0
Comments

Summary:

How to get the active encumbered amount in Oracle Fusion BIP report

In EBS we used the below Package to get the active encumbered amount, How to get the same in Oracle Fusion Cloud BIP reports……..?????

apps.po_inq_sv.get_active_enc_amount
(NVL (pdiv.rate, 1),
pdiv.encumbered_amount,
plla.shipment_type,
pdiv.po_distribution_id
),
0
) active_enc_amt

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):