Purchasing

Get Involved. Join the Conversation.

Posts

  • Sridhar Tumati
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was...15.0
    Topic posted November 19, 2018 by Sridhar TumatiBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Tip, White Paper 
    Title:
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Summary:
    Procurement Custom Reports: ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Content:

     Hi All,

    After Upgrading to Release 13 18C, All the custom Reports developed using Procurement Purchasing Real time subject area having item Description. field results error as below:

    State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO was not correctly resolved in view def InventoryItemRefPVO. Locate the resolution error and address the issue. (HY000)

    We raised  SR and Oracle Support Provided the solution as per below docment:

    FA OTBI - After 18C Patch Errors on OTBI SCM, Produrement Subject areas erroring out ItemEFFBIFlattenedVO; FulfillLineDetailBIEffEFFBIFlattened (Doc ID 2470931.1) 

    Bug 28895661 : FA OTBI ANALYSIS FAILING AFTER 18C UPDATE - ACCESSOR ITEMEFFBIFLATTENEDVO WAS NOT CORRECTLY RESOLVED

    EGO_ITEM_EFF:
    To deploy Item extensible flexfields, do the following:

    1. In the Setup and Maintenance work area, open the task panel and click Search.
    2. Search for and select the Manage Extensible Flexfields task.
    3. On the Manage Extensible Flexfields page, search for the Item Extended Attributes flexfield (flexfield code EGO_ITEM_EFF).
    4. Select the Item Extended Attributes row. From the Actions menu, select ‘Refresh & Deploy Offline’

    This action starts the Item extensible flexfield deployment process.
    5. Monitor the Offline Status column, which shows the status of the deployment process.
    DOO EFF
    Doc 26739757 - BI EFF DOCUMENTATION[This section is not visible to customers.]
    Steps:
    1. Please run the ESS program: Publish Extensible Flexfield Attributes.
    2. In the Manage Extensible Flexfield UI, force deploy the doo header, fulfill line, fulfill line details EFF regardless of whether the customer uses these EFFs or not by invoke Actions->Refresh & Deploy Offline
    3. After deployment, in the same EFF UI, invoke Actions->Download Flexfield
    Archive to download the artifacts, and make sure the directory structure is like: oracle.apps.publicFlex.scm.doo.fulfillLineCategories.analytics
    4. Bounce SCM’s UI and Service Server (Open SR for the bounce)

    Regards,

    Sridhar Tumati

     

    Version:
    Release 13 18C
  • Achala Munasinghe
    Amend PO Communication E-mailAnswered5
    Topic posted December 13, 2017 by Achala MunasingheGold Medal: 3,500+ Points, tagged FAQ, How-To, Notifications, Orders, Setup, Supplier Communication, Tip, White Paper 
    Title:
    Amend PO Communication E-mail
    Content:

    Hi All,

    I have requirement to change the email body used for Purchase Order Communication. Because the standard message does not contain other than following;

    "Review the purchasing document and any files that are attached to the message"

    Here I want to add the signature used in company email.

    Appreciate your expertise support

     

    Regards

    Achala

     

     

    Image:
  • Nishanth B Jain
    Approval Rule Migration64.0
    Topic posted October 3, 2018 by Nishanth B JainBronze Crown: 15,000+ Points, tagged Approvals, FAQ, Setup, Tip, White Paper 
    Title:
    Approval Rule Migration
    Content:

    Hello People,

    Is there a way to migrate approval rules from one instance to other.?

    Some notes talk about SOA Composer, not sure how it works for SaaS.

    Thanks,

    NJ

  • Anil Nair
    Approved Supplier List (ASL)25.0
    Topic posted December 13, 2018 by Anil NairBronze Medal: 1,250+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, Create Requisition, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, White Paper 
    Title:
    Approved Supplier List (ASL)
    Summary:
    Approved Supplier List (ASL)
    Content:

    Hi,

    We have a requirement to restrict any purchasing (Req/Orders) for specific suppliers (Blacklisted).

    The approved supplier list functionality doesn't allow any restriction on Order creation when category and supplier from ASL is used.

    There are no Inventory items for now only categories.

    Also, i'm unable to find the source document - Blanket Purchase Agreements, there is only Contract Purchase Agreement in the drop down list under ASL source documents.The Generate Approved supplier list also doesn't show any agreement numbers.

    Please share if you have come across customers with similar requirement.

    Many thanks.

    Anil 

  • Ekansh Jain
    Auto-population of need-by/promise date on PR/PO based on...15.0
    Topic posted June 6, 2019 by Ekansh JainBronze Medal: 1,250+ Points, tagged Agreements, Create Requisition, Fusion, How-To, Manage Procurement Catalog, Notifications, Orders, Requisition Processing, Setup, Supply & Distribution Planning Cloud, White Paper 
    Title:
    Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location
    Summary:
    Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location
    Content:

    Hi,

    Please let me know if there is any workaround or custom solution to achieve the below requirements in Oracle Purchasing Cloud.

    Scenario: Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location

    Use Cases

    1. Manual Purchase requisition: Requestor selects the ship-to location and Catalogue item, the system automatically populates the need-by date as <SysDate+Lead Time>. This data flows to the PO as Promise Date
    2. Min-Max Planning based Purchase Requisitions: Min-Max planning is run at Org/Sub Inventory level which automatically populates the need-by date as <SysDate+Lead Time>. This data flows to the PO as Promise Date

    As-Is Business Process: Client maintains BPA for each catalogue item with the supplier but doesn’t use ship-to location on the BPA. Lead time is separately managed in custom form for each Item-Ship-to combination. When the user enters PR or min-max planning triggers a PR, customization calculated the need-by date as <SysDate+Lead Time> (as maintained in the mentioned custom form), and populates on PR. This need-by date flows to the PO as the promised date. Buyer can override this date if there are concerns with the promise date from the supplier side.

     

    Why is it critical:

    1. To make sure the right expectations are set up with the requestor about the availability of purchases
    2. To make sure inventory specialists sees correct Supply/Demand picture as promise date is used as supply cut-off date. This helps in avoiding the inventory stock-out situations
    3. To enforce the SLA agreements with vendors, and vendor’s performance can be measured
    4. Extra work to override the populated promise date which will be sysdate if this solution is not in place. Separate communication needs to happen to change this as per SLA agreement which is extra work

    Requirements:

    1. Show end user what is the lead time for that ship-to location for the item?
    2. Auto-populate <SysDate + Lead time> as the promise date on PR/PO. This should be applicable to both manual as well as planning (Min-max) based PR
    3. Supply and Demand report should be able to use the Lead time while calculating the demand/supply based on the cut-off date
    4. Ability to see/review updates on PO promise data by supplier
  • Sathya Srikanth
    Disable personal mailboxes and Use Oracle Fusion...1
    Topic posted July 23, 2019 by Sathya Srikanth, tagged How-To, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, White Paper 
    Title:
    Disable personal mailboxes and Use Oracle Fusion Functionalities
    Summary:
    Disable all personal mailboxes and use only the functionalities of Oracle platform
    Content:

    Hello Team

    We intend to disable all personal mailboxes of our team and have use only the functionalities of Oracle platform from where we can send emails to suppliers and internal Vendor Management Team. 

    This would give opportunity for us to know the status of each of the Contracts / Purchase Requisitions / Purchase Orders inside Oracle Fusion itself. At the same time, we intend to have better control on the Supplier Negotiations.

    Regards

    Sathya

  • Manjula Evans
    Document Approvals Whitepaper for Release 1114.5
    Topic posted September 17, 2016 by Manjula EvansBlue Ribbon: 750+ Points, tagged Agreements, Approvals, Orders, Setup, White Paper 
    Title:
    Document Approvals Whitepaper for Release 11
    Summary:
    Whitepaper about Procurement AMX Approval setups and definitions
    Content:

    This whitepaper will answer many of the questions regarding setup prior to defining document approvals rules, an overview of the how the rules work including some business scenarios, and the setups that are seeded 'out of the box'.

    The whitepaper includes setups and attribute definitions for;

    • requisition approvals,
    • purchase orders and agreements approvals,
    • supplier registration approvals,
    • supplier spend authorization approvals,
    • supplier negotiation (sourcing) approvals.

    Finally, there is also a section on upgrade process considerations from releases prior to Release 11 of Procurement Cloud.

    Link to Whitepaper

  • Ramesh Radhakrishnan
    Docusign Integration with Procurement contracts and...2
    Topic posted July 11, 2017 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Agreements, White Paper 
    Title:
    Docusign Integration with Procurement contracts and Agreements-R12
    Summary:
    Docusign Integration with Procurement contracts and Agreements-R12
    Content:

    Hi,

    We are implementing R12 Procurement contracts and would like to know if there is a document for following

    - Enabling Docusign for Procurement contracts

    - Enabling Docusign for purchasing documents like PO/ BPA/CPA etc.

    Thanks

    Ramesh        

     

     

     

     

  • Raju Ch
    Fusion P2P – Oracle Fusion Procure to Pay (P2P) L...5.0
    Topic posted July 22, 2019 by Raju ChGreen Ribbon: 100+ Points, tagged Approvals, Approvals/Notification, BI Publisher Reports, Create Requisition, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, OTBI, Payables, Requisition Processing, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, White Paper 
    Title:
    Fusion P2P – Oracle Fusion Procure to Pay (P2P) Life Cycle with Functional and Technical flow
    Content:
    The P2P cycle comprises of the following steps,
    01. Create Requisitions
    02. Approve Requisitions
    03. Create Purchase Orders
    04. Approve Purchase Orders
    05. Receive Goods
    06. Create Payables invoice with Match PO Lines
    07. Approve Invoice
    08. Invoice Payment to Supplier with Electronic Method
    09. Approve Payments
    10. Verify the Transaction Life Cycle
    11. Transfer Payables data to General Ledger
    12. Transfer Payments data to General Ledger
    13. Verify the Journal Batches
    14. Verify the Notifications in Mail
     

    Please click on the below link for more details:

    Fusion P2P – Oracle Fusion Procure to Pay (P2P) Life Cycle with Functional and Technical flow
    https://oracleapps88.blogspot.com/2019/07/fusion-p2p-oracle-fusion-procure-to-pay.html

     

    Thanks,
    Raju Chinthapatla
    http://OracleApps88.Blogspot.com/
    OracleApps88@Yahoo.com
    (+91) 905 957 4321

    Version:
    R12
    Image:
  • Vineet Gangwar
    Hide/Make DFF mandatory based on PO document type25.0
    Topic posted April 23, 2019 by Vineet GangwarBlue Ribbon: 750+ Points, tagged Agreements, Fusion, How-To, Setup, White Paper 
    Title:
    Hide/Make DFF mandatory based on PO document type
    Summary:
    Requirement is to make DFF mandatory at PO header for type lookup code as "Contract Purchase Agreement" only
    Content:

    The requirement was to make a DFF mandatory (PO Headers) for Contract Purchase Agreement only. We have achieved this requirement through personalisation by using following EL expression -

    #{bindings.TypeLookupCode=='CONTRACT'?true:false}

    Note - same expression can be used to hide the segment

    Is there any other method to achieve the said requirement as personalisation may get removed post upgrade?