Read-only responsibilities in HRMS

This can be done by setting the Profile Option ‘Profile: HR:Query Only Mode’ to ‘Yes’. This will make forms/functions read-only. This works only for HRMS applications though.

WebAdi Links

Metalink Note#603169.1 -WebADI and Report Manager Webcasts for EBS 11i/R12 — Replay is Now Available

Metalink Note#360105.1 -Understanding and Using Web ADI in Oracle HRMS.

update on STATUS column on the GL_INTERFACE table

Problem Description

What are the possible values for the STATUS column on the GL_INTERFACE table?

Solution Description

There are several common codes -  'NEW', 'P', 'PROCESSED', and 'CORRECTED'.

There are also primary error codes listed at the end of the Journal Import

Execution Report.  See Note 1056801.6 for a list of the primary error codes

and step-by-step instructions on how to correct these Journal Import errors.

There is no list for all of the possible values of the STATUS column.

This is a text field and sub-ledgers are allowed to put any

value in the field other than 'PROCESSED'. Also, a line can have multiple

errors, and therefore multiple error codes in the STATUS column.

When data is loaded into the GL_INTERFACE table, STATUS must be 'NEW' in order

to be ready for Journal Import processing.   (For a complete description of how to load

this table, see the Oracle General Ledger User Guide.)

'P' indicates that Journal Import passed this line successfully but other

lines in the same transaction failed.

'PROCESSED' indicates that journal import passed the entire transaction

successfully and has created a journal for the transaction.

'CORRECTED' indicates that the line was in error and was corrected through

the Correct Journal Import form.

EBS R12 Period Close Advisor: Inventory & Costing

EBS R12 Period Close Advisor: Inventory & Costing [ID 1359452.1]

NOTE:733863.1 - Transaction Setup (Chapter 10: R12 Inventory User's Guide in a Note)

NOTE:748704.1 - How to resolve Pending or Erred Cost Manager or Cost Workers

NOTE:753741.1 - Oracle Inventory Basic Setup Labs E-Business Suite R12

NOTE:732235.1 - R12.0.6+ : Inventory Organization Data Collection Setup Test

NOTE:1222453.1 - Diagnostic Training for Oracle Cost Management Costing Transactions Setup Test

NOTE:726226.1 - INV/WMS/RCV Family Patch Release History / Patchsets / RUPs

NOTE:732336.1 - R12.0.6+ : Oracle Cost Management Costing Transactions Setup Test

NOTE:732454.1 - R12.0.6+ : Item Master Items Data Health Check Setup Test

NOTE:605395.1 - Index: R12 Inventory User's Guide in a Note

NOTE:1312579.1 - REDIRECT: Oracle EBS Items Product Information Center

NOTE:143004.1 - Inventory Close Period Notes - Uncosted or Pending Transactions Diagnostic SQL Scripts

NOTE:206576.1 - 11i : Oracle Inventory Period Closing Activity Test

NOTE:242927.1 - 11i/R12 - Resolving Period Close Pending Transaction

NOTE:291005.1 - Costing Reports and Reconciliation

NOTE:105328.1 - Oracle Work in Process White Papers

NOTE:1055597.1 - Table of Contents For The Oracle Work In Process User's Guide, Release 12.1 (Part No. E13678-03)

NOTE:105647.1 - WIP and COST Frequently Used Troubleshooting Scripts

NOTE:1069492.1 - Resolving Period Close Pending Transaction R12

NOTE:1264685.1 - Information Center: Oracle Work In Process (WIP)

NOTE:1266644.1 - R12 Period-End Process Flow For Oracle Discrete Manufacturing - e-Business Suite

NOTE:1271813.1 - R12 Oracle Cost Management Diagnostic Scripts within E-Business suite Application

NOTE:1237963.1 - Release 12 Inventory Period-End Process Flow For Oracle Process Manufacturing - e-Business Suite

NOTE:1262392.1 - Information Center: Manufacturing Period Close

NOTE:801794.1 - Manufacturing Transaction Diagnostics - FUNCTIONAL USER SQL INVESTIGATION and REPAIR

NOTE:802966.1 - SLA Data Flow and Table Links

NOTE:857001.1 - How To Create A Wip Job And Associated Setups

NOTE:295182.1 - Period Close Reconciliation Report (CSTRPCRE)

NOTE:860522.1 - Recommended and High Priority Patches for Oracle Process Manufacturing (OPM) Release 12.1

NOTE:1099958.1 - Diagnosing Pending WIP Move Transactions

NOTE:110424.1 - FAQ: Unprocessed Transactions / Closing Inventory Accounting Period

NOTE:1141334.1 - Pending Move Transactions FAQ

NOTE:378348.1 - Data Collection Scripts for Cost Management

NOTE:414470.1 - How To Determine the Product Information Management (PIM) Patchset and Rollup Patch Version

NOTE:335.1 - Period Close Advisor: E-Business Suite (EBS)

NOTE:732479.1 - Oracle Cost Management To Check Uncosted Transactions At Period End Transaction Data Test

NOTE:333572.1 - Diagnosing WIP Related Transaction and Data Issues

NOTE:865438.1 - How to resolve Costing Errors & Problems

NOTE:961285.1 - R12: Period-End Procedures for Oracle Financials E-Business Suite

NOTE:986473.1 - Critical and Recommended Patches on Release 12.0.x for Work in Process - WIP

NOTE:76440.1 - Inventory Organization Setup Steps

NOTE:1203809.1 - Information Center: Oracle Cost Management

NOTE:1222123.1 - Rel 12: Oracle Inventory Period Close Activity Test [VIDEO]

NOTE:472631.1 - Re-Open a Closed Inventory Accounting Period

NOTE:568012.1 - FAQ: Inventory Standard Datafixes

NOTE:601639.1 - Generic Receiving Datafix Scripts and Root Cause Patches

NOTE:304313.1 - Understanding Cost Manager

EBS R12 Period Close Advisor: Order Management and Shipping

EBS R12 Period Close Advisor: Order Management and Shipping [ID 1359451.1]

NOTE:1273931.1 - Information Center: Oracle Order Management

NOTE:751026.1 - FNDWFPR - Purge Obsolete Workflow Runtime Data - OEOH / OEOL Performance issues

NOTE:863454.1 - Detailed Functional Flow of Customer Acceptance feature in Release 12

NOTE:1400757.1 - How to Find E-Business Suite Recommended Patches

NOTE:255045.1 - bde_wf_err.sql - Profile of Workflow Activities in Error

NOTE:1331647.1 - How to run the Period Close Pending Transactions Report in R12

NOTE:262979.1 - Unprocessed Shipping Transactions Troubleshooting Techniques

NOTE:878032.1 - How To Use Concurrent Program "Purge Order Management Workflow"

NOTE:961285.1 - R12: Period-End Procedures for Oracle Financials E-Business Suite

NOTE:290432.1 - How to Create a Debug File in Shipping Execution

NOTE:335.1 - Period Close Advisor: E-Business Suite (EBS)

NOTE:398822.1 - Order Management Suite - Some Data Fix Patches and Scripts

NOTE:1069492.1 - Resolving Period Close Pending Transaction R12

NOTE:458665.1 - How To Troubleshoot When Email Notification Responses Are Processed But The Approval Workflow Still Shows In Process

NOTE:1083807.1 - Diagnostic Test Catalog for 12.1.3

NOTE:739401.1 - R12 Diagnostics APPS CHECK Report: OMCHECK.sql OMCHECK.sql