Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PO Requisition account generator Charge Account default from Line DFF attribute2

Afzal BaigSep 16 2021

Hello All,
We are using R12.1.3.
I am customizing the workflow of PO Requisition workflow generator.
Want to default Charge Account from Requisition Line DFF attribute2.
I am success in passing the static value of ccid as below, but want dynamic value as per the user entered in the PO Requisition lines Attribute2.
x_account := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'LINE_ATT2');
--x_account is null;
po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
itemkey=>itemkey,
aname=>'TEMP_ACCOUNT_ID',
avalue=>17114 );--x_account);-- passing static value works fine

can anyone help me how can I set value of dff requisition line attribute2 into LINE_ATT2 attribute in the workflow.
I find like below values are set by oracle, and they get in the code.
x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
itemkey => itemkey,
aname => 'DESTINATION_ORGANIZATION_ID');

Kindly suggest.

Regards,
Afzal.

Comments
Post Details
Added on Sep 16 2021
0 comments
189 views