Tuesday, September 25, 2012

Custom Code to Read only for all resposibilities and able to sumbit Concurrent srequests

----(Added the Custom Code to read only the Responsiblity )-----------
    formname    VARCHAR2 (30);
   blockname   VARCHAR2 (30);
BEGIN
   IF event_name = 'WHEN-NEW-FORM-INSTANCE'
   THEN

      IF fnd_profile.VALUE ('USER_NAME') = 'XXXX'
      THEN
(CURRENT_FORM)||'..FMB NAME..'||GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME));

         IF GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME) NOT IN ( 'FNDRSRUN')
         THEN
('USER_NAME'));

            BEGIN

               COPY ('Entering app_form.query_only_mode.',
                     'global.frd_debug');
               COPY ('YES', 'PARAMETER.QUERY_ONLY');
               app_menu2.set_prop ('FILE.SAVE', enabled, property_off);
               app_menu2.set_prop ('FILE.ACCEPT', enabled, property_off);
               formname := NAME_IN ('system.current_form');
               blockname := GET_FORM_PROPERTY (formname, first_block);

               WHILE (blockname IS NOT NULL)
               LOOP
                  IF (GET_BLOCK_PROPERTY (blockname, base_table) IS NOT NULL
                     )
                  THEN

                     SET_BLOCK_PROPERTY (blockname,
                                         insert_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         update_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         delete_allowed,
                                         property_false
                                        );
                  END IF;

                  blockname := GET_BLOCK_PROPERTY (blockname, nextblock);
               END LOOP;

            END;
         END IF;
      END IF;
   END IF;
END event;
----(End Added the Custom Code to read only the Responsiblity )-----------

compile a form using frmcmp_batch.sh ORA-12154: TNS:could not resolve the connect identifier specified


When attempting to compile a form using frmcmp_batch.sh or frmcmp.sh

The following errors occurs

ORA-12154: TNS:could not resolve the connect identifier specified


Solution: 

Cause

The TNS_ADMIN set in the scrip frmcmp_batch.sh or frmcmp.sh is pointing to the wrong location.
When the script frmcmp.sh or frmcmp_batch.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin

See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
...
While it should be:
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN

...


Reference : 431324.1

Wednesday, September 12, 2012

How to transfer expenditure item from one project to another project






1.Create new job 12040900 with old job 12040387
2.while creating take the choose  correct customer 2308
3.update the billing
4.save ...
5.go to agrrement and funding 1204900 with customer 2308
6.go to budget and baselined.
7.run PRC: Update Project Summary Amounts now we can see in contract value in PSI
8.source projcet expenditure item window and sselect  rows
9.tools tranfer (transfer788)
10.PRC: Distribute Labor Costs
11.PRC: Distribute Supplier Cost Adjustments
12.PRC: Update Project Summary Amounts
13.now in project 12040900 the expenditure 42,348.06
14.PRC: One Step Interface Streamline Processes to GL with option XS: Interface Supplier Costs To GL

How to change the customer name for a project



1.how to change the customer name for a project;
case: once project created with a customer (wrong customer) ABC Sevices (2531) and invoice and revenues completed now client wants to change the customer to XYZ (2308)
Ans: we can do it  in two ways
Option 1:
in AR Customer-> Account Merge
with this we can merging the customers and the project which was in ABC now in XYZ and abc will be inactive
Option 2:
1. create new project with different number
2.transfer the expenditure items to new project from old(Material,Labour,Sub contract ,other overheads)
3.cancel the revenue and invoice and events from old jobs
4.create new invoice ,revenues
5.commitments has to create for new job
6.close old job