Step1:
Navigate to:
Setup and Maintenance > Setup Select: Procurement > Search with Manage%Approval
Step2:
Select Header Stage > Edit Rule
Step3: Click
on “+” Icon
Step4: Enter
the Rule Name, Set the Priority (High/Medium/Low) & Description
Step5:
Enter Condition and Action.
Step6:
Click on
Save.
Click on
Deploy.
Lets check Newly created Approval Rule is working or not.
Step7: Create Requisition.
Step8: Click on Manage Approval.
We can able to see the new approval coming in the approval list.
SELECT fsa.reference_group_name,
fs.set_id,
fs.set_code,
fs.set_name,
fs.description,
bu.bu_name
FROM fnd_setid_assignments fsa,
fun_all_business_units_v bu,
fnd_setid_sets_vl fs
WHERE 1 = 1
AND fsa.determinant_type = 'BU'
AND fsa.determinant_value = bu.bu_id
AND fsa.set_id = fs.set_id
AND fsa.reference_group_name LIKE 'PER%'
ORDER BY reference_group_name,
set_code,
set_name,
bu_name
Subject: Enter PR
Line Currency Conversion Rate Issue.
Resolution:
Navigation:
Setup and Maintenance > Finance Application > Search Manage Daily Rates.
Click on
Daily Rates Tab.
Search From EUR to GBP Currency conversion details for the Sep22 period. We not found Spot Conversion Rate for the 15SEP2022. We need to create Conversion Rate for this date to resolve the issue.
Click on
Spread Sheet Button.
If SpreadSheet not asking to connect with Oracle Application than Excel ADFDi Addins are missing.
User Need to Enable those Addins. Refer below link for enabling ADFDi Addin.
Oracle Fusion: ADFDI sheet is blank after opening
We need to
connect spreadsheet with oracle instance. Click on Yes
Enter User Name
and Password of Oracle Application and Login.
Enter the Spread
Sheet Data For Conversion Rate. Click on Submit button from the Top Menu.
Click on
Ok. It will Run Background Request.
It will
process the data
It will
show record successfully Inserted.
We can
verify the data from Manage Daily Rate Screen. Now we can able to see the daily
rates for 15SEP2022
Now we user
try to create foreign currency requisition system will not through an error.
Subject: When we perform bulk customer migration using FBID we need to get ORIG_SYSTEM_REFERENCE after the migration is complete.
Note: HZ_ORIG_SYS_REFERENCES is the base table to store the ORIG_SYSTEM_REFERENCE details
--PARTY ORIG SYS REFERENCE--
SELECT ORIG_SYSTEM_REFERENCE
FROM HZ_ORIG_SYS_REFERENCES
WHERE OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID --NEED TO PASS PARTY_ID
AND ORIG_SYSTEM='CSV'
AND OWNER_TABLE_NAME='HZ_PARTIES' -- FOR PARTY REFERENCE PARTY TABLE NEED TO PASS
--PARTY SITE ORIG SYS REFERENCE--
SELECT ORIG_SYSTEM_REFERENCE
FROM HZ_ORIG_SYS_REFERENCES
WHERE OWNER_TABLE_ID =HZ_PARTY_SITES.PARTY_SITE_ID --NEED TO PASS PARTY_SITE_ID
AND ORIG_SYSTEM='CSV'
AND OWNER_TABLE_NAME='HZ_PARTY_SITES' -- FOR PARTY REFERENCE PARTY SITE TABLE NEED TO PASS
Subject: How to Create Report Structure in Oracle Fusion.
Prerequisite: For creating structure first we need to enable sandbox with having tools "structure"
Step1: Create Sandbox with Tool Structure > Create and
Enter Sandbox
Step2: Navigate to Configuration > Structure
Step3: Create Group > Save and Close.
Name: SCM Maintenance Reports (It’s UI Tab Name)
Select Icon.
Show on Navigator: EL Expression
Step4: Select Group and then Click on Create Page.
Name: GDI WO Item Ordering Report
Group: SCM Maintenance Report
Link Type: Static URL
Destination:
(Note:
1. Copy the URL From the Report Level, Open the Report from Catalog > Settings > Share Report Link > Current Page
2. Yellow Highlighted part is for the dynamically pick the Application instance URL, )
Paste the below URL in the Destination field.
https://#{header["host"]}/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FGDI%20Custom%20Reports%2FSCM%2FMaintenance%2FWork%20Order%2FReport%2FGDI%20WO%20Item%20Ordering%20Report.xdo&path=%2Fshared%2FCustom%2FGDI%20Custom%20Reports%2FSCM%2FMaintenance%2FWork%20Order%2FReport%2FGDI%20WO%20Item%20Ordering%20Report.xdo
Enter all the below information for the BIP Report. Save and
Close
Step5: Navigate to Home Page > SCM Maintenance Report Tab
We can able to access the newly registered reports from the
UI.
