To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Payables, Payments & Cash Management
Discussion List
-
View Cash Position Report is not fetching the Closed Booked Balance, Inflow and Out FlowCash Management UI View Cash Position we are not able to see the Closed Booked Balance, Inflow and Out Flow amounts. We have executed the below jobs, but still not fetch… -
Autoreconcile Bank Statements is going in to errorSummary: we are trying to mass reconcile bank statement lines using FBDI. We have followed the below document 21D-Mass_Reconciliation_of_Bank_Statement_Lines_and_System_… -
Query Regarding Invoice Attachment Generation in IDR SystemDear All When an invoice is generated using IDR, it automatically includes an attachment in URL format referencing a PDF. I would like to know where these PDF files are …
-
Need a query for AP Invoice validated by and validate date two column store in which tableSummary: Need a query for AP Invoice validated by and validate date two column store in which table Content (please ensure you mask any confidential information): Versio…
-
We cannot download Invoices Pdf for all in Bulk. How can we download all invoices pdf in one shot.Summary: We cannot download Invoices Pdf for all in Bulk. How can we download all invoices pdf in one shot. Content (please ensure you mask any confidential information)…
-
Can we manually update the AP_INVOICE_DISTRIBUTIONS_ALL ?Summary: We are converting open AP invoices(some of which may be accounted (and unpaid) which others may be unaccounted. The accounted AP invoices will be part of projec…
-
Remittance Advise output is blankHi We customized the remittance advise report, and we can see the custom remittance advise format is getting picked up once the PPR process completes. we can see the log…
-
Line Group Number update in InvoiceSummary: Line Group Number update in Invoice at Line Level Content (please ensure you mask any confidential information): I'm not seeing any feasibility in updating the … -
Relationship between Invoice Tolerance and Hold NameSummary: Relationship between Invoice Tolerance and Hold Name Question: As part of Custom BIP report design, we need to establish a relationship between Invoice Toleranc… -
How to create a new prorate formula for multiperiod accounting?Summary: There are 2 oracle seeded prorate formula but can we create a new formula based on client needs? Please provide guidance. Content (please ensure you mask any co…
-
How To Create one GL Journal Entry Per One Subledger Journal EntrySummary: System is not generating one GL journal Entry per one Subledger journal Entry. What is the setup to have one GL journal Entry per one Subledger journal Entry? C…
-
Cloud 23D: AP can we have US Based Taxes on AP Fright line type in an AP Invoice?Summary: we have a requirement to have Taxes on AP Fright Line for Cloud Payables Invoice line Content (please ensure you mask any confidential information): Version (in…
-
Does invoice REST-API in 23D require language header?Hi, After upgrading our TEST and DEV environments to 23D, some of our REST-calls to ERP started failing with the message: ORA-20000: Applying List binding LOV_Type with …
-
Can we save an attachment in database / in BLOB ?Summary: We are in design phase of migrating our Oracle R12.1 financials to Oracle Fusion. We know Fusion allows invoice attachment that gets stored in UCM. But, in fusi… -
PO UOM Incorrect, Returned partial items, Supplier issues Credit MemoHello, I'm asking for help with the below scenario. A Purchase order was issued for 25 units of tubing, at $2.43 each The price billed by the vendor was 25 at $60.75 eac… -
How to restrict the cancelation of invoice if asset is already postedSummary: We have a scenario where User has posted the asset and then Invoice is cancelled in AP? can we restrict the cancelation of invoice if asset is already posted Co…
-
Project details not reflected in Invoice Line for Invoices matched to OrderHi, We cannot see the project details for invoices matched to Order at Invoice Line level. We can only be able to see it at Invoice distribution level. Is this a standar…
-
IDR processing invoice lines as MISC instead of against POSummary: IDR is processing invoices with Miscellaneous lines instead of against the PO. Content (please ensure you mask any confidential information): The Purchase Order…
-
Can we restrict only few invoices to be picked for all suppliers while running PPRSummary: Can we restrict only few invoices to be picked for all suppliers while running PPR Content (please ensure you mask any confidential information): We have requir…
-
AP Bulk Withdraw and Resubmit Invoice ApprovalsHi - I am supporting a customer who is on Release 22B. They went live with Oracle a few months ago. They have about 1,000 AP invoices which are waiting for approval with…
-
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…
-
How to transfer External transactions next monthSummary: We have lot of accounting warning external transactions are pending from Jan-23, we need to account all in Sep-23, how can we transfer GL date for those transac…
-
Change cash management create accounting periodContent Hi Is it possible to have Create Accounting create journals with an accounting date based on the transaction date of an external transaction rather than the bank…
-
How to get workflow error in case Dynamic SQL Query Using Database Query FunctionSummary: The BPM workflow participants are created with Dynamic SQL Query Using Database Query Function in AP Invoice workflow. When the query does not return the value,…
-
How can we cancel and account Recurring invoices that are future dated.Summary: We have few Recurring invoices which need's to be cancelled and accounted as these were continuously appearing on hold report during month end close we want the…
-
Does Oracle Support anything other than XML-1 and any plans to support XML-3, XML-9, XML-12It is my understanding that currently Oracle only supports XML 1.0. Many banks globally have implemented XML version 3 (XML3) as well as version 9 and some are moving to…
-
-
Parameterised file name needed at payment transmission configuration Printable View UpdateSummary: Parameterised file name needed at payment transmission configuration We are using direct debits and configured the setups accordingly. Attached is the file for …
-
Possibility to automatically match AP invoices to POSummary: When an AP invoice gets into the system, it has to be manully matched with the purchase order or purchase order line. Is there any possibility that when the inv…
-
How to copy the DFF values from Payables Invoice Item Line to Tax Line when we are Prorating TaxSummary: For Project Related Payables Invoices, we are storing the Location Code in PJC_USER_DEF_ATTRIBUTE field and when we import the invoice through FBDI template wit…