Alternative use the physical sql in a dataset with data source applicationDB_FSCM in a data model in OTBI. select all t.* , (fnd_flex_xml_publisher_apis.process_kff_combination_1 (upper('FLEXFIELD'), upper('GL'), upper('GL#'), t.chart_of_accounts_id, null, t.code_combination_id, upper('ALL'), upper('Y') , upper('VALUE')))…

Hi, Not sure what you mean by "mapping that to". But I can cut paste that query ok into a data set with data source Oracle BI EE in a data model in OTBI. It returns rows no problem.

Hi, here is the SQL to get the code and description select all 0 s_0 , "Employee"."Employee Default Expense Concatenated Segments" as default_expense_account_code , "Employee"."Employee Default Expense Account" as default_expense_account_description from "Expenses - Expense Transactions Real Time" order by 1 asc nulls…

Hi, Assume you have posted on the wrong forum? This question does not sound like it has anything to with analytics and reporting using Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications. Sounds to me like this is something to do with business process Manage Assets in application Financials…

For any application go to docs.oracle.com/en/cloud/saas/index.html pick your application for example Human Resources in Human Capital Management (HCM) In Top Tasks select Analyze and Report then select the link Review Subject Areas Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM…

When you run a data extract in addition to your data extract files you will get a MANIFEST file and an EXTRACT_STATUS file. The extract status will list the status of each extract including success or failure, how long it took at each of various stages, how many rows extracted. So if you wish to you can read the extract…

Hi, No. The Business Intelligence Publisher (BIP) in Oracle Transactional Business Intelligence (OTBI) in Oracle Fusion Cloud Applications is restricted to only the 4 out of the box data sources HCM, FSCM, CRM and OBIEE.

Maybe create an additional parameter p2 with menu lov based on value of p_string1 (sounds like you do not need parameter p_start p_end) to get the list of values you need out of string 1. Default to pass a string of all values rather than null for all values. Then use :p2 in where. Something like lov for :p2 ??? select all…

Hi, OK. So why not change your design. Make it so you have 2 parameters with 2 list of values p_party_name "Text field contains comma-separated values" = True select distinct t.PARTY_NAME as s from HZ_PARTIES t order by 1 asc nulls last p_party_number "Text field contains comma-separated values" = True select distinct…

Hi, I have NOT suggested that you change "Text field contains comma-separated values" = False. Your IN string can accept multiple values right now. That is not the issue here. If p null then get all values else get values in p. … and (coalesce(null,:p) is null or HZP.PARTY_NAME in (:p)) I was simply stating that you cannot…

:P_STRING1 is a comma separated list of values 'A','B','C'. You can not substring it. You can only put 1 string into the first parameter of the substring function but you are putting many strings into argument 1 hence the error. Here is your user guide for the function SUBSTR Oracle® Database SQL Language Reference 23ai…

Hi Wendy, Unfortunately if in the data model the designer of this subject area has made this column a data type "day" date YYYY-MM-DD in the metadata repository database (RPD) then there is not a lot you can do to get the time bit back. The time of day bit has already been truncated off at design time so you cant get it…

Hi, have a look at using these tables/views FA_FUSION_SOAINFRA.WFAPPROVALGROUPS FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS not sure if this data is exposed in an API or not

Hi Praveen, Please refer to the oracle part numbers and licencing documents etc. Yellow are reports in OTBI. The object you create in the catalog in OTBI is a "report". Yellow are reports in OTBI from product Oracle Business Intelligence Publisher (BIP) which is one of the many products in suite of products in platform…

Hi, You can use page Manage Calendar Events. Setup events of type Public Holiday by Geography. Then join to the transaction you are looking, in this case a purchase requisition, for example based on the HCM person worker assignment location of the requester having the same geography. Add this query in your data model in…

Hi Pooja, As a general rule of thumb you need a measure column (yellow ruler icon) from a fact in each subject area along with a dimension attribute column (blue icon) that is common which both facts join to at the same level. To work out if you have selected the correct presentation columns cut paste your logical sql from…

Hi, Most all subject areas have a time day dimension. If by working day you mean not a Sat or Sun then you can add a function to filter out only days in the week based on day of the week number. To get last then you can use a aggregate function to get max/greatest or min/least. But if you have configured public holidays in…

Hi Robert, FYI We have it working on receivables transactions (but we have not tried it with payables transactions like Scott) Using Receivables Credit to Cash Setup: Add note on transaction header Select Navigator, select Show More. In Receivables select work area Billing. Select Tasks, in Transactions select task Manage…

Hi, Yes the name of an additional information field DFF presentation column in your subject area is derived from the fields you setup on page "Manage Descriptive Flexfields". This is what is read by the biextender scheduled process when in adds your column to the subject areas in the metadata repository database. So you…

Yes OTBI report = BIP report. A report in OTBI is yellow. It is a yellow file in the catalog / on the create menu in OTBI. A report in OTBI is a business intelligence publisher (BIP) report. BIP is just one of the suite of products in platform OBI in OTBI in Oracle Fusion Cloud Applications. The other products in the suite…