Payables & Cash Management

Get Involved. Join the Conversation.

Posts

  • Kalpim
    Error while loading BAI2 bank statements to Oracle Fusion1
    Topic posted Yesterday by Kalpim, tagged Cash Management, Payables 
    Title:
    Error while loading BAI2 bank statements to Oracle Fusion
    Summary:
    Processes fail while uploading statements to Oracle Fusion
    Content:

    Hello everyone,

    The process of loading the BAI2 files to Oracle Fusion cloud ends with error. Please let me know if you have come across a similar issue.

    Here is the log:

    **** Bank Statement processing program for cloud running, Request ID: 262723
    ------ Waiting on Child Process with request ID: 262724 -------
    **** Bank Statement processing program for cloud running, Request ID: 262723
    Request 262723 was resumed with pause state PausedState1
    checkSubRequestsState begin -- parent requestId = 262723
    Process ID: 262724 ended in ERROR.
    The execution status of one or more subrequests is ERROR
    START - deleting the zip file from content server.
    END - deleting the zip file from content server.
     

    Thank you!

  • Sathya Kannan
    Cancellation reason in Accounts Payable - Invoices work areaAnswered2
    Topic posted Yesterday by Sathya KannanBlue Ribbon: 750+ Points, tagged Configuration, Financials, Payables 
    Title:
    Cancellation reason in Accounts Payable - Invoices work area
    Summary:
    Cancellation reason when cancelling an invoice in Accounts Payable
    Content:

    Hi,

     

    Can anyone tell us how to enable cancellation reason within AP Invoices work area? 

     

     

    Regards,

    Sathya Kannan

  • J Tompkins
    Communication between payables and procurement users1
    Topic posted September 19, 2019 by J TompkinsGreen Ribbon: 100+ Points, tagged Financials, Payables 
    Title:
    Communication between payables and procurement users
    Summary:
    Best practice for payables users to communicate to procurement users
    Content:

    We have instances when invoice/PO discrepancies need to be investigated by procurement users.  What is the best way to accomplish communicating these discrepancies from AP users to procurement users?

  • PK
    AP Invoice Hold3
    Topic posted September 19, 2019 by PKRed Ribbon: 250+ Points, tagged Financials, Payables, Setup / Administration, Tip 
    Title:
    AP Invoice Hold
    Summary:
    AP Invoice hold based on the criteria that if there is any prepayment available for the same supplier
    Content:

    Hello, We create all the prepayment with the reference of Purchase order . We would like to make a rule and put the invoice on hold based on the criteria that if there is any prepayment available for the same supplier and for same PO for which we are going to make the payment, system should stop the payment to force the user to verify if their are any prepayments available for this supplier corresponding to the same PO.

    Is there any way?

    Many thanks in advance for your inputs.

  • Amol
    RCTI (Recipient Created Tax Invoices) functionality...Answered1
    Topic posted September 19, 2019 by AmolBronze Trophy: 5,000+ Points, tagged Financials, Payables 
    Title:
    RCTI (Recipient Created Tax Invoices) functionality in Oracle Payables Cloud
    Content:

    Looking for some guidelines on how to implement RCTI invoices in Oracle ERP Cloud.

    In such cases, suppliers don't issue TAX Invoices but the recipient(customer) pays the tax and also provides a tax invoice to supplier for the goods.

  • Sirisha
    How can we restrict same invoice number across multiple...1
    Topic posted September 18, 2019 by SirishaRed Ribbon: 250+ Points, tagged Financials, Payables 
    Title:
    How can we restrict same invoice number across multiple Operating Units in EBS R12
    Summary:
    We had come across an issue where the invoice was entered in 2 different OUs with the same details and got paid with 2 different payment methods.
    Content:

    We had come across an issue where the invoice was entered in 2 different OUs with the same details and got paid with 2 different payment methods. How can we control the same invoice isn’t paid by two entities.

    Do we have any control on invoice status so that the members of the team would know whether an invoice has been processed?  Since the emails go to an email address for the team, how do the team members know who is processing which invoice?

    Version:
    R12
  • Melissa Stewart
    Invoice Notes Disappearing1
    Topic posted September 18, 2019 by Melissa StewartGreen Ribbon: 100+ Points, tagged Payables 
    Title:
    Invoice Notes Disappearing
    Summary:
    Invoice Notes Disappearing
    Content:

    When entering an invoice, user enters invoice notes, clicks Save. When the user goes back to view notes, the notes did not save. 

    This only occurs for certain users, not all. We have checked Security, and the users have the correct roles assigned. 

    The issue seems to have started after 19 C went in. 

    Has anyone else seen this issue?

    Thank you.

    Melissa

    Version:
    19C
  • 2019-07-04
    New FinApIncompleteInvoiceHold Rules - not changing who can...Answered2
    Topic posted September 17, 2019 by 2019-07-04Red Ribbon: 250+ Points, tagged Payables 
    Title:
    New FinApIncompleteInvoiceHold Rules - not changing who can see which invoices
    Content:

    Hi,

    We are using 19B (11.13.19.04.0).

    Currently we scan invoices, and when going to Payables > Invoices there is a "Scanned" infotile which contains thousands of Incomplete invoices.

    Click on a view from that Infotile (e.g. it says 3.52k on the 15+ section) and all the Incomplete invoices are listed.

    In the "Assignee" column, many people are listed.

    We want to restrict who can see which invoices, based on Supplier name.

    Therefore I am testing around creating rules to route Incomplete AP Invoices to specific users based on the initial letter the Supplier Name starts with.

    I have done the following:

    1. Create Custom Roles:

    I have created 37 new "Common - Abstract Roles"

    Init Role Name / Role Code Role Description
    . XX_AP_SUPPLIERS_0_DOT Suppliers whose name starts with '.'
    1 XX_AP_SUPPLIERS_1_1 Suppliers whose name starts with '1'
    2 XX_AP_SUPPLIERS_2_2 Suppliers whose name starts with '2'
    3 XX_AP_SUPPLIERS_3_3 Suppliers whose name starts with '3'
    4 XX_AP_SUPPLIERS_4_4 Suppliers whose name starts with '4'
    5 XX_AP_SUPPLIERS_5_5 Suppliers whose name starts with '5'
    6 XX_AP_SUPPLIERS_6_6 Suppliers whose name starts with '6'
    7 XX_AP_SUPPLIERS_7_7 Suppliers whose name starts with '7'
    8 XX_AP_SUPPLIERS_8_8 Suppliers whose name starts with '8'
    9 XX_AP_SUPPLIERS_9_9 Suppliers whose name starts with '9'
    0 XX_AP_SUPPLIERS_10_0 Suppliers whose name starts with '0'
    A XX_AP_SUPPLIERS_11_A Suppliers whose name starts with 'A'
    B XX_AP_SUPPLIERS_12_B Suppliers whose name starts with 'B'
    C XX_AP_SUPPLIERS_13_C Suppliers whose name starts with 'C'
    D XX_AP_SUPPLIERS_14_D Suppliers whose name starts with 'D'
    E XX_AP_SUPPLIERS_15_E Suppliers whose name starts with 'E'
    F XX_AP_SUPPLIERS_16_F Suppliers whose name starts with 'F'
    G XX_AP_SUPPLIERS_17_G Suppliers whose name starts with 'G'
    H XX_AP_SUPPLIERS_18_H Suppliers whose name starts with 'H'
    I XX_AP_SUPPLIERS_19_I Suppliers whose name starts with 'I'
    J XX_AP_SUPPLIERS_20_J Suppliers whose name starts with 'J'
    K XX_AP_SUPPLIERS_21_K Suppliers whose name starts with 'K'
    L XX_AP_SUPPLIERS_22_L Suppliers whose name starts with 'L'
    M XX_AP_SUPPLIERS_23_M Suppliers whose name starts with 'M'
    N XX_AP_SUPPLIERS_24_N Suppliers whose name starts with 'N'
    O XX_AP_SUPPLIERS_25_O Suppliers whose name starts with 'O'
    P XX_AP_SUPPLIERS_26_P Suppliers whose name starts with 'P'
    Q XX_AP_SUPPLIERS_27_Q Suppliers whose name starts with 'Q'
    R XX_AP_SUPPLIERS_28_R Suppliers whose name starts with 'R'
    S XX_AP_SUPPLIERS_29_S Suppliers whose name starts with 'S'
    T XX_AP_SUPPLIERS_30_T Suppliers whose name starts with 'T'
    U XX_AP_SUPPLIERS_31_U Suppliers whose name starts with 'U'
    V XX_AP_SUPPLIERS_32_V Suppliers whose name starts with 'V'
    W XX_AP_SUPPLIERS_33_W Suppliers whose name starts with 'W'
    X XX_AP_SUPPLIERS_34_X Suppliers whose name starts with 'X'
    Y XX_AP_SUPPLIERS_35_Y Suppliers whose name starts with 'Y'
    Z XX_AP_SUPPLIERS_36_Z Suppliers whose name starts with 'Z'

    2. Edit the "FinApIncompleteInvoiceHold" Task.

    3. Disable the seeded "JobRoleAssignmentRule" rule that is included in the "FinApIncompleteInvoiceHold" Task

    4. Create one Rule to link to each Role - example screenshots attached for suppliers whose names start with "A"

    5. Saved changes

    6. Clicked "Commit Task" button.

    I did all of that, and assigned a custom Role to a user, thinking that user would only see invoices. However, they see the same invoices as a user without any of the custom roles.

    I wondered if I was wrong in thinking my solution for viewing Incomplete invoices would work?

    If it's the right approach to take, is there anything I can do to refresh the Assignees associated with invoices based on the changes I have made to the FinApIncompleteInvoiceHold Task?

    Or - will my changes on take effect for new invoices, and the existing invoices cannot have their Assignees updated based on the Task updates?

    Any advice much appreciated.

    Thanks

    Jim

    Version:
    19B (11.13.19.04.0)
    Image:
  • Tudor Hanga
    Link between Create Accounting subprocesses2
    Topic posted September 17, 2019 by Tudor HangaRed Ribbon: 250+ Points, tagged Financials, General Ledger, Payables, Reports 
    Title:
    Link between Create Accounting subprocesses
    Summary:
    We need to find a link between 'Post Journals for Single Ledger' and the original 'Creating Accounting' job.
    Content:

    Hi,

    The Create Accounting ESS Job has multiple subprocesses running (e.g. Create Accounting: Subprocess, Post Subledger Journal Entries, Post Subledger Journal Entries: Subprocess, Import Journals: Child, Post Journals for Single Ledger, Maintain Payables Trial Balance Report).
    However, I noticed these are not in a hierarchical relationship with the initial Job (Create Accounting). Is there a way to link for example the subprocess 'Post Journals for Single Ledger' with the original 'Create Accounting' Job? Either via sql (ess_request_history, ess_request_property) or via user interface?

    Thank you!

    Version:
    19B (11.13.19.04.0)
  • Triveni Reddy
    Mass Upload Employee procurement Cards25.0
    Topic posted September 16, 2019 by Triveni ReddyGreen Ribbon: 100+ Points 
    Title:
    Mass Upload Employee procurement Cards
    Summary:
    Mass Upload Employee procurement Cards
    Content:

    Hello, my client has a requirement to do bulk upload of employee procurement cards (PCards setups) (not transactions) into oracle procurement cloud from an on-prem application. I haven't found any documentation on this, not was able to find a REST API or web service to peform this activity. Can anybody through shed some light on this? If there is an API to upload Pcards, can you share the details