Purchasing

Get Involved. Join the Conversation.

Posts

  • Jon Kelly
    19D Update Account and Budget Date on Budgetary-Controlled...25.0
    Topic posted November 7, 2019 by Jon KellySilver Trophy: 7,500+ Points, tagged FAQ, Financials, Setup 
    Title:
    19D Update Account and Budget Date on Budgetary-Controlled Open Purchase Orders
    Content:

    We are testing out the changes for the 19D upgrade and trying to confirm what specifically this change is supposed to make. We've been able to make changes to the line or distributions prior to this, so we're not exactly sure what we're looking at. The functional users and I have tested and don't find any visible difference or option. I'm including the description and link below. Thanks!

    Jon

    Upgrade notes:

    Change account and budget date on open purchase orders, even if subject to budgetary control. You can make the changes if there are no project references on the purchase order distributions. The necessary funds checks and adjustments to funds reservations and encumbrance accounting when applicable are handled based on the updated information. This is done by automatically liquidating funds reserved against the old account and budget date, and reserving funds to the new account and budget date.

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/proc/releases/19D/19D-procurement-wn.htm#F5657

     

  • 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)35.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 

  • Max Basandrai
    Budgets1
    Topic posted March 4, 2019 by Max BasandraiBlue Ribbon: 750+ Points, tagged Create Requisition, FAQ, Fusion, How-To, Orders, Requisition Processing, Setup, Tip 
    Title:
    Budgets
    Summary:
    Set Up Budgets in Requisitions
    Content:

    Is there a way to set up Budgets to show in Purchase Requisitions in R13

    Version:
    R13 19A
  • Sabarish Ganda
    Cannot view Purchase Order Approval Details after the PO is...135.0
    Topic posted August 12, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Approvals, Approvals/Notification, FAQ 
    Title:
    Cannot view Purchase Order Approval Details after the PO is in Open Status
    Summary:
    After all the Approvals are done for a PO and if we want to all the history of all the details in the approval Notification, screen is going blank. Please check the attached document for more details.
    Version:
    Oracle Fusion 13, 19B
    Document:
  • Jacob Seidelman
    Cloud ERP EDI leading practices for Procurement25.0
    Topic posted February 3, 2019 by Jacob SeidelmanGreen Ribbon: 100+ Points, tagged FAQ, Fusion, Supplier Communication 
    Title:
    Cloud ERP EDI leading practices for Procurement
    Summary:
    Topic is from a Cloud Procurement perspective and focuses on how to design EDI solutions for vendor integration.
    Content:

    We are implementing Oracle Cloud ERP. We need to communicate with our vendors via EDI.  I have been told that Cloud ERP has standard electronic communication capabilities with vendors via the Oracle Supplier Network.  If we are pure Oracle Cloud ERP environment that seeks to communicate via EDI with non-Oracle vendors, does the Oracle Supplier Network (OSN) support EDI for Cloud Procurement, does an EDI Gateway solution exist for Cloud ERP or does Cloud ERP require an EDI third party integration partner (such as Transcepta).

    Version:
    Fusion Cloud ERP - Procurement
  • Amy Chan
    Define value set with bind variableAnswered115.0
    Topic posted March 14, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged FAQ, Financials, Fusion, How-To, Orders, Setup 
    Title:
    Define value set with bind variable
    Summary:
    Define value set with bind variable
    Content:

    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)

  • Balakrishna Chaturvedula
    Difference between Task Level and Assignee Level1
    Topic posted March 5, 2018 by Balakrishna ChaturvedulaBronze Trophy: 5,000+ Points, tagged Approvals, FAQ, How-To, Notifications 
    Title:
    Difference between Task Level and Assignee Level
    Summary:
    While configuring Expiration Settings we have three options. A good document to explain the functionality would help
    Content:

    Hi All,

    While configuring Expiration Settings in PO or any Approval workflow three options exist:

    1. Do Nothing - Self Explanatory.

    2. Task Level

    3. Assignee Level

    I would like to understand the difference between option 2 and 3. Also, how do these options work in conjunction with "Maximum Escalation Levels". Also, I do not find all approver titles in the field "Highest Approver Title". Any pointers to documentation regarding this would help. Attached is a screen from BPM.

    Thanks, Bala.

    Image: