Not able to view Responsibilities assigned to Users in Oracle Application Log in to functional administrator responsibility Core Services -> Caching Framework-> Global Configuration Clear Statistics also Clear All Cache (set the Global idle time prior to the modification of the responsibility) Log out and check
Posts
How to Approve back cancelled PR (Oracle Apps)
DECLARE CURSOR c IS SELECT b.requisition_header_id, b.requisition_line_id, b.quantity, a.segment1 FROM po_requisition_headers_all a, po_requisition_lines_all b, po_req_distributions_all c WHERE a.segment1 IN ( SELECT DISTINCT prh.segment1 requisition_num --, fu.user_name requestor, -- papf.full_name, TO_CHAR (prh.creation_date) creation_date, -- prh.creation_date, prh.authorization_status, prh.closed_code FROM apps.po_requisition_headers_all prh, ...
How to delete the Item from Oracle Apps Inventory
Go to Inventory Responsibility Search the function Inventory Delete Items Create one group add the Item which you like to delete save and delete group Auto concurrent triggers ( Delete Item Information) and delete your Item
Oracle Receivables Transaction Missing numbers
--Choose the Batch source specific to the Operating unit / Division SELECT batch_source_id, org_id, name, a.* FROM ra_batch_sources_all a where org_id in (select ORGANIZATION_ID from Hr_operating_units where SET_OF_BOOKS_ID=2089) and STATUS='A' select * from RA_batch_sources_all where batch_source_id in ( 9096, 9106,9102,9113,9122) SELECT 'alter sequence AR.'||seq.sequence_name||' nocache;' FROM (SELECT name bsname, org_id org, 'RA_TRX_NUMBER_'||BATCH_SOURCE_ID||'_'||org_id||'_S' seqname FROM RA_batch_sources_all where org_id in (304) and batch_source_id in ( 9139) ) src, dba_sequences seq WHERE src.seqname=seq.sequence_name -- Pass the Org_id and Batch Source Id --AND seq.cache_size --execute that output COMMIT; --Check the Sequence Cache cleared or not SELECT sequence_owner, sequence_name, cache_size FROM all_sequences WHERE sequence_name LIKE 'RA_TRX_NUMBER_9139_304_S%'; --ALTER sequence...
How to Enable Personalization link for OAF Pages
Set the values of following profiles to enable Personalization Page link in OAF Pages Profile Name Value FND: Personalization Region Link Enabled Yes Personalize Self-Service Defn Yes Disable Self-Service Personal No
XML Publisher Run time Error
Solution : Fix the Java path in run time XML Publisher Run time (to preview from local) ADD Ins ->Tools->Option ->Preview ->Java Home Paste the below the path : 32Bit C:\Program86 Files\Java\jre1.8.0_144 64Bit C:\Program Files\Java\jre1.8.0_144