Friday, April 06, 2012

Troubleshooting : Purchasing Setup of Approval Hierarchies


Troubleshooting Details

Purchasing Setup of Approval Hierarchies

There are three methods to route documents for approval:.

·         Approval Hierarchies (uses position hierarchies)

·         Employee/Supervisor (uses employee/supervisor relationship)

·         AME - Approval Management Engine (for requisitions only)


The first two methods Approval and Employee/Supervisor pertain to all Purchasing document types, including requisitions. This document will not include information on the 3rd method, Approval Management Engine (AME) for requisition approval.

Additionally this note will only review approvals for single business groups. Refer to Note 726618.1 'Unable to Allow Approver to be seen Across Business Groups' for information about approvals across business groups.

This document will include the following sections:
  • Initial Setup: Basic setup you need to complete in order to use the Approvals functionality in Purchasing
  • Employee/Supervisor Relationships: A narrative explaining the employee/supervisor relationship and examples.
  • Position Hierarchy: A narrative explaining the position hierarchy and examples.
  • Approval Setup: Basic requirements for setting up both the Approval and Employee/Supervisor Relationship. If you want a quick reference with screenshots of the setup go directly to this section.

Initial Setup

- Enable the Approval Method

The Human Resources zone on the Financial Options form has an option called Use Approval Hierarchies. This option determines which type of hierarchy is used for the approval process. When checked, the Approval Hierarchy is used and when unchecked the Employee/Supervisor relationship is used.
Go to the Financial Options form

Navigation: PO Responsibility -> Setup -> Organizations -> Financial Options
a. Select or deselect ‘Use Approval Hierarchies’.
b. Save your work.

- Define Jobs / Positions

Use the Job window to create each of the job titles in your organization (for example: Buyer, Supply Base Engineer). If you are not using positions, you assign one or more employees to each job. If you are using positions, you assign one or more positions to each job, and later assign one or more employees to each position. 
Navigation if using shared HR: Purchasing Responsibility -> Setup -> Personnel -> Jobs
If using a full install of HR: Human Resources Responsibility -> Work Structures -> Jobs -> Description
Note: You assign authorization rules to jobs or positions based on your approval method. If you are using employee supervisor method the authorization rules are assigned to the jobs.

Use the Position window to create each of the positions in your organization. This step is required if you plan to use either security or position approval hierarchies.
Navigation if using shared HR: Purchasing Responsibility -> Setup -> Personnel -> Positions
If using a full install of HR: Human Resources Responsibility -> Work Structures -> Positions -> Description
Note: Refer to Representing Jobs and Positions, Oracle HRMS Enterprise and Workforce Management Guide for more information about setting up jobs or positions.

- Build Position Hierarchies

Use the Position Hierarchy window to build and administer your position hierarchies. There are two distinct uses for position hierarchies in Purchasing: Document approval routing and
Document security control. You can use a single position hierarchy for both purposes.
Navigation if using shared HR: Purchasing Responsibility -> Setup -> Personnel -> Position Hierarchy.
If using a full install of HR: Human Resources Responsibility -> Work Structures -> Position Hierarchy
Note: Refer to Representing Jobs and Positions, Oracle HRMS Enterprise and Workforce Management Guide.

- Security Hierarchies

Security Hierarchy is used to determine who can access the purchasing document. If you want to specify a Security Level of Hierarchy for any of your document types, you must first define all positions. 
Important: Even if you are using jobs (i.e. Employee/Supervisor relationship) to route documents, you must define positions before you can enable this Security Level)
The Security Hierarchy is selected from a list of values in the Control zone of the Purchasing Options form (Navigation: Purchasing Responsibility -> Setup -> Organizations -> Purchasing Options). Here, select a Security Hierarchy, which is a position hierarchy from the Position Hierarchy window. When the Security Level is set to Hierarchy for a document in the Document Controls window, this position hierarchy governs access security for that document.
The Security Hierarchy field will only be enabled when the Hierarchy option is selected for the Security Level on the Document Types form.

Employee/Supervisor Relationships 

This type of hierarchy is defined by the employee/supervisor relationship. The supervisor of an employee is defined on the Assignment region of the Employee form. If the purchase order entered by the employee exceeds the approval limits, the purchase order is forwarded onto the employees' supervisor, as defined on the Employee form.
To implement this form of approval routing, you need only to define jobs. The job will then serve as the tie to the approval group, and based on the approval limits from the Approval Group, the document will either be approved or forwarded to the Employees’ Supervisor. If no supervisor is able to be located and the job assigned to the employee does not have approval authority, then the approving employee must enter a forward-to person, or the Document will be returned to an Incomplete status and a notification will be sent to the approving employee, stating – ‘No Approver Found’.

Employee/Supervisor Relationship Setup Example

For this example Senior Manager is the manager of Junior Buyer and Group Manager is the manager of Senior Manager.
Employee
Is Managed by
Approval Limit
Junior Buyer
Senior Manager
50.00
Senior Buyer
Group Manager
100.00
Group Manager

Unlimited

Employee/Supervisor Example One:

The Forward Method is set to Hierarchy on the Document Type form.
a. Junior Buyer raises a purchase order that has a total value of 150.00.
b. The purchase order is then submitted for approval.
c. As Junior Buyer does not have a high enough approval limits, the purchase order is automatically forwarded to Senior Manager (because Senior Manager is Junior Buyer's supervisor as defined on the Employee form)
d. Senior Manager responds to the approval notification for this purchase order.
e. If Senior Manager selects "Approve", the purchase order is automatically forwarded on to the Group.Manager as Senior Manager does not have a high enough approval limit.
f. The purchase order appears in the notification screen for Group Manager where it can be approved or rejected.

Employee/Supervisor Example Two:

The Forward Method is changed to Direct.
a. Junior Buyer raises another purchase order with a total value of 150.00.
b. The purchase order is then submitted for approval.
c. As neither Junior Buyer or Senior Manager have a high enough approval limit, the purchase order is sent directly to Group Manager because Group Manager is Senior Manager's supervisor as defined on the Employee form and Senior Manager is Junior Buyer's supervisor.

Position Hierarchies

Position Hierarchies are hierarchies that have a position relationship. Purchasing utilizes positions as a roadmap to determine how and where documents will be routed once the approval process has been initiated. It is first necessary to have created all positions that are going to be used in the system. Once all positions have been created, it is necessary to build the position hierarchy.
Each position has approval limits, so when a purchase order exceeds the limits of the position, the purchase order is forwarded onto the next position in the Hierarchy.
The hierarchy for positions is defined on the Position Hierarchy form. Purchasing does not check for the primary checkbox on Position Hierarchy form. When this setup is complete or is changed, the Fill Employee Hierarchy concurrent program must be run for the new hierarchy to come into effect. You must set up Positions if you plan to use either security or approval hierarchies.

Position Hierarchy Setup Example

For the following two examples we will use the following Approval Hierarchy. The name of the hierarchy is "Buyer Approval Hierarchy".
Employee Position
Manager Position
Approval Limit
Junior Buyer
Senior Buyer
50.00
Senior Buyer
Chief Buyer
100.00
Chief Buyer

Unlimited


 

Approval Example One

On the Document Type form Forward Method is set to Hierarchy and Default Hierarchy is set to Buyer Approval Hierarchy.
a. Junior Buyer raises a purchase order that has a total value of 150.00.
b. The purchase order is then submitted for approval.
c. As Junior Buyer does not have a high enough approval limit, the purchase order is automatically forwarded to Senior Buyer because it is the next position in the hierarchy.
d. Senior Buyer responds to the approval notification for the purchase order.
e. If Senior Buyer selects "Approve", the purchase order is automatically forwarded to Chief Buyer because Senior Buyer does not have a high enough approval limit.
f. The purchase order notification appears in the notification screen for Chief Buyer where it can be approved or rejected.

Approval Example Two

On the Document Type form The Forward Method is changed to Direct and the Default Hierarchy remains unchanged.
a. Junior Buyer raises another purchase order with a total value of 150.00.
b. The purchase order is then submitted for approval.
c. As neither Junior Buyer nor Senior Buyer has a high enough approval limit, the purchase order is sent directly to Chief Buyer for approval.

Approval Setup

Document Types

Forwarding Method:

The forwarding method is set under document types. This field has two options that apply regardless as to whether you use an Approval Hierarchy or an Employee/Supervisor relationship.

Direct: the document will pass to the next position or supervisor in the hierarchy who has enough authority to approve the document.

Hierarchy: the document will pass to the next person in the hierarchy regardless as to whether that position or supervisor has enough approval authority to approve the document.

Navigation: Purchasing Responsibility -> Setup -> Purchasing -> Document Types
a. From the list of values choose the purchasing document you want to assign the forwarding method to.
b. In the field ‘Forward Method’ choose Hierarchy or Direct and save your work.

Default Hierarchy

In the screenshot above we additionally see the ‘Default Hierarchy’ set to Materials. When choosing the action of 'Approve' for a document, if a Forward-To person is not defined and the person taking action does not have sufficient approval authority, the default hierarchy is first searched by the employee attempting the approval.

The Default Hierarchy option will only appear on the Document Type form if the option Use Approval Hierarchies is selected as shown in the section Enable the Hierarchy Method above. The Default Hierarchy field has a list of values. This list is derived from the hierarchies created using the Position Hierarchy form which will be discussed under the Position Hierarchies section of this document.

The Default Hierarchy is the one that will be used by the approval process unless the person who submits the document for approval changes it in the Approval Modal form. But, the hierarchy can only be changed on the Approval Modal form if the attribute ‘Can Change Approval Hierarchy’ (additionally shown in the screenshot above) is checked on the Document Type form.

Note: it is imperative that the low-end users (those with little approval authority) be present in this default hierarchy so the next Forward-To approver can be found.

User Setup

Regardless if Approval (Position) or Employee/Supervisor hierarchies are used, there are some basic setups required for the approvers:

Step 1: Create the employee record:

Go to the People form

Navigation if HR is fully installed: HR Responsibility > People > Enter and Maintain.
Navigation if HR is shared: Purchasing Responsibility > Setup > Personnel > Employees
a. Either query the employee by name or if the employee record has not been entered, enter the required detail.
b. If e-mail notifications are to be sent then enter the users email address in the Email field in the Office Details tab.

c. Choose the Assignment button
d. Assign a Job if using Employee/Supervisor or Job and Position if using Approval Hierarchies.
Note: For information on creating jobs or positions see the Oracle Purchasing User’s Guide, section ‘Define Human Resource key Flexfields (Required)’.
e. If Employee/Supervisor is used the Supervisor must be assigned (unless this approver is the last approver in the hierarchy chain). Save your work.

Step 2: Create the User record:

Go to the Users form

Navigation: System Administrator -> Security -> User -> Define
a. If the user has already been entered then query the user in the User Name field. If the user has not been entered fill in the required information and link the human resources record in the Person field.
b. If e-mail notifications are to be sent ensure that the e-mail field is populated. This information will default from the e-mail address entered in the human resources record above.
c. Add the responsibilities needed for the user. Save your work.


Step 3: Setup the user as a Buyer:

Go to the Buyers form:

Navigation: Purchasing Responsibility -> Setup -> Personnel -> Buyers
a. Enter the Buyer name and Effective From date. Category and Ship-To are not required.
b. Save your work.

Note: If the user is an off-line approver it is not required to enter the user as a Buyer here.


Step 4: Run the Fill Employee Hierarchy process if using Approval Hierarchies:

Go to the Submit Requests form:

Navigation: Purchasing Responsibility -> Reports -> Run
a. Choose the Single Request ‘Fill Employee Hierarchy’.
b. Submit the request and make sure it completes successfully from View -> Requests.

Note: It is required to run this report if creating or making changes to the Position hierarchy. It is not required to run this report if using Employee/Supervisor hierarchy.

Approval Assignment:

Once the Approver’s position or job is assigned in the HR record it is necessary to assign the Approval Group for the document type.

Go to the Assign Approval Groups form:

Navigation: Purchasing Responsibility -> Setup -> Approvals -> Approval Assignments
a. From the list of values choose the position (Approval Hierarchies) or job (Employee/Supervisor).
b. Save your work.

There are 6 document types which can be assigned to approval groups, if necessary. It is also possible to assign multiple approval groups for document types if different approval limits are needed. In this example the same Approval Group is assigned to all document types.


Approval Groups:

Next it is necessary to set the rules for the Approval Groups.

Go to the Approval Groups form:

Navigation: Purchasing Responsibility -> Setup -> Approvals -> Approval Groups
a. From the list of values choose the Approval Group seen in the previous Approval Assignment form.
b. Assign at least one Document Total and one Account Range. Save your work.

In the screenshot below we see there is an unlimited Amount Limit and account range for approval. For more information on assigning approval rules see Note 1107338.1 ‘How to Verify that Document Charge Account and Approval Groups Setup is Valid in Order to Prevent no Approver Found’.

What articles, white papers, or manuals should I read for more information on Approval Hierarchies in Oracle Purchasing?

Note 293315.1 11.5.10 FAQ for Approvals Management (AME) Integration For iProcurement and Purchasing
Note 396808.1 Oracle Approvals Management Documentation Resources, Release 12
Note 395405.1 Oracle HRMS Documentation Resources, Release 12
Oracle Purchasing User's Guide, Release 11.5.x
Oracle Purchasing User's Guide, Release 12

How to Change Inventory Accouting Period status from Closed Not Summary to Closed


Applies to:
Oracle Cost Management - Version: 12.0.4 and later   [Release: 12 and later]
Information in this document applies to any platform.
CSTRPCRE
Symptoms

On : 12.0.4 version,
When attempting to close a period the following error was received and Inventory Accounting status changed to Closed not summary.

ERROR in CSTRPCRE module: Period Close Reconciliation Report
-----------------------
MSG-00000: Run to date is unspecified. Defaulting to 03-APR-10
MSG-00000: calling summarization package
MSG-02000: Failure in summarization package.
MSG-00999: 100: User-Defined Exception
MSG-00999: CSTRPCRE >X Wed Apr 21 14:3:41 2010
REP-0771: After Form trigger failed.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Inventory --> Accounting Close Cycle --> Inventory Accounting Periods
Cause

Period of March (prior period) needed to be summarized so April period could be closed.

The reason why the Period Close Reconciliation Report completes with error when the same is fired automatically during period close is that the period rec report has not yet run successfully for prior period(s) and the prior period(s) are still unsummarized. So you have to run the period reconciliation report for the first unsummarized period and then the second then the third in sequence.
Solution

1) Run the Period Close Reconciliation Report manually (separately) from Cost Responsibility. Navigate to Cost responsibility > Reports > Cost > Value. Select the Period Close Reconciliation Report and run the report for the accounting period to be summarized.

2) The reason why the Period Close Reconciliation Report completes with error when the same is fired automatically during period close is that the period rec report has not yet run successfully for prior
period(s) and the prior period(s) are still unsummarized. So the customer has to run the period reconciliation report for the first unsummarized period and then the second then the third in sequence.

By running the Period Close Recon Report in TEST to close the months with "Closed Not Summarized" periods - and closing the next open period, customer was able to close normally (no more errors).

3) The request is failing because there is no space left in the tablespace APPS_TS_SUMMARY.
Extend this tablespace APPS_TS_SUMMARY and re-run the process and verify if the issue is resolved

Diagnostic script for table space issue, output should not contain any errors.
References
NOTE:1218043.1 - Period Close Reconciliation Report MSG-00999: CSTRPCRE
NOTE:459669.1 - CSTRPCRE PERIOD CLOSE RECONCILIATION REPORT ERR MSG-02000 MSG-00999
NOTE:469856.1 - Running Certain Reports Fails With Error "APP-FND-01242" or Enter a value for Organization id parameter or Profile MFG_ORGANIZATION_ID
SUNBUG:4964512

Inventory Close Period Notes - Uncosted or Pending Transactions Diagnostic SQL


CLOSE PERIOD NOTES - DIAGNOSTIC SQL SCRIPTS

When closing a period, Oracle will run the following scripts to checks tables for outstanding transactions in tables. Run these scripts or view the Pending form documented in  to identify what tables may hold stuck transactions.

***********************************************************
select count(*) from mtl_material_transactions
where costed_flag in ('N','E') and acct_period_id = &acct_period_id;

select count(*) from mtl_material_transactions_temp
where acct_period_id = &acct_period_id;

select count(*) from mtl_transactions_interface
where acct_period_id = &acct_period_id;

select count(*) from WIP_COST_TXN_INTERFACE
where acct_period_id = &acct_period_id;

select count(*) from WIP_MOVE_TXN_INTERFACE
where acct_period_id = &acct_period_id;

Uncosted Transactions

Run the following script to identify uncosted rows / errors in the MTL_MATERIAL_TRANSACTIONS table:
select
count(costed_flag) total,
costed_flag cflag,
substr(error_code,1,40) Code,
substr(error_explanation,1,100) Explan
from
mtl_material_transactions
having costed_flag IN ('E','N')
group by
costed_flag, error_code, error_explanation;

A costed flag of "E" will indicate that a cost worker request has completed with ERROR or WARNING. Find the effected cost worker request and examine the contents of the log file for an error.

Problem 1

If the following error message appears in the Material Transaction
Cost Worker:
APP-00001 cannot find message name inv_no_update. Uncosted material transactions in mtl_material_transactions table with costed_flag = E.

The transactions are WIP component transactions that do not corresponding rows in the MTL_MATERIAL_TXN_ALLOCATIONS and/or WIP_PERIOD_BALANCES  tables.

If these rows are missing you will need to run one of the following two scripts depending on the type of job the client using in WIP.

Discrete Jobs c276916.sql
Repetitive Jobs cm325424.sql

@SEE Note.1080033.6 for these scripts.

The script will recreate the necessary rows in the tables. Then reset flags and rerun the cost manager. (See Problem 2)

Problem 2

The cost manager or cost worker did not finish processing  all the transactions. Use the following sql script to reset transaction flags. The next time the cost manager runs the stuck rows will be processed.

update mtl_material_transactions
set costed_flag = 'N',
transaction_group_id = NULL
where costed_flag = 'E' or costed_flag = 'N'

Pending Transactions

Problem 1: mtl_transactions_interface

The following select statement will allow you review the  error code and error explanation for the errored transactions. Some of these can be fixed via the form and others will need to be fixed via sql.
select
count(process_flag) total,
process_flag pflag,
substr(error_code,1,40) Code,
substr(error_explanation,1,65) Explan
from
mtl_transactions_interface
group by
process_flag, error_code, error_explanation;

Note: common error APP-5372: transaction processor error

For Release 10.7 and 11.0:
The Material Transaction worker processes transactions in batch (based on the number in INV/SETUP/TRANSACTIONS/INTERFACE MANAGERS). If any 1 of the transactions in the batch do not pass validation then the whole batch will error. The 1 transaction that errored will be a valid error the others will have APP-5372. Correct the errored transaction and updated all transctions with the update statement below:

This update statement will reset the flags so that the next time the Material Transaction manager run it will process the transactions.

Note: Do not update records that have a process flag of 9. Those records are sales orders which have not come thru our interface yet. OE uses our interface and temp tables until the order has been ship confirmed or pick released.

The flags can be reset to allow processing the next time the transaction\ worker run by executing the followint sql script:
update mtl_transactions_interface
set process_flag = 1,
lock_flag = 2,
transaction_mode = 3,
validation_required = 1,
error_code = NULL,
error_explanation = NULL
where process_flag IN (1,3);

Problem 2: mtl_material_transactions_temp

The following select statement will allow you review the error code and error explanation for the errored transactions. Some of these can be fixed via the form and others will need to be fixed via sql.
select
count(process_flag),
process_flag,
substr(error_code,1,40) Code,
substr(error_explanation,1,65) Explan
from
mtl_material_transactions_temp
group by
process_flag, error_code, error_explanation;

Note: common error APP-5372: transaction processor error

For Release 10.7 and 11: The Material Transaction worker processes transactions in batch (based on the number in INV/SETUP/TRANSACTIONS/INTERFACE MANAGERS) if any 1 of the transactions in the batch do not pass validation then the whole batch will error. The 1 transaction that errored will be a valid error the others will have APP-5372. Correct the errored transaction and updated all transctions with the below updated statement.

Note: common error APP-05075 transaction quantity cannot be zero

RMA's have been know to create these errored the following update statement will correct the transactions:
update mtl_material_transactions_temp
set primary_quantity = transaction_quantity
where transaction_quantity > 0 and process_flag <> '4';

Then run the update to reset the flags to reprocess the transactions.

This update statement will reset the flags so that the next time the Material Transaction manager run it will process the transactions.
Note: records with a process flag of 4 are OE transactions and should not be updated.
update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = 'N',
transaction_mode = 3,
error_code = NULL,
error_explanation = NULL
where process_flag in ('Y','E')

Problem 3: wip_cost_txn_interface

The following updated statement will reset flags for any WIP cost transactions that are stuck in the WIP Cost Interface.
update wip_cost_txn_interface
set group_id = NULL,
transaction_id = NULL,
process_status = 1;

Problem 4: wip_move_txn_interface

The following updated statement will reset flags for any WIP move transactions that are stuck in the WIP Move Interface.
update wip_move_txn_interface
set group_id = NULL,
transaction_id = NULL,
process_status = 1;

References
NOTE:102878.1 - Inventory Transactions Guide
NOTE:1080033.6 - Erred Transactions in MTL_MATERIAL_TRANSACTIONS INV_NO_UPDATE / CST_INVALID_WIP
Attached
276916SQL (2.83 KB)
325424SQL (3.21 KB)

How To : R12 Accounting, GL Transfer, Period Close and Trial Balance 'How To' documents


Create Accounting

1. What are the Subledger Accounting Setup and Usage FAQ's?

This Document includes FAQs Customers found when setting up SLA, and issues found when transferring to General Ledger due to product usage:
- How to Transfer Accounting to General Ledger in Release 12
- How to Import and Create accounting definitions
- How to Transfer Invoices with Rules to General Ledger
See Note 559064.1 for more information.

2. What are the FAQ's for the R12 SLA Pre-Upgrade Process?

1. What is the function of the R12 SLA (Subledger Accounting) Pre-Upgrade program?
2. When and how do I run the R12 SLA Pre-Upgrade program?
3. What table is updated by the R12 Pre-Upgrade program?
4. What are the different status codes in the GL_PERIOD STATUSES table?
5. What criterion does the R12 Pre-Upgrade Program follow?
6. Where can I find the documentation for the R12 Pre-Upgrade Program?
7. What are the Application IDs that are considered by the R12 Pre-Upgrade program?
8. Once I have run the Pre-Upgrade program, can I re-run it with a different set of dates?
9. Where can I find information on the GL_PERIOD_STATUSES table?
10. How do I upgrade the accounting transactions after I have completed the R12 Upgrade?
For answers to these questions and more information, see Note 604893.1.

3. How do you Run the Transaction Objects Diagnostics Program?

The Transaction Objects Diagnostics program basically depends on the Accounting Program for parameter values. Below are the steps to be followed to submit this program:
a. (N) System Administrator Responsibility>Profile>System
Set the Profile, SLA: Enable Diagnostics to Yes at user level.
b. (N) Payables Responsibility>Other>Requests>Run
Submit the Create Accounting program so as to pick some transactions or the problem transactions for accounting.
c. After the Create Accounting program completes, you can run the Transaction Objects Diagnostics program for the Invoice/Payment. Alternatively, you can run this program for the Accounting Program Request ID.
See Note 558196.1 for more information.

4. What are the differences from the Subledger Accounting Methods, Standard Accrual Method and China Standard Accrual?

1. The China Standard Accrual SLAM (JA_CN_STANDARD_ACCRUAL) only has Application Accounting definitions defined for the Payables and Loans applications.
2. The China Standard Accrual SLAM (JA_CN_STANDARD_ACCRUAL) supports Project Number supporting reference on journal lines/headers to meet China localization requirement.
See Note 602109.1 for more information.

5. How to Create A Manual Subledger Journal Entry

Manual entries are adjustments. If the adjustments are due to specific subledger activity such as Payables, then you may want to enter an SLA manual entry instead of a GL entry.
Entries recorded in SLA are tied to the subledger source and therefore provided more accurate subledger accounting reporting.
Enter account, debit, and credit amounts, and accounting class.
Optionally enter third party information, description, and currency details for each line of the subledger journal entry.
View the total accounted amounts of all subledger journal entry lines in the ledger currency.
Navigation: Accounting > Subledger Accounting > Journal Entries
There you can see Create Journal Entry button at the left side after the Advanced Search block.
See Note 452748.1 for more information.

6. How to Correct Invalid Accounts Reported by the Create Accounting Process in R12 Payables

The Update Accounting Entries form was available in earlier releases of R11i to allow update/correction of invalid accounts created by the Payables accounting process. The R11i Update Accounting Entries form is phased out in 11.5.10 and is not available in R12. In R11i version 11.5.10, accounting is not created with invalid accounts; instead the accounting is reported in error and rolled back. The users are required to fix the invalid account referenced in the transaction data at the transaction level. R12 has similar functionality, if an account is invalid, the accounting is created with a status = Invalid. When accounting is created with a status = Invalid due to invalid accounts, the user should correct the transaction data or rule referencing the invalid account and then run the Create Accounting process again. Accounting with status = Invalid and Draft can be recreated each time the Create Accounting process is run. You can modify transaction data and rules to correct and change the accounting until you see accounting status = Final.
See Note 459274.1 for more information.

7. How to Make the 'About This Page Link' or 'Errors Details Link' Available on R12 OAF Pages

To help diagnose errors in detail or see the About this Page information on an R12 OAF page, set the FND: Diagnostics profile to 'Yes' at the site level. The profile controls the display of the 'About this page' link. Setting the profile to 'Yes' also ensures that a detailed error stack can be viewed to help diagnose unhandled exceptions. When this is set to 'No', a simple error message asking the user to contact the System Administrator is shown; the detailed error stack is not accessible.
1. Navigate: System Administrator > Profiles > System
2. Query Profile Name = FND: Diagnostics and set it to 'Yes' at the site level.
3. Log out of the application and log back in.
4. Verify the 'About this Page' link is now available on R12 OAF pages.
5. Verify the 'errors detail' link is now available on R12 OAF page exception messages.
See Note 454759.1 for more information.

GL Transfer

1. SLA: How to Troubleshoot AP TO GL Reconciliation

The purpose of this AP-GL Reconciliation Troubleshooting Guide is to assist the reader with reconciliation issues. In the simplest terms, AP-GL reconciliation means tallying the amounts in Accounts Payable (i.e., AP) for a CCID/Supplier and reconciling it to the figures in the General Ledger (GL).
See Note 605707.1 for more information.

2. How to Setup Transfer to GL in Detail or Summary

Payables Manager responsibility has setup access to subledger options:
Setup #1
1) On the Navigator page, hit CTRL L to get list of forms
2) Select > Accounting Setup Manager Main Page
3) Find the ledger and click Go
4) Click Update Accounting Options
5) Scroll a little down to Primary Ledger heading section
6) Subledger Accounting Options click UPDATE
7) Click Next to find Payables
8) Click Update Accounting Options
9) General Ledger Journal Entry Summarization setup No Summarization
10) Click Apply when done
Setup #2
11) On the Navigator page, Setup > Accounting Setups > Accounting Methods Builder > Journal Entry Setups > Journal Line Type
12) Define how each line type will be transferred to the GL
13) Log out and back into applications
14) Test the Transfer to GL
See Note 564706.1 for more information.

Period Close

1. How to Run the Unaccounted Transactions Sweep Program

See Note 560378.1 for instructions on how to run the Unaccounted Transactions Sweep Program. The information presented is complementary to the Oracle Payables User's Guide Release 12, Part No. B25454-04.

2. How to Troubleshoot Closing Periods in Payables

A period cannot be closed unless the following criteria is met for ALL operating units assigned to a ledger:
•All payment batches must be confirmed
•All transactions must be accounted
•All accounting entries must be transferred to general ledger
•All future dated payments which have reached maturity in the accounting period must have their status updated to negotiable and be accounted
See Note 437422.1 for steps.

Trial Balance Report

1. How to Run the Accounts Payable Trial Balance Report in R12

Report Definition is required to run the Accounts Payable Trial Balance in R12.
If upgraded from R11i, Report Definitions should have been defined during the upgrade with the following name scheme: Liabilities Payables, i.e. Liabilities Payables, Vision Operations (USA)
If new install of R12, Navigate to: Payables Responsibility > Setup > Accounting Setups> Open Account Balances Listing Definitions
Review the Oracle Subledger Accounting Implementation Guide section on "Creating Open Account Balances Listing Definitions" for instructions on how to setup a new report definition.
See Note 554785.1 for more information.

2. How to Make the R12 Accounts Payable Trial Balance Report Show Detail or Summary Output

The R12 Accounts Payable Trial Balance has 4 templates available that control the output that is
displayed. The four templates available are:
Accounts Payable Trial Balance - Group by Account, Summary
Accounts Payable Trial Balance - Group by Account, Detail
Accounts Payable Trial Balance - Group by Third Party, Summary
Accounts Payable Trial Balance - Group by Third Party, Detail
Do the following to change the template that is used when the report is submitted:
1. Navigate: Payables Responsibility>Other>Request>Run
2. Select the Accounts Payable Trial Balance
3. Enter all of the parameters for the report. DO NOT SUBMIT THE REPORT.
4. Click on the Options button in the Upon Completion section of the Submit Request screen.
5. Select the desired template name.
6. Submit the Trial balance.
Do the following to change the default template used when the report is submitted:
1. Navigate: System Administration Responsibility>Concurrent>Programs
2. Search for:
Application = Payables
Program = Accounts Payable Trial Balance
Click on Go
3. Click on Update for the Accounts Payable Trial Balance program
4. Select the Onsite Setting tab
5. Select the default template from the Template dropdown in the General section.
6. Click on Apply to save the changes.
See Note 444044.1 for more information.

3. How to Have a Text Output for the Accounts Payable Trial Balance

In the Concurrent programs form for APTBRPT program check that 'Output Format' is XML.
In submit request form, select Output button in upon completion region, under layout region, choose a format like PDF or RTF.
For more information, see Note 554060.1.

4. How to Create R12 XML Report Output Formatted in Excel Instead of PDF

Do the following to change the Output Format that is created when the report is submitted:
1. Navigate: Payables Responsibility > Other > Request > Run
2. Select the report with XML output i.e. Payables Posted Invoice Register, Create Accounting Process, Accounts Payable Trial Balance, etc...
3. Enter all of the parameters for the report. DO NOT SUBMIT THE REPORT.
4. Click on the Options button in the Upon Completion section of the Submit Request screen.
5. Change the Format from PDF to Excel
6. Submit the report.
Note: XML reports should still be set to create XML output in the Concurrent Program Define form i.e. System Administrator > Concurrent > Program > Define > Set Output set to XML. And review Note 178133.1 "Setting up Word or Excel as a Viewer Option:" to make sure the Viewer Options and System Profile Options are set correctly to view Excel output.
See Note 568031.1 for more information.

5. How to Have a Text Output for the Accounts Payable Trial Balance

In the Concurrent programs form for APTBRPT program, ensure the 'Output Format' is XML.
In the submit request form, select the Output button in completion region, under layout region, choose a format like PDF or RTF.
See Note 554060.1 for more information.

6. How to Apply Journal Line Definitions Rules to the Manual Journal Entries

Is it possible to add the seeded Oracle Manual event class to an Application Accounting Definition? This would allow the users to define rules to be applied to manual journal entries in the subledger.
The answer is no. Manual SLA journal does not use rules. In R12, rules do not apply to manual journal entries in the subledger.
Whatever line type/account you enter, the system will take it and create an entry. The System will not consider rules for Manual Journal Entries.
See Note 452739.1 for more information.


ATTENTION: Oracle Payables Community Join our growing Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.


IMPORTANT

If you did not find the information you were searching for, please review the following Payables documents:
Note 578232.1 R12 Proactive Intelligence Center: Oracle Payables
Note 396084.1 Oracle Payables Documentation Resources, R12
Note 562887.1 R12 Helpful Tips for a Successful R12 Oracle Payables Implementation
Note 557869.1 EBS R12 Oracle Financials Critical Patches
Note 405627.1 Oracle Payables Release 12 Known Issues
Additional R12 documents:
Note 580299.1 R12 Best Practices for Adopting Oracle E-Business Suite
Note 461705.1 EBusiness R12 Upgrade Guide
Note 602615.1 How to Locate the Latest R12 Product-Specific Information using New MetaLink Features

References

NOTE:437422.1 - R12 Troubleshooting Period Close in Payables
NOTE:444044.1 - How do you make the R12 Accounts Payable Trial Balance Report show Detail or Summary output?
NOTE:452739.1 - R12: How to Apply Journal Line Definitions Rules to the Manual Journal Entries
NOTE:454759.1 - How to make the About this Page Link or Errors Details link available on R12 OAF pages
NOTE:458371.1 - R12: How to Get the R12 Trace and FND Debug File / FND Log for Payables Processes
NOTE:459274.1 - How do you correct invalid accounts reported by the Create Accounting process in R12 Payables?
NOTE:554060.1 - R12: How to Have a Text Output for the Accounts Payable Trial Balance
NOTE:554785.1 - How do you run the Accounts Payable Trial Balance report in R12?
NOTE:560378.1 - Unaccounted Transactions Sweep Program
NOTE:564706.1 - R12: How to Setup Transfer to GL in Detail or Summary
NOTE:568031.1 - How to Create R12 XML Report Output Formatted in Excel Instead of PDF
NOTE:605707.1 - SLA: A TECHNICAL PERSPECTIVE OF THE AP TO GL RECONCILIATION 


How to Re-Open a Closed Inventory Accounting Period

Applies to:

Oracle Cost Management - Version: 11.5.10.0 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
Scripts to Re-open an Inventory Accounting Period that has accidentally been closed.

Goal

If an Inventory Accounting Period has been closed prematurely by accident the following scripts can be used to re-open the accounting period if the corresponding GL period is open.  Re-Opening a closed period will allow transactions to be process for that period.
The re-opening of a closed period should not be used to back date transactions, the system allow back dated transactions but this may cause discrepancies between inventory and GL. Any discrepancies caused by back dated transactions are not supported by Oracle and would have to be resolved with a manual adjustment to the General Ledger.

Solution

DISCLAIMER: THE RE-OPENING OF A CLOSED INVENTORY PERIOD COULD POTENTIALLY CAUSE DATA CORRUPTION AND ANY DATA CORRUPTION CAUSED BY RE-OPENING A CLOSED INVENTORY PERIOD WILL BE THE RESPONSIBILITY OF THE CUSTOMER AND NO DATA FIX WILL BE PROVIDED FOR ANY DATA CORRUPTION THAT HAS BEEN CAUSED BY RE-OPENING A CLOSED PERIOD.
TEST THOROUGHLY ALL SCRIPTS ON A NON-PRODUCTION INSTANCE, FIRST BACKING UP ALL TABLE DATA PRIOR TO IMPLEMENTING IN PRODUCTION.
IF THERE IS CONCERN THAT RE-OPENING A CLOSED PERIOD MAY CAUSE DATA CORRUPTION PLEASE OPEN AN SR WITH ORACLE SUPPORT PRIOR TO RE-OPENING A CLOSED PERIOD.
-- A script to list all inventory periods for a specific organization
-- A script to reopen closed inventory accounting periods in 11.5.10
-- The script will reopen all inventory periods for the specified
-- Delete scripts to remove the rows created during the period close process to prevent duplicate rows
-- organization starting from the specified accounting period.
-- The organization_id can be obtained from the MTL_PARAMETERS table.
-- The acct_period_id can be obtained from the ORG_ACCT_PERIODS table. 
   
   
   
SELECT acct_period_id period, open_flag, period_name name, 
      period_start_date, schedule_close_date, period_close_date 
      FROM  org_acct_periods 
      WHERE organization_id = &org_id 
      order by 1,2;

UPDATE org_acct_periods
SET open_flag = 'Y',
period_close_date = NULL,
summarized_flag = 'N'
WHERE organization_id = &&org_id
AND acct_period_id >= &&acct_period_id;

DELETE mtl_period_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;

DELETE mtl_period_cg_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;

DELETE mtl_per_close_dtls
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;

DELETE cst_period_close_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id; 

commit