1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 /************************************************************************** *PURPOSE:… Read More »SQL Query to list Active Responsibilities of a Active User
1 2 3 4 5 6 7 8 9 10 11 12 13 14 /************************************************************************** *PURPOSE: To list out Responsibilities assigned to a Request Group… Read More »SQL Query to list out Responsibilities assigned to a Request Group
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to list all Oracle Reports assigned to a Responsibility
Once I encountered a situation where in a Shipment Line of Inter-Org Transfer has Zero Quantity on Receiving end. Here is the screenshot of the… Read More »Inter-Org Transfer has Zero Quantity on Receiving end!
Once I have encountered a situation wherein an Internal Sales Order is not created for an Internal Requisition. Below are the steps I have followed… Read More »Debugging an Internal Requisition which not turned to an Internal Sales Order
When working with Internal Order Process, I had met the following problem: 1) Created Internal Requisition and Approved it. 2) Ran “Create Internal Order” concurrent… Read More »Internal Requisition not imported to Order Management
THIS WORKS WITH ORACLE R12 Here is a wonderful oracle seeded Procedure fnd_web_sec.get_guest_username_pwd which will help us to find out user password. This will be… Read More »[Decrypting User Password]How to find password of a User in Oracle Apps R12?
TOAD can report error “ORA-02404: specified plan table not found” when trying to display execution plans To come out of this problem In TOAD, Navigate… Read More »[TOAD Error] Specified Plan Table not Found while trying to see Explain Plan of a Query
I encountered this problem when I was using a fresh cloned instance. I wasn’t able to see Ship Confirm button in Shipping Transactions Form (STF) as… Read More »Ship Confirm button greyed out in the Shipping Transactions Form (STF)
List of Profile Options in Oracle HRMS R12 Profile Option Internal Name AME:Installation Level AME_INSTALLATION_LEVEL AME:Installed AME_INSTALLED_FLAG Apply Assessment Competencies to Person HR_APPLY_COMPETENCIES_TO_PERSON Display Messages… Read More »List of Profile Options in Oracle HRMS R12