Skip to main content

Canceling Requisition Lines Using a Spreadsheet

Please Click the Link below to access the document.

Canceling Requisition Lines Using a Spreadsheet




Cancel Requisition Lines
Canceling Requisition Lines Using a Spreadsheet: Procedure
As an authorized procurement user you can cancel requisition lines in batches using a spreadsheet. For example, you can review requisition lines that have been inactive for a long period of time. If they are overdue for cancellation, you can update their status to free up reserved funds.
Follow these steps to cancel requisition lines using a spreadsheet:
  • Select and download requisition lines to a spreadsheet.
  • Review the lines in the spreadsheet and update their status to canceled.
  • Upload the spreadsheet to update the application.
Prerequisite
Before you can cancel requisition lines using a spreadsheet, you must install the Oracle ADF Desktop Integration client software on your computer. The add-in enables desktop integration with Microsoft Excel workbooks. Download the installation files from Navigator Tools Download Desktop Integrator Installer.
Select and Download Requisition Lines
Follow these steps to select and download requisition lines to a spreadsheet:
  1. Open the Cancel Requisition Lines in Spreadsheet task. (Navigator > Purchase Requisitions work area > Requisitions page > More Tasks drop-down list > Cancel Requisition Lines in Spreadsheet task).
Note: To see the task you must have the Cancel Requisition Line in Spreadsheet privilege. This privilege is not delivered with any standard reference roles. Authorized procurement users must be assigned the privilege.



 

  1. Click Create in Spreadsheet. All requisition lines matching the selection criteria are downloaded to an ADFdi spreadsheet. In addition, the lines downloaded include only those in Approved status, and not placed in any purchase order or transfer order.
Note: Externally managed requisitions, created using the Purchase Request web service, are not downloaded to the spreadsheet. They must be canceled using the web service.
  1. In the Opening CancelRequisitionLines.xlsx dialog, select Open with Microsoft Office Excel, then click OK.
  2. In the Connect dialog, click Yes.
  3. In the Oracle Fusion Applications Sign In dialog, enter your User ID and Password, and click Sign In.
Review the Lines and Update Their Status

Follow these steps to use the Cancel Requisition Lines spreadsheet to review the downloaded requisition lines and update their status:
  1. In the Cancel Requisition Lines spreadsheet, there are two tabs: Instructions and Cancel Lines. Click the Cancel Lines tab.
  2. In the Cancel Lines tab, the list of selection criteria used to download the rows of requisition lines is displayed.
    1. Review the lines in the spreadsheet and determine which to cancel.
    2. For each line in the spreadsheet you want to cancel, enter a Reason for the cancellation. For each Reason you enter, a triangle icon displays in the Mark for Cancellation column.
Upload the Spreadsheet to Update the Application



Follow these steps to upload the edited spreadsheet and update the application.
  1. In the Cancel Lines tab on the spreadsheet ribbon, click the Upload icon.
  2. The Status column for each row displays the processing status for the uploaded requisition line.
    1. Processed rows show the status: Row Updated Successfully. Click the Status Viewer icon on the spreadsheet ribbon. In the Status Viewer pane you can see the message: No Error.
    2. Rows with an upload error show the status: Update Failed. Click the Status Viewer icon on the spreadsheet ribbon. In the Status Viewer pane you can examine the error details.
You can work in small batches. Take action on a few rows and upload them. After successful processing, you can click the Download icon in the spreadsheet ribbon to download the updated lines. The same combination of selection criteria used to create the original spreadsheet are used to retrieve the lines. Any lines that were updated to Canceled status are removed from the results. When all processing is complete and you are done canceling lines, close the spreadsheet.
 



Comments

Popular posts from this blog

How To Change the Apps Password

The passwords of APPS and APPLSYS must be identical. So you just need to change APPLSYS password not APPS , by changing APPLSYS password , APPS password assumes the same value (i) Shutdown the Applications Tier services on each of the Nodes Database Tier Services must be up and running Any node where APPL_TOP , 8.0.6 and iAS ORACLE_HOME are present is part of the Application tier Any node where RDBMS ORACLE_HOME is present is part of the Database tier (ii) Then . issue the commands at the Unix command line similar to the following on any Node of Oracle Applications where the executable FNDCPASS is present in $FND_TOP/bin To change the APPLSYS password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password SYSTEM APPLSYS new_password Ex: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS CITRIX123 To change an Oracle user password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password ORACLE apps_database_user new_password Example FNDCPASS app...

How to Remove the Yellow Warning Bar in Release 11i

PURPOSE ------- Why do I get a Yellow Warning Bar connecting to Applications Rel 11i? How to Remove the Yellow Warning Bar in 11i? SCOPE & APPLICATION ------------------- Anyone using Oracle Applications Rel 11.5.x HOW TO REMOVE THE YELLOW WARNING BAR IN ORACLE APPLICATIONS REL 11.5.x ------------------------------ ------------------------------ ---------- If you are connecting to an Oracle Applications Rel 11.5.1 Instance and now see a Yellow Warning Bar in the bottom margin of your screens I What does the Yellow Warning Bar mean II Who does this affect? III Where are all the files located IV Why do I get it now, what changed? V How to remove it. I - What does the Yellow Warning Bar mean? Oracle Applications Rel 11.5.1 (11i) requires that its code run in a trusted mode, and uses JInitiator to run Java applets on a desktop client. If an applet is "trusted," however, Java will extend the privileges of the applet. The Yellow Warning Bar is a warning that you...

Oracle Fusion: Next-Generation Enterprise Applications

Oracle Fusion: Next-Generation Enterprise Applications Applications Unlimited is Oracle's commitment to continue providing enhancements to current JD Edwards EnterpriseOne, JD Edwards World, Oracle E-Business Suite, PeopleSoft, and Siebel product lines beyond the delivery of Oracle Fusion Applications. At the same time, with Oracle's extensive development resources, we are building Oracle Fusion Applications. These are being designed to unify best-of-business capabilities from all Oracle Applications in a complete suite delivered on Oracle's open technology. Only Oracle can offer you the scale of resources needed to extend the solutions you own today, while simultaneously evolving to the next generation of Oracle Fusion Applications. With Oracle's unique Applications Unlimited and Lifetime Support policy – customers will not be forced to upgrade to Fusion Applications, but can decide when and if they choose to upgrade. Application integration has never been easier. Le...