[PO] R12 Purchasing Options
Setup -> Organizations -> Purchasing Options
In R11i, it is devided into 5 sections, "Receipt Accounting", "Control", "Default", "Internal Requisition", "Numbering" and "Tax Defaults".
In R12, (this form was converted to JSP format), only 4 sections available (some of the fields been merged), "Document Control", "Document Defaults ", "Receipt Accounting" and "Document Numbering".
New fields in R12:
Document Control
Security Hierarchy
Maximum Attachment Size
Email Attachment Filename
Enforce Supplier Hold 
RFQ Required (from "Default" tab in R11i)
Document Defaults
Internal Requisition Order Type (from "Internal Requisition" tab in R11i)
Internal Requisition Order Source (from "Internal Requisition" tab in R11i)
Tax Defaults was removed from Purchasing Options. Need to confirm if it has been permanently removed or moved to other form.
[PO] PR that Uses Currency Other Than Functional Currency
When you are creating a PR, functional currency is always defaulted at the header level. Price at the "Line" tab will always show functional currency as well. If you need to key in your currency using other currency, go " Currency" tab, under "Foreign Currency", "Price"
field, enter you price in foreign currency you specified. The
conversion will be done automatically (provide you have the exchange
rate defined).
At table level, PO_REQUISITION_LINES_ALL table has the following price and currency fields:
UNIT_PRICE - price in functional currency
CURRENCY_CODE - foreign currency code (if applicable)
RATE - foreign currency exchange rate (if applicable)
CURRENCY_UNIT_PRICE - price in foreign currency (if applicable)
[PO] Purchase Requisition (PR) - Owner Can Approver
If preparer's position is not setup in Default Hierarchy for a document type, can he still approve the document by himself if the Owner Can Approvercheckbox is checked (sufficient rights given)?
Yes, but he needs to check the Forward checkbox during approval process, and specify the hierarchy name (Can leave the Forward-to person field blank).
[PO] Cancel Requisition When Cancel PO
When you setup your Purchasing Option, Cancel Requisitions to Optionally, you can see a checkbox for "Cancel Requisitions " displayed at your Control Document form (Tool -> Control -> Cancel) during your PO cancellation process.
If you check it, Requisition amount will be updated to zero, status remains "Approved". No further action can be taken.
If you uncheck it, you still can perform amendment on the PR once PR has been returned to preparer.
[PO] Organization Field at PR Form was Disabled
My PR was rejected due to wrong ship-to-organization. I query my PR from Requisitions -> Requisitions, the Organization field was disabled. How can i make amendment from there?
Ans: Double check you Charge Account at Distributions screen, clear the charge account and go back to the main screen and you should be able to see the Organization field enabled.
[PO] Receving for a Future Date
Is it possible? No, Oracle allows Receipt Date to be on or before current date, not future date. You will see this error: APP-PO-14882: Please enter a transaction date that is not in the future.
Remarks: Oracle check time as well, you cannot enter a future time on today's date.
[PO] Advance Shipment Notice (ASN) - Completed Error
Supplier created ASN at I-Supplier portal, Processing Status for that ASN shows Error. Where can i troubleshoot?
I tried from front end: Transaction Open Interface, Transaction Status Summary and even Pending Transactions. No way i can find the error record.
Back end:
SELECT * FROM apps.rcv_shipment_headers WHERE shipment_num='ASN_Number'
AND asn_type='ASN';
AND asn_type='ASN';
Result: No record
SELECT * FROM apps.rcv_headers_interface WHERE shipment_num='ASN_Number';
Result: 1 record returned
Double check apps.rcv_transactions_
[PO] Rename Hierarchy, What Will be Affected?
PR or PO that were "In Process"
will not be affected, as the approval list has been created since PR/PO
submitted for approval. If the renamed hierarchy is the default
hierarchy for certain document type, it will get updated "automatically"
as Oracle uses internal structure id to identify default hierarchy.
Even name has been changed, structure id remain the same.
In short, there is no major impacts for hierarchy rename.
[PO] A Faster Way to Check Approval Assignment
The faster way, just paste the position directly into the " Position" field, press TAB, the existing assignment will displayed. It saves me 1 second for each try.
[PO] Disable a Category
There is a "Enable"
check box on the form. But you are not allowed to change, even there
are no pending PR or PO that uses that category. The only way you can do
it is to set the " Inactive On" to today's date. You are not allowed to back date, means entering the date before current date. Once you enter the "Inactive On" to today's date, user will not able to select this category with immediate effect.
What about PR / PO that was created before hand? Any impact?
The answer is NO. The deactivation will affects only new PR / PO.
[PO] Change a Category Name
You are allowed to raname existing Category Name.
Will the new name be reflected in existing PR / PO? Yes, because the PR / PO table carries only the category id, not the category name.
[PO] No Notification
PR
was submitted for approval to person A. Person A has all the employee
assignment correct and has a valid Oracle ID. Why didn't he see the
notification in Notification Summary?
I checked in Workflow Administrator, everything seems ok. Notification was sent to him. But he still could not see. Why?
Solution: At Users form, remove the person, Save, enter the person (employee) again, Save. Submit concurrent program "Synchronize WF LOCAL tables "from System Administrator responsibility.
[PO] View Action History
In Purchasing Super User responsibilities, we can forward "In Process" PR/PO to new approver (Management -> Forward Documents). Forward action will be captured in "View Action History".
As for Purchase Order, forwarder's name (in this case, it might be IT personnel's name) will be captured in "View Action History". However, for Purchase Requisition, forwarder's name will NOT be shown.
[PO] Segment Validation in Account Range
I have a account range setup in one Approval Group for an approver, e.g.
33-00-000-00-811111-000-00000 to 40-99-999-99-899999-999-99999 $10,000
33-00-000-00-811111-000-00000 to 40-99-999-99-899999-999-99999 $10,000
My PR charge account is 34-10-240-00-811110-000-00000,
Oracle
checks each segment and not by combination range. E.g. Even 34 fall
between 33 and 40, but 811110 failed. The whole validation will fail.
[PO] Consumption Advice Order Date
Where will "15 Jan" get updated? Ans: Need By Date.
[PO] Delete a Saved Purchase Requisition Line
[PO] PR Status Not Changed After Submitted for Approval
What could be the problem and what else to check?
Checked the Notifications tab in Workflow Status Monitor (under Workflow Administrator responsibility). It shows error in our customized trigger onpo_requisition_headers_all table. That's the root cause. Fixed the trigger logic and issue resolved.
[PO] APP-PO-14180: The forward-to person is not an on-line user
[PO] Profile Option for PO Auto Create
I was searching any available profile option for PO Auto Create. Found a good article on FAQ: Autocreate Purchase Orders (Note: 223919.1) on Oracle Support.
These are the only 2 profile options mentioned.
PO: Use Need-by Date for Default Autocreate Grouping
PO: Use Ship-to for Default Autocreate grouping
Note: The later one was mentioned incorrectly in that article.
[PO] POI_Temp_PO_b679535
PODI API PO_DOCS_INTERFACE_SV5.process_po_headers_interface is used
to create PO. What is "POI_Temp_PO_b679535" has to do with
process_po_headers_interface?
SEGMENT1
field was temporary updated with "POI_Temp_PO_b679535" string after the
api call. This is hard coded in Oracle API. Actual PO number will be
updated into SEGMENT1 once the whole process completed.
[PO] Price Column at Purchase Order Lines and Requisition Lines
I have a PR, entered in foreign currency, e.g. JPY. My functional currency is USD. The PR was converted to PO successfully.
In standard view, at PR lines, there is a Price column. At PO lines, there is also a Price column. PR line's price column will show price in functional currency (e.g. USD), PO line's price column will show price in foreign currency that i entered (e.g. JPY).
[PO] Vacation Rules
You
are a busy PR approver and plan to go vacation the following week. You
do not have chance to approve PR during your absence. What you can do is
to setup a Vacation Rulues so that you can delegate
the task to your backup person. Your backup person will approve/reject
on your behalf. Once the backup person performed the action,
notification will flow as per original path.
Note that you can set the Start Date and End Date of your rule, and you can specify time as well.
[PO] R12: Sales Order Reference in PR Interface Table
Drop Shipment, a booked Sales Order will trigger interface records into PO_REQUISITIONS_INTERFACE_ALL table.
How to trace back the original SO number from this table?
Get GROUP_CODE, which is reference back to the Sales Order header_id.
How to trace back the original SO number from this table?
Get GROUP_CODE, which is reference back to the Sales Order header_id.
[PO] What Are The Steps Required To Setup An Internal Requisition In Purchasing?
Excellant note. A simple and easy-to-understanding guide from Oracle Support, Note:406312.1.
A quick glance and I leant something new, Receiving for IR can be automated if we set the Receipt Routing to "Direct" in Shipping Networks .
[PO] Position Hierarchy Used for PR/PO Approval
A
PR/PO was submitted for approval, how to check which Position Hierarchy
user used? From Apps front end, it is impossible. Check it out from
backend tables.
Sample codes:
SELECT
approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT
requisition_header_id FROM apps.PO_REQUISITION_HEADERS_
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
Create a new position, leave the Status field blank, save. Oracle considers it as Valid or Invalid. Ans: Valid
Both values are default from the Employee setup. In Purchasing responsibility, navigate Setup -> Personnel -> Employees, click "More ..." button, move to "Assignment" tab, enter it at Location field.
You were trying to do Receiving. Once you navigate out of the Receipt Header form, the above message prompted. You have to open Purchasing Periodsunder Setup -> Control Purchasing Periods.
Yes. But in the Approval Assignment, you can only assign Blanket Purchase Agreement document type to that particular Approval Group. If you intend to assign other document type, e.g. Standard Purchase Order, you need at least another rule setup in Approval Group, which is Account Range.
Make sure item is purchasable in the selected inventory organization.
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
[PO] Receiving for PO with Status "Requires Reapproval"
Standard Purchase Order with 3 lines. I changed line 1 quantity. Header status changed to "Requires Reapproval". In normal scenario, I cannot do anymore Receiving activity as the status is not Approved.
If my changes involved price and currency, receiving activity will
generate accounting entries with wrong amount. A control is needed.
However, for a particular PO, I am able to perform receiving. The PO with "Requires Reapproval"
appeared in the LOV when i tried to perform receiving. I can proceed
further to next screen. However, the line i changed (line 1) is not
appearing. Only the lines that i did not change appeared and allow me to
do receiving. Why?
The reason being the PO is an consigned PO, which has consigned item (doubled check it from Shipment).
System allows receiving for the unchanged line because receiving
activity for consigned PO will NOT generate any accounting entries, no
impacts. Furthermore, transaction price does not refer to PO, but BPA.
[PO] Exchange Rate for A New Line
I have a PO create months back, exchange rate was captured at the header
level. If i add a new po line now, previous captured rate will be
applied to the line, shipment and distribution, not today's rate.
Double check the exchange rate on Distributions line, under "More" tab.
[PO] Owner Can Approve
Whether a preparer can approve the document, e.g. PR/PO depends on setup in Setup -> Purchasing -> Document Types, if "Owner Can Approve" flag is check, preparer can approve by himself. Means, preparer just need to click "Approve... " and "OK" button, the document will be approved (assume approval limit is satisfied).
However,
if preparer wants to use hierarchy other than default hierarchy, he/she
needs to specified the "Forward To" person to himself. PO will be first changed to " Pre-Approved" status before it get approved eventually.
[PO] Position with Status Blank
[PO] Item Not Found During Purchase Requisition (PR) Creation
In a Operation Unit (OU), I have 2 inventory organization
(inventory child type), e.g. OrgA & OrgB. I need to raise a PR to
purchase ItemC under OrgB. In Item setup, ItemC is created in Inventory
Master org, and assigned to OrgB. Purchasable flag has been checked in both Inventory Master and OrgB. When i keyed in the item during PR creation, item not found, why?
The reason being the OrgA was assigned in Financial Options setup (Setup -> Organizations -> Financial Options), Supplier - Purchasing, Inventory Organization field. If OrgA is assigned, only item assigned to OrgA can be found in the LOV.
We can setup Inventory Master org in each OU, then assign the Inventory Master org in the Financial Options. From there, we can choose any items that was created under the Inventory Master org.
[PO] Backend Field for PR
We know that we can view Purchase Requisition
(PR) number from PO distribution screen (Line -> Shipment ->
Distributions, for standard PO). Which field in the backend table is
used to link to PR tables?
Ans: LINE_LOCATION_ID field in APPS.PO_LINE_LOCATIONS_ALL table that links to APPS.PO_REQUISITION_LINES_ALL table
[PO] Organization And Location At Requisitions Form, Where Can We Set The Default Value For Those?
[PO] Matching Setting in Purchase Order Shipment Line
Invoice matching can be set in five different areas of Oracle Purchasing:
In the list below, a setting at any level will override the settings above it.
1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region
2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region
3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way
4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way
5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region
In the list below, a setting at any level will override the settings above it.
1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region
2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region
3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way
4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way
5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region
Above notes are reproduced from Oracle Support Note:225630.1.
[PO] Where to Setup Invoice Matching Option?
Setup -> Financial Option, Supply - Entry tab, Invoice Matching Option field.
Supply -> Sites, Control tab, Invoice Matching Option field.
(A Setting At Any Level Will Override The Settings Above It)
2 type of options available, Purchase Order / Receipt
[PO] R12 Purchasing Options
Setup -> Organizations -> Purchasing Options
In R11i, it is devided into 5 sections, "Receipt Accounting", "Control", "Default", "Internal Requisition", "Numbering" and "Tax Defaults".
In R12, (this form was converted to JSP format), only 4 sections available (some of the fields been merged), "Document Control", "Document Defaults ", "Receipt Accounting" and "Document Numbering".
New fields in R12:
Document Control
Security Hierarchy
Maximum Attachment Size
Email Attachment Filename
Enforce Supplier Hold
RFQ Required (from "Default" tab in R11i)
Document Defaults
Internal Requisition Order Type (from "Internal Requisition" tab in R11i)
Internal Requisition Order Source (from "Internal Requisition" tab in R11i)
Tax Defaults was removed from Purchasing Options. Need to confirm if it has been permanently removed or moved to other form.
[PO] Self-Billing Flag in PO table
How to know if a Purchase Order (PO) was created under supplier site with Self-Billing?
Not from front end. But check the PAY_ON_CODE field in PO.PO_HEADERS_ALL table. It should reflect "RECEIPT" value.
[PO] APP-PO-14376: Please enter a GL Date within an open purchasing period
[PO] Can I Setup Only Document Total Rule in Approval Group
[PO] Source Field in Purchase Requisition (PR) Screen Does Not Show "Supplier"
[PO] BPA Price Break - Discount (%) field
It is a field to display percentage of discount applied to the new price compare to the very first price.
For example,
Break Price for line 1 = $100, line 2 = $80, line 3 = $70
Value for Discount (%) field fo line 1 = 0, line 3 = 20, line 3 = 30
[PO] Missing Purchase Order (PO) Distribution After RTV - FIXED
With reference back to my problem logged to Metalink TAR, it was fixed after applied patch 4463796.
This patch upgrade the version of PAPOUTLB.pls to 115.3.90.4. Eventhough Project Accounting is not used, but this patch works.
How to check PAPOUTLB.pls version?
SELECT fi.file_id
,filename
,version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'PAPOUTLB.%'
AND ve.file_id = fi.file_id
AND REPLACE(version, '.','') =
(SELECT MAX(TO_NUMBER(REPLACE(version, '.', '')))
FROM apps.ad_file_versions ven
WHERE ven.file_id = fi.file_id);
,filename
,version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'PAPOUTLB.%'
AND ve.file_id = fi.file_id
AND REPLACE(version, '.','') =
(SELECT MAX(TO_NUMBER(REPLACE(version, '.', '')))
FROM apps.ad_file_versions ven
WHERE ven.file_id = fi.file_id);
[PO] APP-PO-14566: Category is invalid, or category is invalid for the item
When you creating a new PR, after entered the category code in Category field, the above message shown. An additional error message also appeared, "APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE. "
The category code is valid, what can be the cause?
Get the default Category Set from Setup -> Items -> Categories -> Default Category Sets
Query Category Sets in Setup -> Items -> Categories -> Category Sets, check "Enforce List of Valid Categories" checkbox. If the checkbox is checked, the category you need to enter must be exist in the list.
[PO] Can I Cancel a "In Process" Purchase Requisition (PR)?
Yes.
Oracle Support references:
"As
per functionality we allow cancel and Finally Close actions on the
requisitions that are in "In Process" status. This is because the
requisition is an internal document and Cancel and Finally Close will
have no difference in the treatment of the requisition after the
action..." -Note:183984.1
"Purchasing
lets you cancel or final close a requisition or requisition line before
your manager approves it or before a buyer places it on a purchase
order..." - Note:223856.1
"Cannot cancel a PO if the status of the PO is 'In Process'" - Note:99831.1
[PO] Contract Purchase Agreement (CPA) - Controls at Amount Agreed
Would I-Procurement (IPROC) validates if the release amount is more than the "Amount Agreed" in a CPA?
IPROC still allows PR and PO to be created, and there is no validation,
till the PO get submitted for Approval. Only at the PO approval time,
system will validate the total releases amount against " Amount Agreed". If total releases more than "Amount Agreed", PO will not get approved.
[PO] Position Hierarchy Used for PR/PO Approval
A
PR/PO was submitted for approval, how to check which Position Hierarchy
user used? From Apps front end, it is impossible. Check it out from
backend tables.
Sample codes:
SELECT
approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT
requisition_header_id FROM apps.PO_REQUISITION_HEADERS_
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
Create a new position, leave the Status field blank, save. Oracle considers it as Valid or Invalid. Ans: Valid
Both values are default from the Employee setup. In Purchasing responsibility, navigate Setup -> Personnel -> Employees, click "More ..." button, move to "Assignment" tab, enter it at Location field.
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
[PO] Receiving for PO with Status "Requires Reapproval"
Standard Purchase Order with 3 lines. I changed line 1 quantity. Header status changed to "Requires Reapproval". In normal scenario, I cannot do anymore Receiving activity as the status is not Approved.
If my changes involved price and currency, receiving activity will
generate accounting entries with wrong amount. A control is needed.
However, for a particular PO, I am able to perform receiving. The PO with "Requires Reapproval"
appeared in the LOV when i tried to perform receiving. I can proceed
further to next screen. However, the line i changed (line 1) is not
appearing. Only the lines that i did not change appeared and allow me to
do receiving. Why?
The reason being the PO is an consigned PO, which has consigned item (doubled check it from Shipment).
System allows receiving for the unchanged line because receiving
activity for consigned PO will NOT generate any accounting entries, no
impacts. Furthermore, transaction price does not refer to PO, but BPA.
[PO] Exchange Rate for A New Line
I have a PO create months back, exchange rate was captured at the header
level. If i add a new po line now, previous captured rate will be
applied to the line, shipment and distribution, not today's rate.
Double check the exchange rate on Distributions line, under "More" tab.
[PO] Owner Can Approve
Whether a preparer can approve the document, e.g. PR/PO depends on setup in Setup -> Purchasing -> Document Types, if "Owner Can Approve" flag is check, preparer can approve by himself. Means, preparer just need to click "Approve... " and "OK" button, the document will be approved (assume approval limit is satisfied).
However,
if preparer wants to use hierarchy other than default hierarchy, he/she
needs to specified the "Forward To" person to himself. PO will be first changed to " Pre-Approved" status before it get approved eventually.
[PO] Position with Status Blank
[PO] Item Not Found During Purchase Requisition (PR) Creation
In a Operation Unit (OU), I have 2 inventory organization
(inventory child type), e.g. OrgA & OrgB. I need to raise a PR to
purchase ItemC under OrgB. In Item setup, ItemC is created in Inventory
Master org, and assigned to OrgB. Purchasable flag has been checked in both Inventory Master and OrgB. When i keyed in the item during PR creation, item not found, why?
The reason being the OrgA was assigned in Financial Options setup (Setup -> Organizations -> Financial Options), Supplier - Purchasing, Inventory Organization field. If OrgA is assigned, only item assigned to OrgA can be found in the LOV.
We can setup Inventory Master org in each OU, then assign the Inventory Master org in the Financial Options. From there, we can choose any items that was created under the Inventory Master org.
[PO] Backend Field for PR
We know that we can view Purchase Requisition
(PR) number from PO distribution screen (Line -> Shipment ->
Distributions, for standard PO). Which field in the backend table is
used to link to PR tables?
Ans: LINE_LOCATION_ID field in APPS.PO_LINE_LOCATIONS_ALL table that links to APPS.PO_REQUISITION_LINES_ALL table
[PO] Organization And Location At Requisitions Form, Where Can We Set The Default Value For Those?
[PO] Matching Setting in Purchase Order Shipment Line
Invoice matching can be set in five different areas of Oracle Purchasing:
In the list below, a setting at any level will override the settings above it.
1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region
2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region
3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way
4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way
5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region
In the list below, a setting at any level will override the settings above it.
1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region
2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region
3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way
4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way
5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region
Above notes are reproduced from Oracle Support Note:225630.1.
[PO] Where to Setup Invoice Matching Option?
Setup -> Financial Option, Supply - Entry tab, Invoice Matching Option field.
Supply -> Sites, Control tab, Invoice Matching Option field.
(A Setting At Any Level Will Override The Settings Above It)
2 type of options available, Purchase Order / Receipt
[GL] Manual Journal Import Needed
User submitted "General Ledger Transfer Program" from AR module, "Journal Import" will be called internally. What happened is "Journal Import"completed error with error, "ORA-01653: unable to extend table GL.GL_IMPORT_REFERENCES by 16 in tab".
GL journal batch is not created.
After DBA fixed the tablespace issue, user reran "General Ledger Transfer Program" as the program says no records to be interfaced, completed warning.
What to do next: Go GL module, Journals->Import->Run, submit journal import with the right Group ID (can be retrieved from "General Ledger Transfer Program" log).
[GL] Receiving Journal Transfer to GL by Journal Import
Related SQL:
SELECT *
FROM apps.gl_interface
WHERE user_je_source_name = 'Purchasing'
AND user_je_category_name = 'Receiving'
In R11i for Inventory Destination Transactions, the Receiving Transaction Processor Debits and Credits the Receiving Account and Inventory AP Accrual Account respectively in GL_INTERFACE and RCV_RECEIVING_SUB_LEDGER. These Transactions in GL_INTERFACE are identified with User_je_source_name ='Purchasing' and user_je_category_name 'Receiving'. In RCV_RECEIVING_SUB_LEDGER these transactions are identified by column accrual_method_flag ='O'
In R11i for Period End Transactions ie Transactions with accrue_on_receipt_flag ='N' in PO_DISTRIBUTIONS_ALL, no accounting transactions are generated on receipt of goods. The Receipt_Accrual_Period-End program generates the Accounting Entries in GL_INTERFACE and RCV_RECEIVING_SUB_LEDGER simultaneously by Debiting Charge Account and Crediting Expense AP Accrual Account. In GL_INTERFACE the Transactions are identified by column names user_je_source_name='
In R11i both On Line Transactions and Period End Transactions are moved from GL_INTERFACE to GL_IMPORT_REFERENCES,GL_JE_
In R12 GL_INTEFACE TABLE is no longer directly used for Receiving Transactions. The Receiving Transaction Processor only populates the RCV_RECEIVING_SUB_LEDGER with Inventory Destination Transactions. The Receipt_Accrual_Period-End program also only populates the RCV_RECEIVING_SUB_LEDGER with Expense Destination Period End Accruals.
Create Accounting-Receiving Concurrent program from Cost Mangement Responsibility transfers the journals in RCV_RECEIVING_SUB_LEDGER to SLA Tables. Once the accounting entries are created in receiving subledger for the receiving transactions, Create Accounting process gets started depending on the profile option CST:Receiving Accounting option and the encumbrance set up.
On submitting this program, it spawns the Accounting program which will do the validations and picks the data from table rcv_receiving_sub_ledger and process it according to the accrual method set for the POs
Depending on the accrual method and the value for profile SLA:Disable journal import, this spawned program "Accounting program" inserts the data into gl_interface first and then calls the Journal import program and posting program and populates the accounting events in subledger table xla_ae_headers and entries in xla_ae_lines and xla_distribution_links.
If there is any problem with the Journal import, the data will get rolled back from gl_interface. Once the Journal import is completed, data will get populated in gl_import_references,gl_je_
......
Refer to Metalink Note 827125.1 for details.
[ALRT] Manually Trigger a Alert
How to manually trigger a Alert which has Frequency set as "On Demand"?
Ans: Under Alert Manager responsibility, Request -> Check, enter Application name, Alert name, Start Date and click "Submit Request".
No comments:
Post a Comment