Sreekanth Reddy Pothula's Oracle ERP Blog

 Note To Buyer entered in the iProcurement requisition checkout step applies for only line 1 in the Autocreate form, the below article explains how can the Note To Buyer column be enabled on the Shopping Cart page to allow requisition preparer to enter Note To Buyer for each requisition line. This functionality of Note To Buyer on the checkout page applies only to line 1 of the requisition.  The Note To Buyer value on the checkout step 2 of 3 in iProcurement is a header level value that is saved to PO_REQUISITION_HEADERS_ALL.NOTE_TO_BUYER. Note To Buyer column shown on   the Autocreate form is a line level value that is from PO_REQUISITION_LINES_ALL.NOTE_TO_AGENT.  Per Bug 14035820, iProcurement saves the Note To Buyer header level value to the First Requisition Line Note To Agent line level value, so that the value is shown to the buyer at auto-create in the Note to Buyer (PO_REQUISITION_LINES_ALL.NOTE_TO_AGENT) column. But it is only shown for the first requ...

http://www.careerusa.org/tip-of-the-week.html Source/Credits : http://www.careerusa.org

SELECT   Decode ( Count ( * ) ,   0 ,   'false' ,                          'true' ) FROM     apps . ap_expense_report_headers_all WHERE    report_header_id   =   :transactionId         AND   employee_id   IN   ( SELECT   ap_web_ame_pkg . Getawardmanagerid ( award_id ,                                    sysdate )                             FROM     apps .   ap_exp_report_dists_all   dist        ...

Budgetary Control: Functional Overview (Doc ID 817974.1) In Release 12 What Are The Budgetary Control Funds Checking STATUS_CODE Values ? (Doc ID 744646.1) Budgetary Control And Funds Check in Projects R12: A Case Study Using a Non-Integrated Budget (Doc ID 1314706.1)   Budgetary Control Results Explanation (Doc ID 1919510.1) R11i/12: PO: FAQs - Encumbrance Accounting - Setup And Usage (Doc ID 1086669.1)

http://mashable.com/2016/01/15/19-apps-new-year-2016/#EbFY9MGgISq2

Oracle Services Procurement – Complex Purchase Orders – Oracle Services Procurement is part of Oracle Advanced Procurement Suite and provides state-of-the-art functionalities to strategically procure services that deals with various procurement aspects such as Prepayment, Retainage etc. In addition to the Temporary Labor Procurement functionality, Oracle Services Procurement helps us to significantly improve the Lumpsum and Milestone type procurement activities through Complex Purchase Orders. Following Points to be noted in relation to Complex Purchase Orders: • Complex Purchase Orders can be created, updated and viewed using Buyer Work Centre only. • The Schedules/Shipments for the standard purchase orders is called as “Pay Items” in the complex purchase orders. • There are 3 types of Pay Items available in the complex purchase orders as – Milestone, Lumpsum and Rate. Availability of the pay items for selection in the buyer work center depends on the line type an...

SELECT   pa . process_item_type ,           pa . process_name ,           pa . process_version ,           pa . activity_item_type ,           pa . activity_name ,           aav . value_type ,           aav . text_value ,           aav . number_value   FROM     apps . wf_process_activities   pa ,           apps . wf_activity_attr_values   aav   WHERE    pa . process_item_type   =   'REQAPPRV'           AND   aav . process_activity_id   =   pa . instance_id           AND   aav . NAME   =   '...