For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
I have a requirement to define a value set in PO Distribution level and such value always the same as the PO charge account segment3.
SELECT cc.segment3 DEPT,
FROM po_distributions_all po_dis,
gl_code_combinations cc
WHERE po_dis.CODE_COMBINATION_ID = cc.CODE_COMBINATION_ID
and po_dis.po_distribution_id = ?????? (screen UI)
I think ability to use parameters in value set definitions is currently supported for requisitions alone in the procurement family.
I do not think it is supported yet in purchasing screen.
Please refer below note for requisitions alone
Configuring Descriptive Flexfield Segments With Requisition Parameters (Doc ID 2303017.1)
Regards,
Niamath
If it's always equal to the value of an already captured field, wondering why you need to capture it separately in yet another field.
Hi Amy,
As pointed out above, Purchasing Cloud currently does not support any DFF parameters. Wondering how do you plan to use this value, as there might be other ways to achieve the same.
Ivan
Hi Ivan,
I will put this value in PR instead of PO (no choice). Please share if you have any ideas to achieve the same in Purchasing.
Thanks.
Hi Amy,
My question was what will you be using this value for? (e.g, to drive approvals? print on the PO PDF?) to see if the same end result can be achieved by other means.
Ivan
Hi Ivan,
The purpose of this value is to drive the AP invoice approval. Let me explain more.
Our invoice approval should base on the PO charge account (third segment value which is our Business Unit, not balancing segment). However, I was told (by Oracle consultant) the BPM invoice approval cannot get the value from PO charge account to derive the AP invoice approval.
This is show stopper and sucking here for a while.
Please share your thought.
Hi Amy,
Wondering why the PO charge account is different from the Invoice distribution account? Guess you are using accrue on receipt and the account on the invoice distribution is the accrual account instead of the charge account?
If both the PO and invoice account are the same, refer to the example on page 9 of the document attached to note 2207905.1 which shows how to drive invoice approvals based on the invoice distribution account.
Ivan
Hi Amy,
Note charge account is not available as a parameter for the Requisition DFF, so you won't be able to carry the account value from the requisition DFF to the PO DFF to the Invoice DFF.
I cannot think of a solution right now. I suggest you post the question to the Financials forum, so people more familiar with the invoice approval workflow can help you,
Ivan
I think ability to use parameters in value set definitions is currently supported for requisitions alone in the procurement family.
I do not think it is supported yet in purchasing screen.
Please refer below note for requisitions alone
Configuring Descriptive Flexfield Segments With Requisition Parameters (Doc ID 2303017.1)
Regards,
Niamath