For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
"Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program
![]() |
"Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1) |
Hello,
In the recent 19A update, Oracle have introduced the ability to process sales orders for Projects. The functionality allows you to enter project charging details on/each individual line basis.
Whilst I have discussed this with support and product design, it doesn't appear that automating the functionality is yet available - or at least speeding it up.
So for my organisation, we a projects facing delivery organisation where there are 1000's of projects. Majority (so hundreds) of which will need items from Inventory, over the life cycles each months for different volumes. Some Projects may need one item in a month - others need 300 items in a month.
This enhancement would be ideal to adopt but what concerns me is the volume of manual work that is needed. Effectively, adding the project charging details on a line by line basis would not work for us.
Oracle support have suggested an Order Management Extension which could achieve the same outcome?
Extract from Support:
Currently there is no defaulting supported for defaulting of the project related attributes while entering it from
the UI. Are all of the 50 lines on the order expected to be against the same project and carry the same values for all the project information? If so, they can consider entering the project on one of the line and then writing an order management extension to copy the project information from one of the line to rest of the lines assuming it has the same project information for all of the lines.
Has any other users of OM who rely heavily on Project charging having the same issue? How are other organisations charging transactions back to projects on a large volume scale?
Thanks,
Alex
Users can no longer dismiss notifications. When hovering over the notification in the Pending Notifications list (accessed from the Bell icon), the [X] (delete option) does not appear. The users have noted the long list of notifications but do not have the same way to clear them. Any FYI notifications from before the 19D patch was applied do have the [X] option and any notifications from Monday and later (post-19D) do not.
Has this feature been modified?
Thank you.
Hello,
What security role do I need to access the General Ledger Dashboards: Account Analysis, General Journals, Trial Balance, etc?
At the moment, I am a super-user, I can see and edit all the objects, but I see no data in any of the reports.
These are the reports I am trying to access: https://docs.oracle.com/cd/E51367_01/financialsop_gs/OCUAR/F1550150AN11FF9.htm#F716749AN122F4. The BI Publisher reports work without any issues, but the Analytics reports do not show any data.
Any thoughts would be appreciated.
Thanks!
Hi,
We have a requirement for a global project that the value set values (Descriptions) we have in "English" should be in multi language depending upon the user location.
For example, during configuration we will update all the description in "English" for value set values, however when a china user logins, he / she should be able to see the value description in Mandarian language. Similarly for other users across the globe.
Please suggest if this is achievable in oracle cloud ERP.
Thanks !
Hi Friends,
I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create parameter. Could you please let me know the process for adding account(GL_CODE_COMBINATIONS - SEGMENT1to7) parameter to custom BI Publisher report.
Appreciated your quick help..!
Thanks
Lak
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11. Please help us with solution if you are faced the same in R12 upgrade.
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11. Please help us with solution if you are faced the same in R12 upgrade.
Hi
We're using the AIP invoice imaging cloud solution. We create a lot of blanket/open/draw-down POs which have a single value line intended to cover multiple invoices and receipts for a period of time. These are particularly used by our department running catering/food vendoring outlets.
We have an issue where the PO number is read succesfully on the invoice and multiple line invoices are read and multiple invoice lines then created but fail to be matched to the single PO line available leaving the lines partially entered and the invoice as 'Incomplete' status. So the AP team have to manually match all the invoice lines against the single PO line. If there is only one PO line why don't all OCR read invoice lines get matched against it by default? Some multiple invoices do match to a single PO line succesfully but the majority do not.
Is anyone else experiencing this issue and have you found any configuration setting for invoice imaging or workarounds that assisted first time invoice matching?
Many thanks
Andy Cleary
I am using Oracle Fusion, the finance/payables reporting side of things
I have the following code:
SELECT DISTINCT PHA.SEGMENT1
FROM
AP_INVOICES_ALL AIA, -- https://docs.oracle.com/en/cloud/saas/financials/19a/oedmf/AP_INVOICES_ALL-tbl.html
PO_HEADERS_ALL PHA -- https://docs.oracle.com/applications/farel12/procurementop_gs/OEDMP/PO_HEADERS_ALL_tbl.htm
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
This "works" in that it returns no errors. However it's looking at the wrong table so wrong data is being brought back. No biggie, we have identified which table it is.
It's used in a wider context as below to define a column value
(
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
) AS PURCHORDERNUM,
However I need to amend the SQL to be the following:
SELECT DISTINCT PHA.SEGMENT1
FROM
AP_INVOICE_LINES_ALL AIA, -- https://docs.oracle.com/en/cloud/saas/financials/19a/oedmf/AP_INVOICE_LINES_ALL-tbl.html
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
This now brings me back `ORA-01427: single-row subquery returns more than one row` but I can not see why. I am merely changing the table it is looking at *and* using DISTINCT