Home/Oracle E-Business Suite/Page 5
  1. Asked: January 12, 2018In:

    It’s possible to call an oracle API from custom schema ?

    PaulG Explorer

    You would have to grant the appropriate permissions to your custom schema.

    You would have to grant the appropriate permissions to your custom schema.

    See less
    • 0
  2. Asked: October 20, 2018In:

    How to open custom.pll in form builder?

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

    Hello Alan, It's so simple as you open regular form .fmb in form builder just follow this: First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server). You can find the path of CUSTOM.pll under ($AU_TOP/resources) foldRead more

    Hello Alan,

    It’s so simple as you open regular form .fmb in form builder just follow this:

    1. First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server).
    2. You can find the path of CUSTOM.pll under ($AU_TOP/resources) folder
    3. Open Oracle Form Builder
    4. Click File menu ==> Open ==> choose CUSTOM.pll from your local machine
    5. After opening CUSTOM.pll into your form builder you can modify (CUSTOM) Package as per your requirements.
    See less
    • 0
  3. Asked: February 21, 2019In:

    How to open gl period in oracle apps ?

    Tariq

    General Ledger -> Setup -> Open/Close -> Find -> Open Period

    General Ledger -> Setup -> Open/Close -> Find -> Open Period

    See less
    • 1
  4. Asked: March 15, 2019In:

    Document of Record

    atulghuleg

    Document of Record (DOR) Overview Oracle introduced documents of record in R12 HRMS RUP 1. The Documents of Record offers greater functionality than the attachments functionality, The standard attachment functionality does not allow users to search document which is major highlight of DOR. DocumentsRead more

    Document of Record (DOR)

    Overview

    Oracle introduced documents of record in R12 HRMS RUP 1. The Documents of Record offers greater functionality than the attachments functionality, The standard attachment functionality does not allow users to search document which is major highlight of DOR. Documents of Record (Oracle EBS R12) allows the user to create new, update existing, view and search ‘Documents of Record’ for a person. The prominent features of this functionality are as below

    • An Employee can maintain the Document (Resume, Contract, Visa, Passport, Birth Certificate etc..) through Employee Self Service
    • Manager can also maintain DOR for subordinates using Self Service
    • HR can maintain DOR for all Employees – Search in mass or Upload for one person
    • Search by document category, subcategory, documents of record, expires after, expiration before, or verification status
    • Complex approvals can be set using AME or Supervisor verification of documents can be setup
    • Security can be maintained at responsibility level by information types security
    • Certain Document Types e.g. ‘Resume’ or ‘Contract’ can be restricted at responsibility level
    • Allow to store extra information and add Descriptive FlexFields

    DOR Search page
    DOR Search page

    DOR Create Page

    Now Click ‘Create Document of Record’ Button,

    Create Document of Record
    Create Document of Record

    Functional Setup

    Enable ‘Register the Program’

    Navigation: System Administrator>>Security>>Responsibility>>Request Add ‘Register Extra Information Type (EITs)’ in Request Group

    Request Group
    Request Group

    Create Category

    Query DOCUMENT_CATEGORY (F11, CtrlF11)
    Add a Code: HR_INFO
    Add Meaning: HR Information
    Save

    Create Category
    Create Category

    Create Sub Category

    Navigation: Other Definitions > User Types and Statuses

    Query DOCUMENT_CATEGORY (F11, CtrlF11)
    In the “System Type” field, Query the new CATEGORY using the LOV
    Enter SUBCATEGORY by populating “Description” and “Code” fields
    System Type: Passport Information
    Description: Enter desired Subcategory

    Create Sub Category
    Create Sub Category

    Create Sub Category

    Register Document Types (EITs)

    Navigation: UAE HRMS Manager>> Processes and Reports > Submit Processes and Reports > Register Document Types (EITs)

    Enter the parameters as below,

    Register Document Types (EITs)
    Register Document Types (EITs)

    Submit the request.

    Add Information Type Security

    Navigation: Security > Information Types Security

    Search for responsibility and add Information type, Document Type will be your information type, Using EIT security model any Document type can be restricted to any particular responsibility.

    Information Types Security
    Information Types Security

    Enable AME in DOR Function

    System Administrator>>Application>>Function>>Form

    Form Function

    Create a function as ‘XX_HR_DOR_SS’ set function parameter on Form tab, Please note Parameter used will enable AME in DOR page which will allow you to setup complex approval on the other hand it will disable Supervisor Verification feature,

    Add DOR in Employee Self Service Menu

    System Administrator>>Application>>Function

    Search for Employee Self Service Menu , Add ‘XX_HR_DOR_SS’, Clear the cache or preferably bounce Apache and check DOR functionality from respective User login.

    Function XX_HR_DOR_SS
    User Function Name XX Documents of Record
    Description Documents of Record for a person
    Type SSWA jsp function
    Parameter pItemType=HRSSA&pAMETranType=SSHRMS&pAMEAppId=800&pProcessName=PER_DOR_JSP_PRC&pFromMenu=Y&pApprovalMode=YD&OAFunc=HR_DOR_SS&pCalledFrom=TDIC_HR_DOR_SS
    Web HTML OA.jsp?page=/oracle/apps/per/dor/webui/DocsOfRecordForPersonPG&akRegionApplicationId=800

    Source : here

    See less
    • 0
  5. Asked: February 16, 2019In:

    Why fnd_global.conc_request_id returns -1 ?

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

    hello Alan The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.

    hello Alan

    The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.

    See less
    • 1
  6. Asked: October 8, 2018In:

    How to SKIP or RETRY an oracle workflow by API from database ?

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

    Hi Saly, this script to RETRY workflow from the backend BEGIN wf_engine.handleerror ( itemtype => ‘APINVAPR’, itemkey => 5211111_1, activity => ‘ESCALATE_DOC_APPROVAL’, command => ‘RETRY’, RESULT => NULL ); COMMIT; END; and here you can find the script for the SKIP workflow BEGIN wf_eRead more

    Hi Saly,

    this script to RETRY workflow from the backend

    BEGIN
wf_engine.handleerror
(
itemtype => ‘APINVAPR’,
itemkey => 5211111_1,
activity => ‘ESCALATE_DOC_APPROVAL’,
command => ‘RETRY’,
RESULT => NULL
);
COMMIT;
END;

    and here you can find the script for the SKIP workflow

    BEGIN
wf_engine.handleerror
(
itemtype => ‘APINVAPR’,
itemkey => 5211111_2,
activity => ‘ESCALATE_DOC_APPROVAL’,
command => ‘SKIP’,
RESULT => NULL
);
COMMIT;
END;

    Note :

    itemtype: this is the item type of the workflow

    itemkey: this is a unique key you give to workflow

    activity: is the point for the activity internal name which you need to retry or skip.

    See less
    • 1
  7. Asked: October 27, 2018In:

    How to create event alert in oracle apps ?

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

    Hi Olivier, you can find here step by step how to create event alert in oracle apps R12 hope this helpful, Hassan AbdElrahman

    Hi Olivier,

    you can find here step by step how to create event alert in oracle apps R12

    hope this helpful,

    Hassan AbdElrahman

    See less
    • 0
  8. Asked: November 19, 2018In:

    looking for sample md 50 document in oracle apps?

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

    Hello Aya, you can find this article to download sample of AIM documents such as md 050 , md 070, etc.. CLICK HERE : >> AIM Documents (MD50, MD70 and MD120) Templates – Download now

    Hello Aya,

    you can find this article to download sample of AIM documents such as md 050 , md 070, etc..

    CLICK HERE : >> AIM Documents (MD50, MD70 and MD120) Templates – Download now

    See less
    • 0
  9. Asked: October 9, 2018In:

    Error APP-OFA-47227 ‘You must set up the category with default depreciation rules for at least one date range’ When Define a new Assets Category

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

    Hello PraveenM, this error came because there is a setup of default rule was missing when you want to create new asset category. just follow this steps to complete your setup required: Navigate to Responsibility FA manager > Setup > Asset System > Category Ensure that, at the bottom of theRead more

    Hello PraveenM,

    this error came because there is a setup of default rule was missing when you want to create new asset category.

    just follow this steps to complete your setup required:

    Navigate to Responsibility FA manager > Setup > Asset System > Category

    Ensure that, at the bottom of the page, there is a Default rules button.

    Enter the mandatory information in the second page for Default rules and Save.

    Once the category book is defined with the default rules and saved, there should be no error.

    See less
    • 0
  10. Asked: October 31, 2017In:

    how can i get PO Revision History details – oracle EBS R12?

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

    Hello Chandra, First thing the revision tables is: po_headers_all, po_headers_archive_all, po_lines_archive_all, po_line_locations_archive_all and po_distributions_archive_all Note: How the Purchasing Archive tables are updated when using Archive on Approve method for archiving (To setup Archive onRead more

    Hello Chandra, First thing the revision tables is:

    po_headers_all, po_headers_archive_all, po_lines_archive_all, po_line_locations_archive_all and po_distributions_archive_all

    Note: How the Purchasing Archive tables are updated when using Archive on Approve method for archiving (To setup Archive on Approve go to Setup -> Purchasing -> Document Types) and here an example to understand and to get the revision’s of PO 1- We created new PO, sent it for approval 2- PO Approved Now run this query :

    SELECT po_header_id, segment1, revision_num 
FROM po_headers_all 
WHERE po_header_id = &p_po_header_id

    which is (&p_po_header_id) is ID for po has been created above. and here is the result expected:

    PO_HEADER_ID SEGMENT1 REVISION_NUM
    24678 3103 0

    3- Now add a new line in PO, then sent it for reapproval. 4- PO Approved Now run this query

    SELECT po_header_id, segment1, revision_num 
FROM po_headers_archive_all 
WHERE po_header_id = &p_po_header_id
    PO_HEADER_ID SEGMENT1 REVISION_NUM
    24678 3103 0
    24678 3103 1

    So now from archive table you can get all revisions for particular PO.  

    See less
    • 2