68 questions
Best practices
0
votes
0
replies
37
views
Oracle Fusion to Azure
May Someone help me with Pros and Cons for each approach given below.
I am trying to bring Oracle Fusion SCM and HCM data to Azure using Databricks. I am unaware which option is cost effective, need ...
0
votes
0
answers
81
views
In Oracle Fusion: BI query for internal requisitions
I am writing a BI report and need the proper query links from POR_REQUISITION_LINES_ALL to XLA_AE_LINES.
I've tried linking from POR_REQ_DISTRIBUTIONS_ALL, INV_TRANSFER_ORDER_HEADERS, RCV_SHIPMENTS ...
1
vote
0
answers
69
views
how to get multi selected row values from a table of fusion screen using sandbox page composer
We have a requirement from Oracle fusion process requisition screen, when user selects the multiple rows from search results of table in process requisition screen. we need requisition number values ...
0
votes
1
answer
48
views
Oracle EBS to Oracle Fusion
In Oracle EBS, there is a table called 'ap_invoice_payments_v'. What is this table called in Oracle Fusion?
I need to find one that has the following
invoice_id,
check_number,
accounting_date
- 7,675
0
votes
1
answer
902
views
On Oracle Fusion AR - where is the accounting date for Receipt is located (Database level)?
I am unable to locate the accounting date for Receipts on Oracle tables for Receivables. I have examined the following tables:
ar_cash_receipts_all,
ar_cash_receipt_history_all,
...
1
vote
5
answers
314
views
Is there a way to eliminate duplicate data without using 'distinct' or 'unique' clause?
I cannot use Distinct or Unique clause due to Organisation restrictions. Is there a way to modify the code so that no duplicate values are shown?
My code is listed below:
`SELECT PER_PERSON_NAMES_F....
- 11
0
votes
0
answers
118
views
ce_cashflow table alternate in oracle fusion cloud
I have this query made in EBS which has this table ce_cashflows, now the query has to be migrated to oracle fusion cloud but it seems this table has become obsolete. It has significant role in the ...
0
votes
1
answer
335
views
JSON arrays into CLOB - Oracle
I have to build a following child json payload to supplment the main payload. My question is how can I put these arrays into a clob to pass through as a PSLQL parameter.
Code:
Declare
l_children ...
0
votes
1
answer
766
views
ORA-00932: inconsistent datatypes: expected NUMBER got CHAR - Error when trying to concat
I'm trying to add upon a already working query. Currently, we have only years in the column which are stored as numbers, which is determined like this:
WHEN petf.base_element_name LIKE 'XXXXX%'
THEN ...
- 31
0
votes
1
answer
64
views
Remove Old Style Outer Joins or Add in left join without using ANSL
Adding in a field Assignment_type, found in table PER_ALL_ASSIGNMENTS_F. Current state sql is using (+) outter joins in the where section. When adding in ansl left loin I am getting error 'ORA-25156: ...
- 31
0
votes
1
answer
171
views
How to pass byte data in the xml payload
I am trying to pass a xml payload as an input to a function and in the payload objectZippedData field doesn't take string as an input, instead it needs the input to be in byte format.
def ...
- 5
0
votes
0
answers
2k
views
Oracle Fusion Procurement Report
I have no enough background in SQL and I need to pull the following data into one report:
a. Supplier Name
b. PO number
c. Business Unit
d. Invoice Number
e. Invoice Date
f. Item number
g. Line ...
0
votes
1
answer
538
views
Oracle Fusion Cloud and logging from Groovy scripts
We have some Groovy-scripts triggered on various objects (ServerScripts). These triggers produce unexpected results at times so we're wondering if we can log this to file, or specifically the print ...
0
votes
1
answer
207
views
Getting Oracle Error While trying to convert varchar2 column and retrieve data using BIP report
We have column (field) attribute14 in the oracle table which is of data type VARCHAR2 and is storing date in format '20-MAY-22' (DD-MON-YY).
We have a requirement to develop a BIP report in oracle ...
- 71
0
votes
0
answers
4k
views
BI Report query to get shipping method and carrier name for sales order lines in oracle fusion
I'm trying to create a BI Report which queries sales order lines details, including shipping method and carrier name. But I'm unable to find the correct joins for this. Till now I have an alternative ...
- 69
0
votes
1
answer
640
views
Oracle loud BI Reporting : Xls template
I am developing a report in BI report using xsl template. I have a doubt regarding adding two fields. In rtf template we use <?xdofx: field1 + field2?>. But if I do the same in xls template, it ...
0
votes
1
answer
1k
views
I need to create a python script which calls SOAP GET method using ZEEP or REQUEST modules
I am new to python. I need to fetch data from Oracle fusion cloud. I want to run a BI publisher report on Oracle fusion cloud instance using SOAP API call and get the data into CSV file.
I have tried ...
0
votes
1
answer
1k
views
In Oracle ERP cloud how to get deeper details of Roles which includes Function Security Policies,DataSecurityPolicies,RoleHierarchy of particular Role
We are doing lot of analysis around this but not getting solution for this requirement
Basically we want to fetch deeper details of Roles which includes Function Security Policies, Data Security ...
- 39
0
votes
1
answer
821
views
Find journal approval date in General Ledger Oracle Fusion 20c
How can I find journal approval date in General Ledger Oracle Fusion 20c
- 99
0
votes
1
answer
3k
views
How to hide row in the rtf template for oracle fusion by condition? and what is this markup language named?
I have rtf template made for oracle fusion app
when I upload it do app, when I upload it there, I get such data:
I need to get: Line should not be shown if balance column amount is zero
How to do it ...
- 99
2
votes
2
answers
296
views
Using pattern matching to outer join tables in Oracle SQL
I'm creating a DataModel in Oracle Fusion Financials to match parties together, from supplier use and customer use. These parties have a code which is registered in their name.
Searching for the table ...
- 31
0
votes
0
answers
71
views
External database to oracle fusion
Is it possible to upload an external database into oracle fusion and how? For example I have an excel file that contains data then I want it to upload in oracle fusion then I can use it to create an ...
- 81
1
vote
1
answer
1k
views
Are there any Logic App connectors for Oracle Fusion ERP?
Are there any Logic App connectors for Oracle Fusion ERP?
I've checked the Microsoft list and can only find the Oracle Database connector, which seems amazing.
Alternatively, has one one created a ...
- 17k
0
votes
1
answer
97
views
My custom Webpage for Oracle Cloud Application can be accessed from anywhere
I programmed (on JDeveloper Studio) a custom page for Oracle Cloud Application R13 and it is working like a charm. I deployed my customization on my Oracle WebLogic Server but I couldn't help to ...
- 83
0
votes
1
answer
1k
views
Why does Oracle Fusion EBS use both ENABLED_FLAG and START_DATE_ACTIVE/END_DATE_ACTIVE in its database tables?
A number of the Oracle EBS tables include the columns ENABLED_FLAG, START_DATE_ACTIVE, and END_DATE_ACTIVE which are used to determine whether the row is available in the application or not.
For ...
- 2,114