Davis Apps DBA

While Create Supplier the attribute 'Supplier type = Standard supplier' is disabled and can not be changed. Cause :  As part of the functional design for R12, only users who have access to  the function POS_HT_SP_EMP_SUPPLIER can create/update employee suppliers. By  default the creation/update of employee suppliers is disabled. Solution :  As part of the functional design for R12, only users who have access to the function POS_HT_SP_EMP_SUPPLIER can create/update employee suppliers. By default the creation/update of employee suppliers is disabled. The customer needs to implement a few setup steps to grant access to it. This can be done by either: 1. Include the function POS_HT_SP_EMP_SUPPLIER with the grant flag checked in the menu of the customized responsibility which the customer plans to have access to both standard and employee vendors. 2. Check the grant flag for the function POS_HT_SP_EMP_SUPPLIER in the menu POS_HT_SP_FULL...

Today I tried to compile an Invalid Object and faced the below. Issue :  SQL> ALTER PACKAGE OWAPUB.OWA_OPT_LOCK COMPILE BODY; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY OWAPUB.OWA_OPT_LOCK: LINE/COL ERROR -------- ----------------------------------------------------------------- 40/12    PL/SQL: Statement ignored 40/12    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 72/5     PL/SQL: Statement ignored 72/5     PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 102/6    PL/SQL: Statement ignored 102/6    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 144/6    PL/SQL: Statement ignored 144/6    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared SQL> Reason : In this case, the PLS-00201 error indicates that the referenced package (SYS.DBMS_SYS_SQL...