Oracle Mania
Thursday, 27 March 2025
Query to get Charts Of Accounts structure – Segments and Value Set
›
select hou.name BU_NAME, led.NAME Ledger_Name, Str.STRUCTURE_CODE CHART_OF_ACCOUNTS_Name, SegInSt.SEGMENT_CODE COA_SEGMENT_NAME, vs.value_se...
Thursday, 20 February 2025
Query to Get List of Procurement Agents and Access In oracle Fusion
›
SELECT ppf . display_name , pu . username , hou . name BU_NAME , paa . access_action_code , paa . active_fl...
Sunday, 5 January 2025
Query to get Logged IN user name in Oracle fuson
›
SELECT sys_context ('USERENV', 'CLIENT_IDENTIFIER') FROM dual
Query to get Chart Of Account Structure Name and Segments in Oracle fusion
›
select b.FORM_LEFT_PROMPT "Chart Of Account Segment Name", b.description, a.segment_name "CCA_VALUSET", c.ID...
Tuesday, 16 April 2024
Rest API to Create a AP Invoice in Oracle Fusion
›
Rest API : https://<Host>/fscmRestApi/resources/11.13.18.05/invoices example URI: https://abcd123-test.fa.us2.oraclecloud.com/fscmRes...
Thursday, 25 January 2024
Rest API Payload to create a Party or a organization and site
›
Rest URL: https://<Host>/crmRestApi/resources/11.13.18.05/hubOrganizations Payload: { "PartyNumber" : "98791...
Monday, 2 October 2023
Query to Retrive Purchasing mapping set in oracle fusion
›
select XMST.name, DeliverLoc.LOCATION_NAME, gcc.segment1||'.'|| gcc.segment2||'.'|| gcc.segment3||'.'|| gcc.segment...
›
Home
View web version