Home/Oracle E-Business Suite/Page 4
  1. Asked: August 12, 2020In:

    APP_SPECIAL

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    Hi, APP_SPECIAL Program unit (Package) is a part of APPCORE.pll library, so if you open APPCORE.pll or APPCORE2.pll on oracle form builder you will find the source code of APP_SPECIAL inside. Note: APPCORE2.pll is a duplicate of APPCORE.pll, however APPCORE2.pll is shared a cross custom.pll while APRead more

    Hi,

    APP_SPECIAL Program unit (Package) is a part of APPCORE.pll library, so if you open APPCORE.pll or APPCORE2.pll on oracle form builder you will find the source code of APP_SPECIAL inside.

    Note: APPCORE2.pll is a duplicate of APPCORE.pll, however APPCORE2.pll is shared a cross custom.pll while APPCORE.pll is referenced inside the standard forms itself. So whenever we want to use APPCORE inside custom.pll we have to use APPCORE2 not APPCORE

    Regards.

    See less
    • 0
  2. Asked: April 13, 2020In:

    How to delete concurrent program in oracle apps from front end ?

    Fat`hi Explorer

    Hi Maram, You can`t delete by the front end, but by the back end; The API call to delete Concurrent Program fnd_program.delete_program (l_prog_short_name, l_appl_full_name); The API call to delete Executable fnd_program.delete_executable (l_exec_short_name, l_appl_full_name);

    Hi Maram,

    You can`t delete by the front end, but by the back end;
    The API call to delete Concurrent Program

    fnd_program.delete_program (l_prog_short_name, l_appl_full_name);

    The API call to delete Executable

    fnd_program.delete_executable (l_exec_short_name, l_appl_full_name);

    See less
    • 0
  3. Asked: March 30, 2020In:

    What is FNDLOAD Commands to Download and Upload Concurrent Program ?

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    Hi @albert FNDLOAD to download concurrent program from the source instance: FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="INV" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM_SHORT_NAME" FNDLOAD to upload concurrent program to dRead more

    Hi albert FNDLOAD to download concurrent program from the source instance:

    FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="INV" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM_SHORT_NAME"

    FNDLOAD to upload concurrent program to destination instance:  

    FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

      Notes:

    • XX_CUSTOM_CP.ldt : LDT file generated from FNDLOAD command
    • APPLICATION_SHORT_NAME: concurrent program application short name
    • CONCURRENT_PROGRAM_NAME: concurrent program short name
    • If we migrate concurrent program all dependencies objects will be migrated as well like it’s executable, value sets, etc..

     

    See less
    • 0
  4. Asked: April 13, 2020In:

    Projects tables in oracle apps r12

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    Hi @KenDonald Most common used oracle projects tables & views are : 1.PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. 2.PA_TASKS stores user-defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks. 3.PA_PROJECT_TYPES ImplementaRead more

    Hi kenDonald

    Most common used oracle projects tables & views are :

    1.PA_PROJECTS_ALL
    stores the highest units of work defined in Oracle Projects.

    2.PA_TASKS
    stores user-defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks.

    3.PA_PROJECT_TYPES
    Implementation-defined project classifications that supply default information and drive some project processing.

    4.PA_PROJECT_PLAYERS
    A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

    5.PA_AGREEMENTS_ALL
    Customer contracts that serve as the basis for work authorization

    6.PA_BUDGET_VERSIONS
    stores the versions of project budgets. There are three categories of budget versions: Draft, Baselined, and Original.

    7.PA_BUDGET_LINES
    stores the detail information of a project or task budget, including the resource, time period and budget amounts entered. The time period may be PA period, GL period, or any user-defined period.

    8.PA_DRAFT_REVENUES_ALL
    Stores information about draft revenue generated for projects

    9.PA_DRAFT_REVENUE_ITEMS
    stores the lines of a draft revenue.

    10. PA_DRAFT_INVOICES_ALL
    Information about draft invoices generated for projects.

    11. PA_DRAFT_INVOICE_DETAILS_ALL
    Inter company invoice details for cross charged transactions.

    12. PA_CLASS_CATEGORIES
    Implementation-defined categories for classifying projects.

    13. PA_CLASS_CODES
    Implementation-defined values within class categories that can be used to classify projects.

    14. PA_EXPENDITURE_COST_RATES_ALL
    Cost rates for non-labor expenditure types

    15.PA_BILL_RATES_ALL
    Information about bill rates and markups of standard bill rate schedules.
     
    Note: this is not all the tables and views are available in oracle projects application, however this may help you to get a small insights about what are these tables ? and small description of each one.
     
    Regards. 

    See less
    • 0
  5. Asked: March 5, 2020In:

    Operating Units Merge

    Syed Mustafa Shah Explorer Oracle SCM, EAM & CRM (SFDC) Functional Consultant

    Dear Isa, I hope you are having single instance, even under single instance unfortunately this is not possible in oracle, if you want to merge the LE it's like re-implementation. I came across one of the company (eprentise) who claim they "offers software for merging LEs. The reorganization softwareRead more

    Dear Isa,

    I hope you are having single instance, even under single instance unfortunately this is not possible in oracle, if you want to merge the LE it’s like re-implementation.

    I came across one of the company (eprentise) who claim they “offers software for merging LEs. The reorganization software lets you move and merge Ledgers or Sets of Books, Operating Units,and Inventory Organizations. It takes care of all history and transactions in the subledgers.” (Sic)

    You can connect with them @ http://www.eprentise.com

    Best Regards,

    Syed Mustafa Shah

    See less
    • 0
  6. Asked: February 12, 2020In:

    Oracle Alert Error – APP-ALR-04150 –

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    Hello @mahendra try this code now : SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID ,PAA.ABSENCE_ATTENDANCE_TYPE_ID ,PAA.ABS_INFORMATION1 ,PAA.PERSON_ID ,PAPF.FULL_NAME FNA ,PAPF.EMAIL_ADDRESS EM ,PAA.REPLACEMENT_PERSON_ID ,PAPF1.FULL_NAME FNR ,PAA.AUTHORISING_PERSON_ID ,PAPF2.FULL_NAME FNAUT ,PAA.DATE_NORead more

    Hello mahendra try this code now :

    SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID
               ,PAA.ABSENCE_ATTENDANCE_TYPE_ID
               ,PAA.ABS_INFORMATION1
               ,PAA.PERSON_ID
               ,PAPF.FULL_NAME FNA
               ,PAPF.EMAIL_ADDRESS EM
               ,PAA.REPLACEMENT_PERSON_ID
               ,PAPF1.FULL_NAME FNR
               ,PAA.AUTHORISING_PERSON_ID
               ,PAPF2.FULL_NAME FNAUT
               ,PAA.DATE_NOTIFICATION
               ,PAA.DATE_START
               ,'\ \\\\\\for a period of \\\\\\\' || PAA.ABSENCE_DAYS || '\\\\\\\ days up to\\\\\\\'
               ,PAA.DATE_END
INTO   &ABSENCE_ATTENDANCE_ID
      ,&ABSENCE_ATTENDANCE_TYPE_ID
      ,&ABS_INFORMATION1
      ,&PERSON_ID
      ,&FULL_NAME
      ,&EMAIL_ADDRESS
      ,&REPLACEMENT_PERSON_ID
      ,&FULL_NAME
      ,&AUTHORISING_PERSON_ID
      ,&FULL_NAME
      ,&DATE_NOTIFICATION
      ,&DATE_START
      ,&ABSENCE_DAYS
      ,&DATE_END
FROM   PER_ABSENCE_ATTENDANCES PAA
      ,PER_ALL_PEOPLE_F PAPF
      ,PER_ALL_PEOPLE_F PAPF1
      ,PER_ALL_PEOPLE_F PAPF2
WHERE  1 = 1
AND    PAA.ABSENCE_ATTENDANCE_ID = 132128
AND    PAA.PERSON_ID = PAPF.PERSON_ID
AND    PAA.REPLACEMENT_PERSON_ID = PAPF1.PERSON_ID(+)
AND    PAA.AUTHORISING_PERSON_ID = PAPF2.PERSON_ID(+)
AND    TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE AND PAPF2.EFFECTIVE_END_DATE

    but in the next time you create a question could you please leave more details about what you are trying to do or the error text along with error code you face to be able to help you efficiently.

    See less
    • 0
  7. Asked: December 30, 2019In:

    How to find dbc file in oracle apps ?

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    Hello @chandra to find dbc file in release 11i $FND_TOP/secure and to find dbc file in release 12 $INST_TOP/appl/fnd/12.0.0/secure hope this help.

    Hello Chandra

    to find dbc file in release 11i

    $FND_TOP/secure

    and to find dbc file in release 12

    $INST_TOP/appl/fnd/12.0.0/secure

    hope this help.

    See less
    • 2
  8. Asked: February 9, 2019In:

    Error: You cannot deactivate an asset for which there are open work requests or service requests or work orders

    deepika Explorer
    This answer was edited.

    Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests -- Check for open Work Orders SELECT COUNT (1) FROM eam_work_orders_v WHERE ( wRead more

    Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests

    -- Check for open Work Orders
SELECT COUNT (1) FROM eam_work_orders_v
WHERE ( work_order_status NOT LIKE (‘%Cancelled%’)
AND work_order_status NOT LIKE (‘%Complete%’)
AND work_order_status NOT LIKE (‘%Close%’)
)
AND instance_number = asset_num

     

    -- Check for open Work Requests

SELECT COUNT (1)
FROM wip_eam_work_requests_v
WHERE ( work_request_status NOT LIKE (‘%Cancelled%’)
AND work_request_status NOT LIKE (‘%Complete%’)
AND work_request_status NOT LIKE (‘%Rejected%’)
)
AND asset_number = asset_num

     

    See less
    • 0
  9. Asked: May 16, 2019In:

    What are RICE components in the Oracle Apps ?

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    there is one article i wrote before taking about these terms and what is the difference between them ClICK HERE to read it.

    there is one article i wrote before taking about these terms and what is the difference between them ClICK HERE to read it.

    See less
    • 0
  10. Asked: July 15, 2019In:

    When creating a Work Request via the APIs am I able to set the CREATED_BY?

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    by default who columns as (CREATED_BY) is one of them is handled automatically from oracle by database triggers like HRMS and when you call any API's from sql*plus or sql developer. who columns are set also automatically by anonymous user. but still you can control of this behavior by calling fnd_glRead more

    by default who columns as (CREATED_BY) is one of them is handled automatically from oracle by database triggers like HRMS and when you call any API’s from sql*plus or sql developer. who columns are set also automatically by anonymous user.

    but still you can control of this behavior by calling

    fnd_global.apps_initialize

    before call your API. but keep in mind that it is your responsibility to pass in valid values, as incorrect values are not rejected.

    Regards.

    See less
    • 0