Posts

Posts

  • Ujas Bhatt
    Number of record (data) limit in FBDI v/s ADFDi105.0
    Topic posted May 16, 2019 by Ujas BhattSilver Trophy: 7,500+ Points, tagged Financials, Fusion, Manage Procurement Catalog, Public Sector, Tip, White Paper in Procurement > Purchasing public
    Title:
    Number of record (data) limit in FBDI v/s ADFDi
    Summary:
    Is there a predefined limit for number of records that can go to system while we upload data using FBDI or ADFDi ?
    Content:

    Hi Experts,

    This questions is precisely from Procurement and Finance FBDI  and ADDFi prospective.

    Is there a predefined limit for number of records (data) that we can use in FBDI and ADFDi while we upload the data using spreadsheet?  If yes, do we have any standard oracle document around this indicates this information?

    Also, is there a setup hosted by Oracle that we can increase or decrease this limit ?

    Appreciate your help !!!

    Regards,

    Ujas

  • Ramesh Radhakrishnan
    Privilege/ Role needed to Cancel Requistions using ADFi...Answered10
    Topic posted November 6, 2018 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged How-To, Public Sector, Setup in Procurement > Self Service Procurement public
    Title:
    Privilege/ Role needed to Cancel Requistions using ADFi spreadsheet
    Content:

    What is the Privilege/ Role needed to Cancel Requistions using  ADFi spreadsheet?

    Thanks

    Ramesh

    Version:
    R13-18C
  • Dave Dengate
    Displaying Unmasked Bank Account10
    Topic posted April 3, 2017 by Dave DengateBlue Ribbon: 750+ Points, tagged Public Sector, Supplier Creation, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Displaying Unmasked Bank Account
    Summary:
    When Maintaining Bank Accounts we need to see the full Bank Account number
    Content:

    There are occasions when our Account Payable's manager need to see the full bank account number to ensure we are creating duplicates or allocating the wrong Bank Account to a Supplier.

    Is there a way within Fusion where the full Bank Account Number (I.e. 12345678, not xxxx5678) can be displayed.?

  • Janusz Jasinski
    Get the correct PO Number for an Invoice Number9
    Topic posted September 6, 2019 by Janusz JasinskiBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, Public Sector in Reporting and Analytics for ERP public
    Title:
    Get the correct PO Number for an Invoice Number
    Content:

    Hi,

    We had some consultants in they wrote a large piece of SQL, of which the below is a small part. It's looking to get the correct PO number for a specific invoice number. Specifically the code in bold

    XTE = XLA_TRANSACTION_ENTITIES

    (
    CASE
    WHEN
    GJH.JE_SOURCE IN 
    (
    'Purchasing', 'Payables'
    )
    THEN
    (
    SELECT DISTINCT
    PHA.SEGMENT1 
    FROM
    AP_INVOICES_ALL AIA, PO_HEADERS_ALL PHA 
    WHERE
    AIA.PO_HEADER_ID = PHA.PO_HEADER_ID 
    AND AIA.PO_HEADER_ID IS NOT NULL 
    AND AIA.INVOICE_NUM = XTE.TRANSACTION_NUMBER 
    AND AIA.INVOICE_ID = XTE.SOURCE_ID_INT_1) 
    WHEN
    GJH.JE_SOURCE IN 
    (
    'Receipt Accounting'
    )
    THEN
    (
    SELECT
    CPOD.PO_NUMBER 
    FROM
    --cmr_transactions ct
    CMR_PURCHASE_ORDER_DTLS CPOD , CMR_RCV_EVENTS CRE , POZ_SUPPLIERS_V PS 
    WHERE
    CRE.CMR_PO_DISTRIBUTION_ID = CPOD.CMR_PO_DISTRIBUTION_ID 
    AND CPOD.VENDOR_ID = PS.VENDOR_ID 
    AND CPOD.ACTIVE_FLAG = 'Y' 
    AND CRE.ACCOUNTING_EVENT_ID = XTE.SOURCE_ID_INT_1 ) 
    ELSE
    NULL 
    END
    )
     
    This seems to happen where an invoice has been matched incorrectly to a Purchase Order on the Payables module, and then a correction is made to match it to the correct Purchase Order but the report does not seem to reflect this correction.
     
    Any advice?
     
  • Ujas Bhatt
    Finance/Procurement Cloud - Rel 13 - Listing of new features...9
    Topic posted February 26, 2018 by Ujas BhattSilver Trophy: 7,500+ Points, tagged Financials, General Ledger, Help Center, Payables, Public Sector, Reports, Setup / Administration, Subscriptions, Tip, Update in Core Financials > Financials – General public
    Title:
    Finance/Procurement Cloud - Rel 13 - Listing of new features and functionality enhancements
    Summary:
    Finance/Procurement Cloud - Rel 13 - Listing of new features and functionality enhancements
    Content:

    We are planning to upgrade our current Oracle Financial/Procurement cloud instance from Rel 12 To Rel 13.  I am looking out for list of New features and functionality enhancements for Finance/Procurement in "Excel" format.

    Can anyone help how can we get the listing of new features and functionality enhancements in Excel format?  Does oracle provides listing of new feature and functionalities other then PDF/HTML format?

    Thanks,

    Ujas

  • Ramesh Radhakrishnan
    Supplier Profile change - Prevent changing Company name in...Answered95.0
    Topic posted January 29, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged How-To, Public Sector, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Supplier Profile change - Prevent changing Company name in supplier portal
    Content:

    We have a business requirement to prevent supplier users from creating a supplier profile change to update the company name using supplier portal profile change.  How do we prevent supplier making edit to company name field and make it just read only? Any pointers to achieve this in the supplier portal?

    Version:
    R13-18C
    Image:
  • Harshal Agrawal
    Configurator Rules9
    Topic posted July 6, 2018 by Harshal AgrawalRed Ribbon: 250+ Points, tagged Configurator, Public Sector in Order Management > Configurator public
    Title:
    Configurator Rules
    Summary:
    Oracle Configurator Rules
    Content:

    Hi All,

    How we can have write the rules based on Supplemental structure ?
    I have added supplemental structure value to the option feature and its option in the configurator.
    I am trying to set the value from supplemental structure to decimal feature so that i can perform arithmetic operations, but i am unable to do that. Please help me how can I solve this using rules.

    Thanks,
    Harshal

  • Yasmin
    Roles and users accessAnswered95.0
    Topic posted September 20, 2017 by YasminSilver Trophy: 7,500+ Points, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Public Sector, Sales, SCM, Security, Tip in Applications Security public
    Title:
    Roles and users access
    Summary:
    Roles and users access audit report
    Content:

    We are looking to run an audit report to list all the users and their access roles 

    where can we get/run such report?

  • Annette Massie
    Approved requisitions not generating PO'sAnswered8
    Topic posted July 26, 2019 by Annette MassieRed Ribbon: 250+ Points, tagged BI Publisher Reports, Business Intelligence, Public Sector in Procurement > Purchasing public
    Title:
    Approved requisitions not generating PO's
    Content:

    We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

    SELECT prh.requisition_number
    ,prl.line_number
    ,prl.line_status
    ,prl.req_po_instance_id
    ,prl.reqs_in_pool_flag
    ,ph.segment1 AS po_number
    ,prh.emergency_po_number
    ,prl.reqtopo_automation_failed
    ,prl.reqtopo_auto_failed_reason
    ,msg.context AS failed_reason_text
    ,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1,
    NULL) AS SOLDTO_LE_ID
    ,prh.pcard_id
    ,prl.line_type_id
    ,prl.pcard_flag
    ,prl.requisition_header_id
    ,prl.requisition_line_id
    ,prl.prc_bu_id AS req_line_prc_bu
    ,prh.prc_bu_id AS req_header_prc_bu
    ,prl.req_bu_id
    ,prl.assigned_buyer_id
    ,prl.negotiated_by_preparer_flag
    ,prl.negotiation_required_flag
    ,prl.source_document_type
    ,prl.source_doc_header_id
    ,prl.vendor_id
    ,prl.vendor_site_id
    ,prl.line_location_id
    ,prl.item_id
    ,prl.category_id
    ,prl.amount
    ,prl.quantity
    ,prl.unit_price
    ,ph.document_creation_method
    ,ph.prc_bu_id AS po_prc_bu
    ,ph.document_status
    ,ph.po_header_id
    FROM po_headers_all ph
    ,po_lines_draft_all pl
    ,por_requisition_lines_all prl
    ,por_requisition_headers_all prh
    ,fnd_messages_b msg
    WHERE ph.po_header_id(+) = pl.po_header_id
    AND prl.po_line_id = pl.po_line_id(+)
    AND prl.requisition_header_id = prh.requisition_header_id
    AND prh.requisition_number IN ('RQ17135')
    AND prl.reqtopo_auto_failed_reason = msg.message_name(+)
    ORDER BY prl.requisition_header_id, prl.line_number; 

    Version:
    19B
  • Srikanth
    UOM mismatch and quantity discrepancy between initial search...Answered84.5
    Topic posted July 24, 2019 by SrikanthSilver Medal: 2,000+ Points, tagged Create Requisition, Internal Material Transfer, Public Sector in Procurement > Self Service Procurement public
    Title:
    UOM mismatch and quantity discrepancy between initial search and review cart screens - in scenario Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal Sources
    Summary:
    UOM mismatch and quantity discrepancy between initial search and review cart screens - in scenario Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal
    Content:

     

    1. Consider below scenario for Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal Sources:

    Quantity = 1

    Item purchasing UOM: Bag of 1000 (with 1000 Each as UOM conversion)

    Item issue UOM: Each

    2. Search for item in self service procurement

    3. Purchasing UOM appears for item with quantity = 1 (i.e. Bag of 1000)

    4. Add item to cart

    5.  Review cart. UOM changes to issuing UOM (but quantity remains one). Summary: Quantity value remains same but UOM changes at this step

    6. Initial quantity = 1000 Each (considering UOM conversion)

    7. Quantity during cart review = 1 Each 

    8. Summary: UOM mismatch and quantity discrepancy between initial search and review cart screens

     

    9. Why bug? When user search, the quantity that appears is different from the quantity that appears when the user reviews the cart. This leads to operational impact (sufficient quantity not available) or excess inventory holding cost (excess inventory) if the users consider initial quantity as source of truth

    10. Suggested solution: For this scenario of internal intra-organization transfer for destination type expense, upon search with the given item, the initial search screen should return the issuing uom directly (instead of the purchasing uom). 

    If item is not internal transfer enabled in the given deliver-to location, then the purchasing UOM needs to come in the initial search screen.

    11. Conclusion: Kindly request to resolve this bug in 19D

    With 15000 users having self service procurement, such kind of discrepancies lead a lot of operational and financial issues.  The impact is also documented above